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
  Running A Parser In VSCode - And Write The Results Into A Csv-File apollo 5 229 Jan-14-2021, 08:58 PM
Last Post: snippsat
  Is there anyway to make a .py file into a .exe file? Oshadha 2 125 Jan-13-2021, 04:58 AM
Last Post: Oshadha
  Data extraction from a table based on column and row names tgottsc1 1 100 Jan-09-2021, 10:04 PM
Last Post: buran
  Sort data from JSON file Dummy_in_programming 2 100 Jan-04-2021, 06:17 PM
Last Post: deanhystad
  Problems Sorting Data in an External File (.txt) Superlegend21 1 137 Dec-27-2020, 10:06 PM
Last Post: Superlegend21
  [split] How to convert the CSV text file into a txt file Pinto94 5 159 Dec-23-2020, 08:04 AM
Last Post: ndc85430
  How to fill parameter with data from multiple columns CSV file greenpine 1 103 Dec-21-2020, 06:50 PM
Last Post: Larz60+
  xml file creation from an XML file template and data from an excel file naji_python 1 121 Dec-21-2020, 03:24 PM
Last Post: Gribouillis
  how to automate sending bulk emails from an excel file or a calc-file apollo 0 164 Dec-10-2020, 08:43 PM
Last Post: apollo
  how to change the range of read CSV file every time python file runs greenpine 6 235 Dec-08-2020, 10:11 PM
Last Post: greenpine

Forum Jump:

User Panel Messages

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