首页
网站开发
桌面应用
管理软件
微信开发
App开发
嵌入式软件
工具软件
数据采集与分析
其他
首页
>
> 详细
CS39A0190代做、代写Python,Java程序
项目预算:
开发周期:
发布时间:
要求地区:
ASSIGNMENT 2 INSTRUCTIONS
CS39A0190 Data analytics basics
”DATASETS”-file has three sheets. First sheet ”DATASET1” is its own task and sheets two
and three, ”DATASET2_1” and ”DATASET2_2” are another one.
The datasets needs to be cleaned before they can be analysed. You can turn the data into
table or keep as a range, whichever you find easier to work with.
DATASET1 basic info
The data is process data where Events go through a process from A to G.
Process step colums A to G have dates as data. The date depicts when the process step began. Process
step G means completion of the whole process.
DATASET2 basic info
The data is sales data for product range. SKU (stock keeping unit) is assigned to each unique product.
Agency depicts a retailer. Volume is the amount sold during the time and average max temp describes
the temperature at the retailer for the sales period.
DATASETS
Cleaning the data
Remove empty rows.
Remove incomplete Event records. Every process step must have a date.
Remove duplicate Event records. Each Event ID is unique.
If Excel does not recognize the process step data as dates, convert the cell contents into dates.
Event IDs and Event types are numbers by format.
Analysing the data
Calculate the duration (in days) between each process step and the total duration for all Events.
Calculate the average duration between each process step and the average total process duration for all
Event types.
Example for a single Event:
DATASET1 – 3 POINTS
First, use Text to Columns to get the comma separated data into separate columns.
Cleaning the data
Both DATASET2_1 and DATASET2_2 sheets have a column that uses dot as a decimal separator. If your
Excel has comma as a decimal separator, convert the dots to commas.
Check for duplicates, missing data, empty rows... and handle accordingly if found.
Analysing the data
Add the Avg_Max_Temp data from DATASET2_2 to DATASET_1. See example below.
Calculate monthly total sales (all SKUs) for each Agency.
Calculate annual total sales for each SKU.
DATASET2 – 3 POINTS
Data is from Eurostat, population data. Actual national population data from 2021 and
projections for 2022-2100.
Projections has multiple scenarios in separate sheets.
Your task is to combine the data for EU countries + Iceland, Norway and Switzerland (30
countries in total).
Open a blank Excel spreadsheet and connect to both of the Excel files to get data.
Clean the data, merge the datasets, and clean the merged data if necessary.
You will return results only for the 30 countries.
As a result, you will have for each country a 2021 actual population (total, males, and
females) and projections for 2022-2100 (total, males, and females).
From projections, use two scenarios. Baseline and a free choice for the second.
POWER QUERY – 6 POINTS
Find two datasets (from anywhere) that you can connect to and combine in Power Query.
Use two different sources for the data.
E.g., one from CSV and one from Web
Clean the data using Power Query and combine them into one dataset.
FIND AND MERGE – 3 POINTS
Return three Excel-files.
DATASETS
POWER QUERY
FIND AND MERGE
All used functions and Queries must remain in the submitted files. Being able to see the
data transformation process in the files is more important than the end result.
SUBMISSION
软件开发、广告设计客服
QQ:99515681
邮箱:99515681@qq.com
工作时间:8:00-23:00
微信:codinghelp
热点项目
更多
代写dts207tc、sql编程语言代做
2024-12-25
cs209a代做、java程序设计代写
2024-12-25
cs305程序代做、代写python程序...
2024-12-25
代写csc1001、代做python设计程...
2024-12-24
代写practice test preparatio...
2024-12-24
代写bre2031 – environmental...
2024-12-24
代写ece5550: applied kalman ...
2024-12-24
代做conmgnt 7049 – measurem...
2024-12-24
代写ece3700j introduction to...
2024-12-24
代做adad9311 designing the e...
2024-12-24
代做comp5618 - applied cyber...
2024-12-24
代做ece5550: applied kalman ...
2024-12-24
代做cp1402 assignment - netw...
2024-12-24
热点标签
mktg2509
csci 2600
38170
lng302
csse3010
phas3226
77938
arch1162
engn4536/engn6536
acx5903
comp151101
phl245
cse12
comp9312
stat3016/6016
phas0038
comp2140
6qqmb312
xjco3011
rest0005
ematm0051
5qqmn219
lubs5062m
eee8155
cege0100
eap033
artd1109
mat246
etc3430
ecmm462
mis102
inft6800
ddes9903
comp6521
comp9517
comp3331/9331
comp4337
comp6008
comp9414
bu.231.790.81
man00150m
csb352h
math1041
eengm4100
isys1002
08
6057cem
mktg3504
mthm036
mtrx1701
mth3241
eeee3086
cmp-7038b
cmp-7000a
ints4010
econ2151
infs5710
fins5516
fin3309
fins5510
gsoe9340
math2007
math2036
soee5010
mark3088
infs3605
elec9714
comp2271
ma214
comp2211
infs3604
600426
sit254
acct3091
bbt405
msin0116
com107/com113
mark5826
sit120
comp9021
eco2101
eeen40700
cs253
ece3114
ecmm447
chns3000
math377
itd102
comp9444
comp(2041|9044)
econ0060
econ7230
mgt001371
ecs-323
cs6250
mgdi60012
mdia2012
comm221001
comm5000
ma1008
engl642
econ241
com333
math367
mis201
nbs-7041x
meek16104
econ2003
comm1190
mbas902
comp-1027
dpst1091
comp7315
eppd1033
m06
ee3025
msci231
bb113/bbs1063
fc709
comp3425
comp9417
econ42915
cb9101
math1102e
chme0017
fc307
mkt60104
5522usst
litr1-uc6201.200
ee1102
cosc2803
math39512
omp9727
int2067/int5051
bsb151
mgt253
fc021
babs2202
mis2002s
phya21
18-213
cege0012
mdia1002
math38032
mech5125
07
cisc102
mgx3110
cs240
11175
fin3020s
eco3420
ictten622
comp9727
cpt111
de114102d
mgm320h5s
bafi1019
math21112
efim20036
mn-3503
fins5568
110.807
bcpm000028
info6030
bma0092
bcpm0054
math20212
ce335
cs365
cenv6141
ftec5580
math2010
ec3450
comm1170
ecmt1010
csci-ua.0480-003
econ12-200
ib3960
ectb60h3f
cs247—assignment
tk3163
ics3u
ib3j80
comp20008
comp9334
eppd1063
acct2343
cct109
isys1055/3412
math350-real
math2014
eec180
stat141b
econ2101
msinm014/msing014/msing014b
fit2004
comp643
bu1002
cm2030
联系我们
- QQ: 9951568
© 2021
www.rj363.com
软件定制开发网!