sono un panda dataframme con le colonne nome , scuola e marchi
name school marks
tom HBS 55
tom HBS 55
tom HBS 14
mark HBS 28
mark HBS 19
lewis HBS 88
Come recepire e la conversione in come questo
name school marks_1 marks_2 marks_3
tom HBS 55 55 14
mark HBS 28 19
lewis HBS 88
provato questo:
df = df.pivot_table(index='name', values='marks', columns='school') \
.reset_index() \
.rename_axis(None, axis=1)
print(df)
df = df.pivot('name','marks','school')
verificato il link
https://stackoverflow.com/questions/22798934/pandas-long-to-wide-reshape-by-two-variables
https://stackoverflow.com/questions/62391419/pandas-group-by-and-convert-rows-into-multiple-columns
https://stackoverflow.com/questions/60698109/pandas-multiple-rows-to-single-row-with-multiple-columns-on-2-indexes
questo errore a causa di valori duplicati. come gestire se duplicato esiste e dobbiamo tenerli
ValueError: Index contains duplicate entries, cannot reshape