Python Forum
splitting a csv file to create another csv - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: splitting a csv file to create another csv (/thread-31125.html)



splitting a csv file to create another csv - pisike - Nov-24-2020

0


I have a csv file that as data as below in two columns

"ou=People, o=ic.com,o=xerox",{}

"uid=test.test30,ou=People,o=ic.com,o=xerox","{'claimnumber': ['XXX'], 'idnumber': ['44430']}"

I need to create a new csv file with below as the fields

claimnumber, idnumber
,
XXX, 44430

Any help?


RE: splitting a csv file to create another csv - Larz60+ - Nov-24-2020

what have you tried so far?


RE: splitting a csv file to create another csv - Superjoe - Nov-25-2020

(Nov-24-2020, 04:39 PM)Larz60+ Wrote: what have you tried so far?

Agree Larz60+, show your original code.


RE: splitting a csv file to create another csv - pisike - Nov-25-2020

I am new to python and couldn't make a head start


RE: splitting a csv file to create another csv - Larz60+ - Nov-25-2020

You should take a tutorial before continuing. You will learn nothing if we do it for you.
I suggest one of:
How to Think like a Computer Scientist: Interactive Edition
or
Python Tutorial