I need a script written that will accept two input files and generate a third file as an output.
What the script needs to do is the following:
Read a compressed “.gz” file and put the contents into memory. The .gz file will contain a spreadsheet containing many rows and columns of data. What we are interested in is Column K labeled “CLIENT_IP_ADDRESS”. This column contains IP addresses that we will scan and, based on input parameters, copy select IP addresses from this column and insert them into a new output CSV file.
The second input file is a CSV containing IP addresses in Column A. We are interested in exporting all similar IP addresses from the compressed .gz file. This is done by scanning the contents of the compressed .gz file and exporting all IP addresses of the same CIDR as the other input file’s IP addresses.
We are interested in finding all IP addresses of the same CIDR in the compressed .gz file. All of these
1 – Read compressed “.gz” file and place the contents of Column K into memory
2 – Scan an input CSV
3 – For the first ip address in the input CSV, scan all the contents of Column K and export any ip addresses with the same CIDR
4 – export these ip addresses to a new CSV file, and copy what was in columns B, C and D in the original input file into the new output file.
I have included a dropbox link containing sample input file, compressed .gz file, and output file for your review so you can get a better idea of the desired output. The files can be seen here: [login to view URL]
Thank you for your assistance. Please include a brief description in your PM along with your bid so I can tell that you actually read the project description instead of using an auto-bidder to bid on the project. Just a sentence or two will do.
26 freelancers are bidding on average $42 for this job
Hi there I'm interested I read the project description I'm downloading the sample files to check. I'm a System Engineer with coding skills. I had done many projects using Python I can help
Hello, how are you? I'm a senior python developer. Read and parse, create new csv, xls file is easy for me. I will do within few hours. Best regard. Thanks.
Hi, I have done 10+projects based on .csv and .xlsx and excel automation using python. I have read your project details and can deliver it to you within your specified deadline. Looking forward to working with you.