Data Manipulation and Visualization in Python and MS Excel Hands-on

Learn how to pre-process and visualize data by using popular analytical and data science software: Python and Microsoft Excel.

Data Manipulation and Visualization in Python and MS Excel Hands-on

Learn how to pre-process and visualize data by using popular analytical and data science software: Python and Microsoft Excel.
112
views
Share the link to this page
Copied

About the Class

We will focus on the most time-consuming part of the machine learning process which is the data exploration consisting of data visualization and data wrangling serving for preparing and understanding your data. The whole course is full of different hands-on exercises in two popular data analytics platforms:

  • Open-source and very progressive programming language Python
  • The most popular MS Excel

where we will read the data, transform them, and visualize them.

What will you learn in this course?

  • Python  (installation and environment description)
  • Gathering the data into both platforms (data from Excel and CSV)
  • Data exploration: Data wrangling (preparation and transformation) I - Table, row transform, row filter, and split
  • Data exploration: Data wrangling (preparation and transformation) II - Column binning, column convert and replace, column filter, column split, column transform
  • Data exploration: Data wrangling (preparation and transformation) III - Other data types – date and time
  • Data exploration:  Visualisation by creating a histogram, line plot, pie chart, scatter plot, box plot

Author

Barbora Stetinova

Data science
Earned experience in data science and machine learning, leading a project office team, strategical projects and controlling.Since Sept 2018 as a member of IT department participating on the Data science projects.Engaged as a consultant for different industries (retail, sensorics, building) at Leadership Synergy Community.Data science trainer...

School

Barbora Stetinova's School

Requirements

  • You should have installed Python on your PC/Mac.
  • You should have Microsoft Excel available on your PC/Mac.
 
One-time Fee
$6
List Price:  $50
You save:  $44
€5.63
List Price:  €46.92
You save:  €41.29
£4.85
List Price:  £40.48
You save:  £35.62
CA$8.22
List Price:  CA$68.52
You save:  CA$60.30
A$9.30
List Price:  A$77.50
You save:  A$68.20
S$8.17
List Price:  S$68.14
You save:  S$59.96
HK$47.01
List Price:  HK$391.79
You save:  HK$344.77
CHF 5.47
List Price:  CHF 45.60
You save:  CHF 40.12
NOK kr66.08
List Price:  NOK kr550.74
You save:  NOK kr484.65
DKK kr42.01
List Price:  DKK kr350.10
You save:  DKK kr308.08
NZ$10.15
List Price:  NZ$84.61
You save:  NZ$74.46
د.إ22.03
List Price:  د.إ183.63
You save:  د.إ161.59
৳657.98
List Price:  ৳5,483.23
You save:  ৳4,825.24
₹500.10
List Price:  ₹4,167.53
You save:  ₹3,667.43
RM28.68
List Price:  RM239
You save:  RM210.32
₦7,541.76
List Price:  ₦62,848
You save:  ₦55,306.24
₨1,668.52
List Price:  ₨13,904.39
You save:  ₨12,235.86
฿222.22
List Price:  ฿1,851.85
You save:  ฿1,629.62
₺195.61
List Price:  ₺1,630.12
You save:  ₺1,434.50
B$30.99
List Price:  B$258.32
You save:  B$227.32
R115.43
List Price:  R961.93
You save:  R846.50
Лв10.99
List Price:  Лв91.66
You save:  Лв80.66
₩8,267.38
List Price:  ₩68,894.87
You save:  ₩60,627.49
₪22.69
List Price:  ₪189.10
You save:  ₪166.41
₱345.31
List Price:  ₱2,877.59
You save:  ₱2,532.28
¥928.80
List Price:  ¥7,740
You save:  ¥6,811.20
MX$102.72
List Price:  MX$856.03
You save:  MX$753.31
QR21.86
List Price:  QR182.20
You save:  QR160.33
P83.04
List Price:  P692.01
You save:  P608.97
KSh807
List Price:  KSh6,725
You save:  KSh5,918
E£288.47
List Price:  E£2,403.98
You save:  E£2,115.50
ብር341.30
List Price:  ብር2,844.23
You save:  ብር2,502.92
Kz5,009.65
List Price:  Kz41,747.08
You save:  Kz36,737.43
CLP$5,715.78
List Price:  CLP$47,631.50
You save:  CLP$41,915.72
CN¥43.48
List Price:  CN¥362.34
You save:  CN¥318.85
RD$353.67
List Price:  RD$2,947.30
You save:  RD$2,593.62
DA806.80
List Price:  DA6,723.40
You save:  DA5,916.59
FJ$13.66
List Price:  FJ$113.86
You save:  FJ$100.20
Q46.64
List Price:  Q388.68
You save:  Q342.04
GY$1,254.33
List Price:  GY$10,452.81
You save:  GY$9,198.48
ISK kr846.36
List Price:  ISK kr7,053
You save:  ISK kr6,206.64
DH60.79
List Price:  DH506.64
You save:  DH445.84
L106.98
List Price:  L891.50
You save:  L784.52
ден346.60
List Price:  ден2,888.34
You save:  ден2,541.74
MOP$48.38
List Price:  MOP$403.23
You save:  MOP$354.84
N$114.45
List Price:  N$953.79
You save:  N$839.33
C$220.66
List Price:  C$1,838.84
You save:  C$1,618.18
रु799.64
List Price:  रु6,663.72
You save:  रु5,864.07
S/22.09
List Price:  S/184.10
You save:  S/162
K22.78
List Price:  K189.87
You save:  K167.09
SAR22.50
List Price:  SAR187.54
You save:  SAR165.03
ZK154.83
List Price:  ZK1,290.25
You save:  ZK1,135.42
L28.02
List Price:  L233.50
You save:  L205.48
Kč142.27
List Price:  Kč1,185.60
You save:  Kč1,043.32
Ft2,218.93
List Price:  Ft18,491.14
You save:  Ft16,272.21
SEK kr65.32
List Price:  SEK kr544.41
You save:  SEK kr479.08
ARS$5,233.59
List Price:  ARS$43,613.32
You save:  ARS$38,379.72
Bs41.57
List Price:  Bs346.47
You save:  Bs304.89
COP$23,443.17
List Price:  COP$195,359.76
You save:  COP$171,916.59
₡3,000.87
List Price:  ₡25,007.29
You save:  ₡22,006.41
L148
List Price:  L1,233.38
You save:  L1,085.37
₲44,425.35
List Price:  ₲370,211.30
You save:  ₲325,785.94
$U231.16
List Price:  $U1,926.37
You save:  $U1,695.20
zł24.32
List Price:  zł202.73
You save:  zł178.40

What's Included

Language: English
Level: Beginner
Skills: Data Manipulation, Data Visualization, Data Exploration, Python, Microsoft Excel, Excel, MS Excel, Data Wrangling, Programming Language
Age groups: All ages
Duration: 2 hours 34 minutes
37 Videos
10 Documents
0
Saves
112
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.