python pandas change columns to rows

Question

I have this data frame using python and this is the result I wanted after cleaned and analyzing the data

but I wanted in this format how can I do this in pandas python formt I eant

Please provide enough code so others can better understand or reproduce the problem. — Community
– Community Bot, Commented Jun 26, 2022 at 16:45
you can use melt or transpose. if you need more control of the matrix use pivot table — ListenSoftware Louise Ai Agent
– ListenSoftware Louise Ai Agent, Commented Jun 27, 2022 at 15:48

ragas · Accepted Answer · 2022-06-27 15:43:22Z

1

Hopefully this is what you are looking for.

df = pd.DataFrame({'status': ['cancelled', 'failed', 'pending', 'ticketed'],
                   'new': [511, 5561, 105, 2115],
                   'atc': [97, 580, 10, 646]})



df1 = pd.melt(df, id_vars=['status'], value_vars=['new', 'atc'], value_name='value' ).sort_values('status')

print(df1)



   status variable  value
0  cancelled      new    511
4  cancelled      atc     97
1     failed      new   5561
5     failed      atc    580
2    pending      new    105
6    pending      atc     10
3   ticketed      new   2115
7   ticketed      atc    646

answered Jun 27, 2022 at 15:43

ragas

9164 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

python pandas change columns to rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related