Requirement -
** This could be a Python script and should be able to do the following **
The script will use Python 3.6 on Red Hat Linux server 7.5
1) Iterate through the files in the folder and convert .txt and .parquet files to .csv files
2) In the .txt files there are line items with the value "NaN' and these lines with the entry "NaN" should be removed before saving the file as .CSV
3) Create a script to run on Red Hat Linux server which will do the following:-
Read multiple CSV files grouped under 3 folders - Good, Bad and Normal (Same data fields) on a folder and generate a CSV file with one line item for each file.
For example we will have close to 1000 CSV files with data points > DateTime, EquipmentID etc.
The generated csv file will have the following fields:
- Start Date Time - Earliest date Time from the CSV File
- End date Time - Latest date Time from the CSV File
- Equipment ID
- Name of the folder the file is in (For Example : good, bad or normal)
I am attaching a sample of "FACT" file to be created with 3 sample data files under the folder "Bad"
Hello!!!
How are you today?
I have read your project description very carefully.
I have developed many python projects for 5 years.
I would like to discuss with you about your project in detail.
Please give me a chance to work for you.
I will do my best.
Best regards.
Hello Sir,
I am a professional software developer. I have rich experience working on shell and python automation scripts. I checked your requirements and very comfortable complete this project within couple of days. here I need to write a script which will read text and parquet file from your folders and create a csv file out of these with different columns and save them with proper naming convention and in different folders. I totally understand your requirements and can provide very efficient script on time.
I have 8 year of experience working on these type of scripts. Looking forward to work with you.
Thanks,
Rajdeep
Hello, this is a very easy task, and I can handle it in a day. I have extensive experience with python and text file manipulation due to the research field I am working in. I am keeping the bid very low so that I can get my first job here. Thanks in advance.
Hi
I am an devops engineer experienced in linux for more than 5 years. I am well experienced in python for processing text-files, and other similar types of files and converting them csv after processing. I can do this for you. Please message to discuss further on this
Thanks
Note-pleae check my profile for past project and reviews.
I would like to take this project, i have good experience in python, shell script and perl..i had good experience in automation and devops along with dataconversion
I worked similar project and wrote perl code to match the file and get the final status
Please let me know if you are good to award this project to me
Hi, I can help you in writing python script to read csv using my file handling & programming experience in python. I've been programming with python for over 3 years now and have handled variety of tasks like these. Let me know when can I start. Thanks, Pravar.
Hello, Sir!
I can do the job for you and could start immediately.
I have big experience in unix server administrative tasks (4 years in top level of technical support of a worldwide hosting company, 2 years in satellite provider support).
And at my work I used to make scripts for routines, so I know how to automate work you described in shell-script.
I have no experience on this site and international freelance market at all, that's why I place my price to the lowest possible.
Hi,
I have 3+ years of experience in scripting using Python and Shell. I have gone through your requirement and I can complete it early and easily.
Kindly let me know when should we start?
Thanks.
Hello,
I have great experience on Python and file transformations.
Your task will be set and ready in less than three days. It would be core python code that will be able to run in every operating system, but it will be tested in a red hat environment before I sent it to you.
I hope that I can help you on this.
Hello there,
Thank you for looking into my bid. I am a Computer Science undergraduate. I look forward to do this job for you. I have done two MITx(online) course on Edx using python. I use linux (ubuntu), so basically I have experience coding in an environment like Red Hat (which is also linux).
You have given details enough. Just waiting for your "Go" signal.