I read data from an excel file, it is like this: Que
It is in a data frame format.I want the modified data frame as below:
Sem1 Sem2 Sem3
50 36 28
45 41 47
50 48 43
I have used below code:
for f in lparameters:
print("Creating Column:" ,f)
df_temp[f]=dfs["Total"].get_group(f)
But this code the only one (first column).
Please help me out !!
You can use set_index with cumcount and reshape by unstack:
df = df.set_index([df.groupby('Sem').cumcount(), 'Sem'])['Total'].unstack()
print (df)
Sem Sem2 Sem3 Seml
0 36 28 50
1 41 47 45
2 48 43 50
Another solution is create list per group and then use DataFrame constructor:
a = df.groupby('Sem')['Total'].apply(list)
df = pd.DataFrame(a.values.tolist(), index=a.index).T
print (df)
Sem Sem2 Sem3 Seml
0 36 28 50
1 41 47 45
2 48 43 50
