Completed

Python script to scan spreadsheet and export similar data

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.

Skills: Python, Software Architecture

See more: python script open read file parse data, script php export database data xml, python script rs232 data, python read xls, python excel to database, read xlsx file in python, python spreadsheet, python code to extract data from excel, load excel python, read a column from excel in python, plotting excel data in python, android, data processing, python, web scraping, django, web development, flask, ios, csv

About the Employer:
( 82 reviews ) Fort Worth, United States

Project ID: #17084889

Awarded to:

$25 USD in 1 day
(95 Reviews)
5.9

26 freelancers are bidding on average $42 for this job

gangabass

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 More

$50 USD in 1 day
(285 Reviews)
7.0
rishiajmera

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 More

$35 USD in 10 days
(44 Reviews)
5.4
prajwalbhatt

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 More

$45 USD in 10 days
(28 Reviews)
5.2
mbs1092

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 More

$50 USD in 1 day
(27 Reviews)
4.8
expertatwork

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 More

$60 USD in 2 days
(54 Reviews)
5.1
$35 USD in 1 day
(4 Reviews)
4.7
marcellp

I have read your description about the [login to view URL] and spreadsheet project. I feel like I am qualified to do this project, I have demonstrated experience on this site developing solutions for Python-based projects and I fee More

$45 USD in 5 days
(20 Reviews)
4.2
redincorpindia

Dear client I saw your requirements regarding the gz compressed csv file read and manipulation application development. I can develop this application within a day maximum based on your requirements. I developed sim More

$50 USD in 1 day
(9 Reviews)
4.2
roshansanthoshh

Business analyst in multinational firm with extensive experience in Machine Learning/Data processing "[login to view URL]" : Can get my full credentials here, including various courses and pro More

$40 USD in 3 days
(7 Reviews)
3.2
AhmadSameer

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

$50 USD in 2 days
(3 Reviews)
2.9
$45 USD in 1 day
(5 Reviews)
2.1
peng72083

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.

$111 USD in 1 day
(2 Reviews)
2.1
rupeshkarna11

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 More

$35 USD in 1 day
(1 Review)
2.4
youssefelhady

Hello sir, i will use python in order to extract the data from the input excel file to a new csv file.

$50 USD in 2 days
(1 Review)
1.8
$28 USD in 2 days
(2 Reviews)
1.1
maheshk421

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 .

$17 USD in 10 days
(0 Reviews)
0.0
techunleashed

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

$15 USD in 2 days
(0 Reviews)
0.0
$33 USD in 3 days
(0 Reviews)
0.0
$55 USD in 3 days
(0 Reviews)
0.0
PiushGoutam2018

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.

$20 USD in 10 days
(0 Reviews)
0.0