我如何在Python中使用Pandas 制作这个表格:
Data=[[‘4/04/2023’，‘Floor’，‘Tables’，‘Roof’，‘Paint’，‘]，[’4/05/2023‘，’‘，’Floor‘，’Tables‘，’Roof‘，’Paint‘]，[’4/06/2023‘，’Paint‘，’Floor‘，’Tables‘，’Roof‘，’‘，‘Floors’，‘Tables’]]
Df=pd.DataFrame(数据，列=[‘Date’，‘Jim’，‘Bob’，‘Ed’，‘James’，‘Joe’])
Look like this? I think I have to use melt and Pivot, but I can't figure out how to get it to work.
我命令你这么做的，go 查清楚:
#let's create some initial data
data = [['4/04/2023','Floors','Tables','Roof','Paint',''],['4/05/2023','','Floors','Tables','Roof','Paint'],['4/06/2023','Paint','','Floors','Tables','Roof'],['4/07/2023','Roof','Paint','','Floors','Tables']]
df = pd.DataFrame(data, columns=['Date', 'Jim','Bob','Ed','James','Joe'])
#apply the transformations
df2 = df.melt(id_vars="Date", value_name='Items')
df3 = df2.pivot(index="Date", columns='Items', values='variable')
df3 = df3[["Floors","Tables","Roof", "Paint"]] #change the order
As a result I got this:
