Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following diagram of two data files to be cleaned and merged into one. The pcsales east jan file on the left contains January
Consider the following diagram of two data files to be cleaned and merged into one. The pcsales east jan file on the left contains January sales of PCs in the East region, while the pcsales west jan file on the right contains January sales of PCs in the West region. Prodact Sales data for East Region Commission rate Government Fortune 300 Small busines January 3.00% 3953000 4050.00 100% 43500.00 40.00 15475.00 4.00% 770.00 $2515.00 Sales Associates Sales Associates 100% 12500.00 1300.00 100% 12500.00 30675.00 33000.00 5400000 3178500 34200 Product Megasener Gary Meerver Commate Government Fortune 500 mal b Minerver CP 100% 13500.00 500.00 M gelerver 25 Gary 350 330 $1,250 $2412 100% 1000000 2.50% 0900.00 30400.00 50.00 430 S 57.139 525115 D 2.50% 410.00 104 430 SAR,350 87 2.30% 43250.00 Senior Sales A 450% 407.00 37152.00 15 Minserver Senior Sales Amo 4.50 581.950 2 40% 3343000 17 Megnever 17 Ggaterer 25 430 SPL000 3343 1 4.50% gatever 25 Meer CP y Toby Sales As 100% 19 Miserver Mary Sales Associate M 1300 477 57.30 4.00% Se Sales Associate 4.00% 1570.00 Sales A 3.30 S1000 23 Meer Car To Senior Sales Assa Service Sales Ass 4.00% 28750.00 2750.00 400% 10 4041000 Miserver CP Mary 330 31.100 34 Senior 20 40% 400% List seven (7) data cleaning operations that would need to be performed to enable the two files to be merged (appended) into a single new file. Be sure to specify the file to which your cleaning operation applies-pcsales east jan or pcsales west jan See Associate B 1.30 100 1024 BIV A A IXXE 12pt Paragraph D
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started