Parser to adapt the format of 655 zipped csv files
€30-250 EUR
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.
Projektin tunnus: #22146588
Tietoa projektista
25 freelanceria on tarjonnut keskimäärin €120 tähän työhön
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
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
Hi, I'd be happy to help you with this project. Let me know if you decide to select me for this job. . .
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.
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ää
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.
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ää
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ää
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ää
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.
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ää
send parasol you received this message is intended only for the first time we are going to be a good day at work and
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.
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ää
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
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