I have a pandas dataframe that looks like this:
How do I convert it to this:
Asked
Active
Viewed 23 times
-1
-
It does not. I want and exact replacement. The resulting table should have 5 lesser rows. Pivot does convert into two columns but existing 9 rows remain. – Zeeshan Asghar Nov 09 '22 at 02:19
-
1No images, refer to the guidelines here https://stackoverflow.com/help/how-to-ask – Naveed Nov 09 '22 at 02:44
-
whats the result of the Pivot, in your attempt? please share – Naveed Nov 09 '22 at 02:45
1 Answers
1
As you said that the number of x and y are same,
'''
df = pd.DataFrame({
'category' : ['x'] * 5 + ['y'] * 5,
'values' : [i for i in range(1, 11)]
})
'''
category_dic = {'x' : [], 'y' : []}
for row in range(len(df)):
category_dic[df.loc[row, 'category']].append(df.loc[row, 'values'])
df_1 = pd.DataFrame(category_dic)
Output :
>>> df_1
x y
0 1 6
1 2 7
2 3 8
3 4 9
4 5 10
※ Edit version(not using globals)
jaemmin
- 341
- 1
- 12
-
x and y are same in number. But I do want to avoid defining globals. Your output is exactly what I want, yet is there no other (pandas) way of solving this? – Zeeshan Asghar Nov 09 '22 at 03:00