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
#1
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
Server1
Server2
Server3
Server4
Server5

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
Reply
#2
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

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Running A Parser In VSCode - And Write The Results Into A Csv-File apollo 5 235 Jan-14-2021, 08:58 PM
Last Post: snippsat
  Is there anyway to make a .py file into a .exe file? Oshadha 2 134 Jan-13-2021, 04:58 AM
Last Post: Oshadha
  Data extraction from a table based on column and row names tgottsc1 1 108 Jan-09-2021, 10:04 PM
Last Post: buran
  Sort data from JSON file Dummy_in_programming 2 107 Jan-04-2021, 06:17 PM
Last Post: deanhystad
  Problems Sorting Data in an External File (.txt) Superlegend21 1 144 Dec-27-2020, 10:06 PM
Last Post: Superlegend21
  [split] How to convert the CSV text file into a txt file Pinto94 5 166 Dec-23-2020, 08:04 AM
Last Post: ndc85430
  How to fill parameter with data from multiple columns CSV file greenpine 1 108 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 125 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 168 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 239 Dec-08-2020, 10:11 PM
Last Post: greenpine

Forum Jump:

User Panel Messages

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