Python - Convert Row To Column In CSV File

July 25, 2017 at 20:11:02
Specs: Windows 7, 4
I have a an excel file which looks something like this:

A B C Measure Names Measure Values
Business Associate AB Inquiries 30,356
Business Associate ZY Master Lead 5,387
Business Associate XY Shipped Leads 6,430

I want column 4 and 5 to be pivoted.
So the final output will look like this:

A B C Inquiries Master Leads Shipped Leads
Business Associate AB 0 0 1
Business Associate ZY 0 0 10
Business Associate XY 0 0 14

Can some one please help me with this. I am not sure how you will do this using batch. Again I want to pivot only the column 4 and 5.

Thanks in advance.


See More: Python - Convert Row To Column In CSV File

Reply ↓  Report •

#1
July 26, 2017 at 00:16:54
Here column 4 and 5 are : Measure Names and Measure Values from the 1st table.

Reply ↓  Report •

#2
August 27, 2017 at 03:51:21
It's too difficult and no reasons now to do it.

Reply ↓  Report •
Related Solutions


Ask Question