Hello to the whole community:
I have a question, and I want to ask for help, please.
I have a data frame, with data between 0 and 1 (see the image). The data can be for example 0 or also 0.45, etc.
I need to rewrite that table, but by categories or sections, that is, for example, all the numbers that are between 0 and 0.2, replace them with 0.1. If the numbers are between 0.5 and 0.78556, it should be replaced by 0.6 (this is just an example).
How could I do it? I was thinking of something like:
for i in dataframe1[0:23]:
for j in dataframe1.index:
if 0<dataframe1.getloc[j,i]<10: dataframe2=dataframe1.replace(dataframe1.loc[j,i],8)
But I have not had good results.
I would appreciate any help, please.