This project involves the cleansing and transformation of data in each of 9 or 10 CSV files and then creating a sub-table (with a primary key) in each file. The resulting transformed sub-tables from each file are consolidated/merged into a single Excel file. Certain CSV files may contain poor quality data and may need significant cleansing and reconstruction of cell information. In each CSV file, a number of unwanted fields are eliminated and the remaining selected fields are then cleansed, formatted and consolidated (joining, concatenating and filtering) to create a sub-table in each CSV file - keeping a primary ID key attached to each record. The final Excel file (a template will be provided) is comprised of all the transformed sub-tables from each of the 9 or 10 CSV files which are ordered and formatted according to template requirements.
Bu iş için 30 freelancer ortalamada $139 teklif veriyor
Hi, I am well versed with automation in Excel and can help to clean the 10 CSV files and merged the clean data into single consolidated file. A quick discussion would help. Looking forward to your response. Thanks
Here, sir I have read your ob description carefully! I love cleansing, formatting and transforming data/table in excel, I wold like to maintain your data/table in 9 or 10 excel file as per your given description, I can Daha Fazla
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. I Daha Fazla
Dear client, I have sound knowledge in excel and analytics. Also, I previously carried out a number of projects in excel using pivot and macro. I ensure you will be happy after hiring me. Kindly contact me. Check my p Daha Fazla
Hi, I have worked on advanced data projects specifically data qualitysimilar to your project. Your project is a challenge for me. Let's discuss it.
Hi, I can clean and process your data, I will use Python Pandas. If you are interested ping me. ==========================================================================
Hi Python Expert is Here. I have enough experience with python to help you and I am sure that I can do this project perfectly. If you work with me, you will get a good result in time I am waiting for you on here...
Hi, I have experience in data processing and analysis, and can help you convert CSV files. Looking forward to working with you, thanks!