Big Data Manipulations with Python

Question

I have Data looking like this:

Animal Day Food kg
1      1   17   0.1
1      1   22   0.7
1      2   17   0.8
2      2   15   0.1

I would like to have a table looking like this:

Animal Food Day1 Day2 ...
1      17   0.1  0.8  ...
1      22   0.7       ...
2      15        0.1

I was able to make it work on a small data set with copying the dataframe and merging the copies. However this seems very inefficient to me. So I was wondering what would be done to make it work on a bigger data set?

What dataframe library are you using? For reference, this type of operation is typically called a "pivot". — 0x5453, Sep 22 '21 at 12:54
Does this answer your question? [Python Pandas: Convert Rows as Column headers](https://stackoverflow.com/questions/17298313/python-pandas-convert-rows-as-column-headers) — Maaz, Sep 22 '21 at 12:57

score 1 · Accepted Answer · answered Sep 22 '21 at 12:58

1

Try with pivot:

output = df.pivot(["Animal", "Food"], "Day", "kg") \
           .add_prefix("Day") \
           .reset_index() \
           .rename_axis(None, axis=1)

>>> output
   Animal  Food  Day1  Day2
0       1    17   0.1   0.8
1       1    22   0.7   NaN
2       2    15   NaN   0.1

answered Sep 22 '21 at 12:58

not_speshal

20,086
2
13
28

This worked. (after removing duplicates with groupby). – MatheMarco Sep 23 '21 at 16:23

Big Data Manipulations with Python

1 Answers1