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
  Creating csv file from another file pisike 0 34 9 hours ago
Last Post: pisike
  Saving text file with a click: valueerror i/o operation on closed file vizier87 5 301 Nov-16-2020, 07:56 AM
Last Post: Gribouillis
  Writing to file in a specific folder evapa8f 5 194 Nov-13-2020, 10:10 PM
Last Post: deanhystad
  Find frequencies of an audio file at a specific time via librosa jberesford123__ 0 109 Oct-21-2020, 01:18 PM
Last Post: jberesford123__
  Convert file of hex strings to binary file medatib531 4 310 Oct-09-2020, 05:42 PM
Last Post: DeaD_EyE
  list from a data file problem Marre 3 545 Sep-22-2020, 07:55 AM
Last Post: Marre
  Exporting Stock Fundamental Data to a CSV file with yahoo_fin DustinKlent 0 258 Sep-13-2020, 12:01 AM
Last Post: DustinKlent
  saving data from text file to CSV file in python having delimiter as space K11 1 239 Sep-11-2020, 06:28 AM
Last Post: bowlofred
  How to merge three DataFrames based on specific column Mekala 0 232 Sep-08-2020, 02:01 PM
Last Post: Mekala
  Trouble with reading csv file and putting it into a file Milfredo 3 309 Sep-04-2020, 05:30 AM
Last Post: Milfredo

Forum Jump:

User Panel Messages

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