Python Forum
Process Data from one csv file and write to another CSV file specific column
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Process Data from one csv file and write to another CSV file specific column
Need Help on Process data in CSV file

We are automating the Backup report and the raw data contains 5 Master Servers Data Like below in one CSV file backup.csv

Master Server Job Primary ID Status Code Job Start Time Media Server Client Name Policy Name

I want to extract data based on Server1 ,2,3,4,5, and summarize in other CSV file backup_summary.csv

I can able to achieve it based on VB
what have you tried? We are glad to help, but we are not going to do it for you.
Post your code in python tags, any traceback - in error tags, ask specific questions.
Sample input data and expected output will help to understand your case...
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs


Possibly Related Threads…
Thread Author Replies Views Last Post
  Subprocess.Popen() not working when reading file path from csv file herwin 13 388 May-07-2021, 03:26 PM
Last Post: herwin
  code for CSV file to html file without pandas jony057 1 169 Apr-24-2021, 09:41 PM
Last Post: snippsat
  How to make a test data file for the full length of definition? MDRI 6 436 Apr-16-2021, 01:47 AM
Last Post: MDRI
  Copy column from one existing excel file to another file mkujawsk 0 222 Apr-14-2021, 06:33 PM
Last Post: mkujawsk
  blank graph with matplotlib from a csv file / data type issue arsentievalex 0 148 Apr-06-2021, 10:08 AM
Last Post: arsentievalex
  Remove single and double quotes from a csv file in 3 to 4 column shantanu97 0 244 Mar-31-2021, 10:52 AM
Last Post: shantanu97
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 187 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  Move file from one folder to another folder with timestamp added end of file shantanu97 0 201 Mar-22-2021, 10:59 AM
Last Post: shantanu97
  data iteration in a file chris1 2 292 Mar-18-2021, 09:36 AM
Last Post: chris1
  Annotating plot bar from values of other a specific column celinafregoso99 0 258 Mar-10-2021, 03:19 PM
Last Post: celinafregoso99

Forum Jump:

User Panel Messages

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