Split rows into columns in pandas

Asked Jun 15 '20 at 12:48

Active Jun 15 '20 at 12:48

Viewed 16 times

I have situation in which the following data frame:

case_id      case_lang     case_text
1            en            ABC
2            fr            BCDS
3            ru            TTTT
4            hi            WEWE

df['case_lang'].value_counts() will give en,fr,eu,hi

should get split like this:

    case_id      case_lang_en    case_lang_fr    case_lang_ru      case_lang_hi 
    1             ABC
    2                            BCDS
    3                                            TTTT
    4                                                               WEWE

and this should be dynamic in nature. For example, if there are any new rows are added that do not fall under the previous category of values, for example de is added then it should automatically be split up and shown as new columns for de as well like case_lang_de

asked Jun 15 '20 at 12:48

Django0602

1

This is called "pivoting data". – Erfan Jun 15 '20 at 12:51
1

`df.pivot_table(index='case_id', columns='case_lang', values='case_text', aggfunc=lambda x: x, fill_value='')` – Erfan Jun 15 '20 at 12:52
Perfect! this will work! Thanks! – Django0602 Jun 15 '20 at 12:56

Split rows into columns in pandas

0 Answers0