convert rows into columns according to data of cells?

Asked Jul 28 '20 at 05:48

Active Jul 28 '20 at 05:53

Viewed 33 times

input:

    Date       Region   Value
0   01-07-2020  IN     8.8794
1   01-07-2020  ROW    2.1990
2   01-07-2020  UK     8.1226
3   01-07-2020  US     6.9386
4   02-07-2020  IN     9.0087

output:

            Date        IN       ROW      US        UK

    0      01-07-2020   8.8794   2.1990  6.9386    8.1226 
    1      02-07-2020  9.0087    NaN    NaN       Nan

output be look like above. any help is appreciated.

edited Jul 28 '20 at 05:53

asked Jul 28 '20 at 05:48

Thrinadh Kasu

Use `df.pivot('Date', 'Region', 'Value')` – Shubham Sharma Jul 28 '20 at 05:50
@ Shubham Sharma, Thank you very much. – Thrinadh Kasu Jul 28 '20 at 05:59

convert rows into columns according to data of cells?

0 Answers0