I tried searching it on stack overflow, and I got a lot of similar titles but the problem isn't quite the same (it appears very different). Also, read some of the documentation (not all from Pandas) but couldn't find any method to do this.
Suppose I have a dataframe like:
How do I combine this into one row in Pandas? That is, how can I have one line with the values:
0.000181 0.10139 0.009276 ... 0.0043778 ... 0.001094 0.004550 0.002879 ... 0.000435 0.003431 ...
Literally that's all I was trying to find. These other things are suggesting I do a group by, or a join, or something.
CodePudding user response:
rows=[] #initiate a list to store each row
for i in range(len(df)):
temp=df.loc[[i]] #extract each row
temp.columns=np.arange(i*len(temp.columns),(i 1)*len(temp.columns)) #rename column of each row
temp.reset_index(drop=True, inplace=True) #drop index
rows=rows [temp] #add it to the list of rows
output=pd.concat(rows,axis=1) #concat the list of rows by column