Python Forum
Read and write data to CSV files
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Read and write data to CSV files
#1
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.
Reply
#2
Take a look at the python docs: CSV File Reading and Writing
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help with to check an Input list data with a data read from an external source sacharyya 3 317 Mar-09-2024, 12:33 PM
Last Post: Pedroski55
  Is it possible to extract 1 or 2 bits of data from MS project files? cubangt 8 937 Feb-16-2024, 12:02 AM
Last Post: deanhystad
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,303 Nov-09-2023, 10:56 AM
Last Post: mg24
Question Special Characters read-write Prisonfeed 1 579 Sep-17-2023, 08:26 PM
Last Post: Gribouillis
  How do I read and write a binary file in Python? blackears 6 6,000 Jun-06-2023, 06:37 PM
Last Post: rajeshgk
  script to calculate data in csv-files ledgreve 0 1,054 May-19-2023, 07:24 AM
Last Post: ledgreve
  Read text file, modify it then write back Pavel_47 5 1,498 Feb-18-2023, 02:49 PM
Last Post: deanhystad
  How to read in mulitple files efficiently garynewport 3 844 Jan-27-2023, 10:44 AM
Last Post: DeaD_EyE
  Correctly read a malformed CSV file data klllmmm 2 1,812 Jan-25-2023, 04:12 PM
Last Post: klllmmm
  how to read txt file, and write into excel with multiply sheet jacklee26 14 9,501 Jan-21-2023, 06:57 AM
Last Post: jacklee26

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020