Kapalı

Small-scale Data Cleansing and Transformation Project

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.

Beceriler: Excel, Veri İşleme, Visual Basic, ETL, Python

Daha fazlasını gör: data cleansing project outsourcing, weighing scale data reading project, erp data cleansing project tender, excel templates data cleansing project, small scale php project, project data cleansing, data cleansing microsoft project, bid on this project data entry, testing small scale project, In this project you will create 3 simple, binary 25x25 images or your choice and use Java 2D graphic methods to rotate, scale an, small scale dairy farm project, small scale rice mill project, small scale project management, small scale project examples, small scale project meaning, data cleansing project plan, micro and small scale industries project, project report on small scale industries in india pdf, micro and small scale industries economics project class 12

İşveren Hakkında:
( 9 değerlendirme ) Clinton, United States

Proje NO: #29829892

Bu iş için 30 freelancer ortalamada $139 teklif veriyor

schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 660 + Projects. I have 6 + years of the experience in sam Daha Fazla

$180 USD in 3 gün içinde
(478 Değerlendirme)
8.4
(279 Değerlendirme)
8.1
(205 Değerlendirme)
6.9
hdlan

Hi, I’m from Vietnam with a lot of experience in Excel, data entry, and data processing. I would be happy to help you merge data from 10 supplied CSVs into an Excel template. Let’s discuss if you’re interested. Best re Daha Fazla

$150 USD in 10 gün içinde
(54 Değerlendirme)
6.5
finecodervw

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

$100 USD in 3 gün içinde
(137 Değerlendirme)
6.5
wsh2

* MsEXCEL Business programming, database, and data transformation expert. American English is my first and only language. USMC combat veteran. At your earliest convenience, please attach any pertinent data/report/wnor Daha Fazla

$389 USD in 7 gün içinde
(59 Değerlendirme)
6.5
chehsan632

Hey, I'm expert in researching techniques with a lot of experience in Internet research, web research, lead generation, finding email & phone number of a company leads like Founder, CEO, COO,Manager, VP, Director and Daha Fazla

$90 USD in 2 gün içinde
(9 Değerlendirme)
6.0
tawakalgeek

Hi there, Please share source file to understand current data architecture. We first need to identify pattern in order to perform cleansing and transformation which can be done through various algorithms and later manu Daha Fazla

$223 USD in 7 gün içinde
(29 Değerlendirme)
6.1
(112 Değerlendirme)
6.0
raoarslan56

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)
4.7
hamidr2020

Hi, I am an Excel expert. I have read the projects details and I can complete this project perfectly as per your requirements. You can check my recent reviews in Excel projects. https://www.freelancer.com/contest/REPA Daha Fazla

$70 USD in 2 gün içinde
(17 Değerlendirme)
4.3
MonisZafar

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(24 Değerlendirme)
4.8
mhgroup21

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
3.3
ibahimakerkouch

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
3.3
afzalfarooque

Hi, I can clean and process your data, I will use Python Pandas. If you are interested ping me. ==========================================================================

$140 USD in 7 gün içinde
(8 Değerlendirme)
3.1
IakovAgababian

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...

$200 USD in 3 gün içinde
(1 Yorum)
2.8
solutionsplayers

I am a Professional Data Entry Person & have More Than 7 Years Experience. My skills: 1: Microsoft word 2:Microsoft excel 3: Power Point 4: Pdf to word file Here is just a small overview of My Services how I can help f Daha Fazla

$30 USD in 2 gün içinde
(3 Değerlendirme)
2.4
jinhui12

Hi, I have experience in data processing and analysis, and can help you convert CSV files. Looking forward to working with you, thanks!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
1.9
FutureNOWPK

Hello I have worked on CSV with 45K records with little or no primary key arrangement, duplication. I managed to sort and cleanse the data into a merged CSVs. I handled duplication with 1. Regular expressions 2. Linu Daha Fazla

$170 USD in 4 gün içinde
(2 Değerlendirme)
1.6
mpca

Hi! I believe I can help you with this job. How many data each of these csv files has? Please contact to discuss details. Thank you!

$150 USD in 3 gün içinde
(1 Yorum)
0.5