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


Messages In This Thread
Process Data from one csv file and write to another CSV file specific column - by ajin9581 - Jun-17-2020, 05:44 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  encrypt data in json file help jacksfrustration 1 65 Yesterday, 05:16 PM
Last Post: deanhystad
  Help copying a column from a csv to another file with some extras g0nz0uk 3 403 Feb-01-2024, 03:12 PM
Last Post: DeaD_EyE
  Extracting specific file from an archive tester_V 4 428 Jan-29-2024, 06:41 PM
Last Post: tester_V
  Last record in file doesn't write to newline gonksoup 3 364 Jan-22-2024, 12:56 PM
Last Post: deanhystad
  How should I process this data? SuchUmami 2 347 Jan-13-2024, 05:30 PM
Last Post: RockBlok
  data validation with specific regular expression shaheen07 0 296 Jan-12-2024, 07:56 AM
Last Post: shaheen07
  file open "file not found error" shanoger 8 946 Dec-14-2023, 08:03 AM
Last Post: shanoger
  How would I process this data? SuchUmami 2 515 Nov-12-2023, 10:05 AM
Last Post: SuchUmami
  write to csv file problem jacksfrustration 11 1,373 Nov-09-2023, 01:56 PM
Last Post: deanhystad
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,314 Nov-09-2023, 10:56 AM
Last Post: mg24

Forum Jump:

User Panel Messages

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