+- 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: Read and write data to CSV files (/thread-16726.html)
Read and write data to CSV files - kartik - Mar-12-2019
My excel file name is Test.xls
Column A has 1000 rows. Each row has both char and int.
Eg. Tool cost for part no. 1236576
Mould for 5475943 for WER
I want a python code that will read column A, separate Integers from the sentence and paste the output in Column B.
Eg.
Column A ----------------- Column B
Tool cost for part no. 1236576 ----------------- 1236576
Mould for 5475943 for WER ----------------- 5475943
Can anyone help me with coding.
RE: Read and write data to CSV files - Yoriz - Mar-12-2019
Take a look at the python docs: CSV File Reading and Writing