majú pandy dataframme so stĺpcami meno , školu a známky
name school marks
tom HBS 55
tom HBS 55
tom HBS 14
mark HBS 28
mark HBS 19
lewis HBS 88
Ako transponovať a previesť do takhle
name school marks_1 marks_2 marks_3
tom HBS 55 55 14
mark HBS 28 19
lewis HBS 88
snažil tento:
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')
kontrolovať tieto odkazy
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
ako túto chybu kvôli duplicitné hodnoty. ako zvládnuť ak duplicitné existuje a máme ich udržať
ValueError: Index contains duplicate entries, cannot reshape