Parser to adapt the format of 655 zipped csv files

Peruttu Julkaistu 4 vuotta sitten Maksettu toimituksen yhteydessä
Peruttu Maksettu toimituksen yhteydessä

Parser to adapt the format of 655 zipped csv files to a given CSV format, cross-referencing with a given parameter list on a separate excel spreadsheet.

We have 655 zipped csv files with over 200000 rows and 5 columns that need to be adapted to a different csv format.

Starting file contains the following info:

Column A: Row number + 1

Column B: Device ID

Column C: Device value

Column D: Timestamp in dd/mm/yyyy hh:mm:ss format

Column E: 0

First row info can be discarded for the target file. Columns A and E are to be discarded.

Target file format is as follows:

Column A: Time zone, which will always be the same string for all rows. For example: Europe/Paris

Column B: Timestamp in yyyy/mm/dd hh:mm:ss format

Column C: Device ID

Column D: Parameter Key

Column E: Device value

The relation between the Device ID and the Parameter key is stored in a separate file to be provided. The csv files are encoded in Unicode UTF-8 format with a semicolon “;" as separator and quotes to contain the strings in each column. Attached examples of starting and target files are included. Decimal separator is the dot “.”

We request a quotation and time estimate for the development of an application that parses the 655 files to create the new files in the template format. Preferred languages: Python and Java.

Tiedonsyöttö Tietojenkäsittely Python Java

Projektin tunnus: #22146588

Tietoa projektista

25 ehdotusta Etäprojekti Aktiivinen 4 vuotta sitten

25 freelanceria on tarjonnut keskimäärin €120 tähän työhön

e3d

I can do one-liner for that using awk or write pytohon or java code if absolutely necessary, but this is an easy task that what we usually solve by shell scripting

€99 EUR 1 päivässä
(252 arvostelua)
8.7
bouslimi1979

Hi, I can create an Excel/VBA app where you will select the folder containing the 655 csv, and also the target folder, and the code will loop throught all the files and generate the new one. Thanks

€140 EUR 3 päivässä
(238 arvostelua)
7.7
gangabass

I can provide you a Python script that will quickly process all 655 CSV files you have and generate another CSV output. I can complete it in less than 24 hours for just 90 EUR. All I need to start is some samples from Lisää

€90 EUR 1 päivässä
(371 arvostelua)
7.4
zekovicm

Hi there,I am Python expert from Bosnia & Herzegovina,Europe. I would need around 6-10h to create this parser for you . Check out my profile and former clients feedback - that'll let you know everything about me. P Lisää

€175 EUR 3 päivässä
(170 arvostelua)
7.6
zExcel

Hi, I'd be happy to help you with this project. Let me know if you decide to select me for this job. . .

€125 EUR 2 päivässä
(117 arvostelua)
7.0
mananraja

HEY, I have read your details and seen the attached CSV files. I can make you a program to do this format conversion. The program will be made using PYTHON. I would love to talk more with you in chat.

€70 EUR 1 päivässä
(110 arvostelua)
6.0
speerbuccoss

Hello, My name is Shameem and I’m a java expert. I can build a problem for you to read all the 655 csv file and convert it to the target file (as attached). Could you also pls share the file containing the parameter Lisää

€100 EUR 2 päivässä
(25 arvostelua)
5.1
DebasisB

Hello there, I am interested in the project. I can write the parser in java to generate the file exactly as per your specification. The time to delivery is 2 days. Thanks.

€225 EUR 3 päivässä
(9 arvostelua)
4.9
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Lisää

€75 EUR 2 päivässä
(37 arvostelua)
5.1
greenguru2018

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is Lisää

€140 EUR 7 päivässä
(14 arvostelua)
4.5
goodwork20k

I am good in powershell and along with automation and csv handling..please let me know if you are good to award this project to me Your Preferred languages: Python and Java but in powershell we can do it quickly becau Lisää

€120 EUR 2 päivässä
(1 arvostelu)
2.2
raevbin

Hey. This is a simple task. I will do it in one day. The price will be minimal.

€40 EUR 1 päivässä
(2 arvostelua)
2.3
jk31

I can solve the problem within 2 hours If not, you get all money back. (I am so sure, because I already solved big parts of the problem yesterday). Please write to me and hire me - I can show you immediately the code.

€30 EUR 1 päivässä
(4 arvostelua)
1.9
kkinfotech099

Thanks for your posting      I checked your requirements and I have experience in similar work and can do demo WORK FREE If you like my trial work then we have deal or you dont have to pay anything For trial work p Lisää

€140 EUR 7 päivässä
(0 arvostelua)
0.0
Karanpratapsi

send parasol you received this message is intended only for the first time we are going to be a good day at work and

€55 EUR 7 päivässä
(0 arvostelua)
0.0
ArashAmin89

I am a super quick person. I bid a reasonable price for this project because it is easy for me. I am interested in this field.

€120 EUR 7 päivässä
(0 arvostelua)
0.0
Parvbansal160

Hello i'm Parvinder Bansal i have 5 years+ Experience in data entry. If you give me a chance to work for you so damn sure I'll definitely Satisfied you from my work. Relevant Skills and Experience I have experience a Lisää

€155 EUR 3 päivässä
(0 arvostelua)
0.0
tiruvakp

Hi, I have worked on finance project before in a MNC where I have implemented Java application to parse and read csv files. I can implement this project in Java and deliver in the given time with high quality. Looki Lisää

€222 EUR 7 päivässä
(0 arvostelua)
0.0
pruthiraj4628

I can type 10 word /sec speed i have I am the best in data entry . i can work for any time . i am good in typing

€200 EUR 10 päivässä
(0 arvostelua)
0.0
hayasnc

Hi, I'm planned to do this Python. I have experience in writing script for various data processing. I'm confident I can do this in your budget

€138 EUR 3 päivässä
(0 arvostelua)
0.0