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
  Python Pandas: How do I extract all the >1000 data from a certain column? JaneTan 0 191 Jul-17-2021, 09:09 AM
Last Post: JaneTan
  [Solved] Plotting data from txt file Laplace12 1 188 Jul-06-2021, 07:14 AM
Last Post: Laplace12
  Read and write active Excel file euras 4 359 Jun-29-2021, 11:16 PM
Last Post: Pedroski55
  [Solved] Reading every nth line into a column from txt file Laplace12 7 461 Jun-29-2021, 09:17 AM
Last Post: Laplace12
Lightbulb [Solved] df.loc: write data in certain rows ju21878436312 1 248 Jun-28-2021, 06:49 AM
Last Post: ju21878436312
  [Solved] Trying to read specific lines from a file Laplace12 7 507 Jun-21-2021, 11:15 AM
Last Post: Laplace12
  [Solved] Using readlines to read data file and sum columns Laplace12 4 302 Jun-16-2021, 12:46 PM
Last Post: Laplace12
  Fitting Gaussian curve to data file Laplace12 0 273 Jun-09-2021, 10:45 AM
Last Post: Laplace12
  Read file, reformat and write new file bryanmartin113 1 337 Jun-08-2021, 09:27 PM
Last Post: Larz60+
  How to save modification of a file in original file not a new one? mjrezayani 3 558 Jun-04-2021, 01:28 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

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