Python scripting for creating a FACT file from CSV Data File
$30-250 USD
Pagado a la entrega
We have multiple CSV Files (144 CSV Files) with 2 Fields - Date/Time and a FACT ID (0 - 10).
Need a Python script to read all these files and create a single FACT File based on the logic below.
1) FACT File will have 3 Fields - Start Date Time , End date Time and FACT ID
Start Date Time will be the Start Date Time for the first entry with a specific FACT ID - 0 to 10
End date Time will be the value of Start Date Time just before the FACT ID switches to a different value.
Start Date Time for second FACT ID will be the first Date entry from starting line with new FACT ID.
This process will repeat every time the FACT ID switches from one value to another.
The third field is the FACT ID itself (0 -10)
Attaching a sample File with DATA File format on left and FACT file format needed (manually created to show the format).
Nº del proyecto: #18540397
Sobre el proyecto
Adjudicado a:
I can provide you Python script that will convert your CSV files into FACT file just like you want. I can complete it in several hours for just $90.
13 freelancers están ofertando un promedio de $115 por este trabajo
Hi, How are you? I have enough experience on python and csv file management. You can check my skill at my profile. I will wait for your response on here. Thanks.
Hello? How are you? I have good experiences in "Python scripting for creating a FACT file from CSV Data File" as you can see my profile for these (Python, Software Architecture). I have been working for 7 yrs in thi Más
Hi I have done a lot of CSV/Excel manipulation using Python and I think I can definitely do this in quick time. Please send me a message. Some of my Python (includes tkinter & PyQt5 GUI) projects and got good r Más
Hey there I'm a System Engineer with coding skills. I had developed tons of scripts using Python. I can help. Regards.
Hello! Let me tell you that the logic is common and useful. I got modules already done that have the same logic and it is only necessary to personalize the script in order to do what you need. Let me show you my scri Más
Hi, looks like a straightforward task to do. I will need an hour or two to complete this. How do you want to run it? I can write the plain Python script or something like Jupyter or Docker container. Send me a messa Más
Hi, I went through the excel file, you have attached. Have done things like this before. Can complete in one day.
I can do this easily by using csv package in python. I've one question: Are these fields sorted (as it looks in sample) ? Or do you want me to first sort them on time before processing in case they are not already so Más
Hi, I am interested in doing it, it seems straightforward and wont take much long and i have just 1 small question regarding it , if you are interested i will be available on chat we can discuss it there and i can s Más
Hi, Nice to meet you. I have experience managing csv file with Studio.3T and Robo.3T for web developing project. Database management is my best programming skills. If you choose me, you will get the satisfied and pe Más
Goodmorning, We have similar experience in this task and we love to complete this task on schedule time and budget. we are available to start NOW Thank you
Completed 3 Projects. 2 are from Django Framework and 1 is on Web2Py Framework. Skills- Python, Django, Web2py Jquery, AngularJS, HTML, CSS Platform - Ubuntu