Python script to scan spreadsheet and export similar data

Selesai Dipasang 5 tahun yang lalu Dibayar saat pengiriman
Selesai 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.

Python Perancangan Perangkat Lunak

ID Proyek: #17084889

Tentang proyek

21 proposal Proyek online Aktif 5 tahun yang lalu

Diberikan kepada:

$25 USD dalam 1 hari
(112 Ulasan)
6.4

21 freelancer rata-rata menawar $40 untuk pekerjaan ini

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 Lebih banyak

$50 USD dalam 1 hari
(442 Ulasan)
7.6
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 Lebih banyak

$35 USD dalam 10 hari
(55 Ulasan)
5.6
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 dalam 2 hari
(20 Ulasan)
5.1
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 Lebih banyak

$60 USD dalam 2 hari
(64 Ulasan)
5.3
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 Lebih banyak

$50 USD dalam 1 hari
(29 Ulasan)
5.1
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 Lebih banyak

$45 USD dalam 10 hari
(30 Ulasan)
5.2
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 dalam 2 hari
(10 Ulasan)
3.8
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 Lebih banyak

$35 USD dalam 1 hari
(2 Ulasan)
2.5
POertel

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

$50 USD dalam 2 hari
(0 Ulasan)
2.0
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 dalam 10 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0