Python script to scan spreadsheet and export similar data
$10-50 USD
Dibayar saat pengiriman
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.
ID Proyek: #17084889
Tentang proyek
Diberikan kepada:
21 freelancer rata-rata menawar $40 untuk pekerjaan ini
I'll provide you Python script that will read two input CSV files (from .gz archives) and next read CIDR from one file and export all IP addresses (with several other columns) that belongs to this CIDR into output file Lebih banyak
Hello, Greetings! With a proven track record of successful achievements, I am pleased to present my application for your consideration as a Freelancer. Please have a look at my profile and portfolio to get an idea o Lebih banyak
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
Hi there, thanks for the detailed information. Yes, I can develop an application that uncompresses gz and read ip data and compare with other csv file to create the final report. Also, why are we preferring python? Ple Lebih banyak
Hi, I have downloaded the files from dropbox and have reviewed your project requirements. I feel confident that I can complete this project within a day. I am proficient with the Python scripting language, as well Lebih banyak
I am Prajwal Bhatt, a recent graduate from IIT Roorkee. I am a creative, flexible and focused individual who is passionate about Data Science, Natural Language Processing and the entire Analytics space. I have acquired Lebih banyak
Hello sir, i will use python in order to extract the data from the input excel file to a new csv file.
Hello! I am the man for this job. My name is Rupesh and I am Computer Engineering graduate. I have been programming in Python for almost 3 years and since everybody tells me I am good at solving problems, I have dec Lebih banyak
I understand your project specs, and I should be able to get something like this done in just a couple days. I noticed that you put Python as a required skill for this project. Would you prefer the product be a python Lebih banyak
Hey . I would like to do this work for you . I have experience in Python and other software languages . looking forward to work with you .
I've done some similar and a much more complex work a while back and should not take me much time to finish your job