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.
113
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.75
List Price:  €47.93
You save:  €42.17
£4.77
List Price:  £39.77
You save:  £35
CA$8.62
List Price:  CA$71.87
You save:  CA$63.25
A$9.59
List Price:  A$79.97
You save:  A$70.37
S$8.13
List Price:  S$67.78
You save:  S$59.64
HK$46.67
List Price:  HK$388.95
You save:  HK$342.28
CHF 5.36
List Price:  CHF 44.67
You save:  CHF 39.31
NOK kr67.92
List Price:  NOK kr566
You save:  NOK kr498.08
DKK kr42.90
List Price:  DKK kr357.58
You save:  DKK kr314.67
NZ$10.60
List Price:  NZ$88.38
You save:  NZ$77.77
د.إ22.03
List Price:  د.إ183.65
You save:  د.إ161.61
৳716.79
List Price:  ৳5,973.26
You save:  ৳5,256.47
₹509.67
List Price:  ₹4,247.31
You save:  ₹3,737.63
RM27.04
List Price:  RM225.40
You save:  RM198.35
₦9,297.24
List Price:  ₦77,477
You save:  ₦68,179.76
₨1,669.63
List Price:  ₨13,913.58
You save:  ₨12,243.95
฿205.20
List Price:  ฿1,710.06
You save:  ฿1,504.86
₺211.16
List Price:  ₺1,759.68
You save:  ₺1,548.52
B$36.51
List Price:  B$304.30
You save:  B$267.78
R109.85
List Price:  R915.49
You save:  R805.63
Лв11.24
List Price:  Лв93.67
You save:  Лв82.43
₩8,678.52
List Price:  ₩72,321
You save:  ₩63,642.48
₪21.92
List Price:  ₪182.71
You save:  ₪160.79
₱353.01
List Price:  ₱2,941.75
You save:  ₱2,588.74
¥938.73
List Price:  ¥7,822.75
You save:  ¥6,884.02
MX$120.46
List Price:  MX$1,003.89
You save:  MX$883.42
QR21.86
List Price:  QR182.22
You save:  QR160.35
P82.90
List Price:  P690.88
You save:  P607.97
KSh775.50
List Price:  KSh6,462.50
You save:  KSh5,687
E£305.29
List Price:  E£2,544.16
You save:  E£2,238.86
ብር765.95
List Price:  ብር6,382.91
You save:  ብር5,616.96
Kz5,508
List Price:  Kz45,900
You save:  Kz40,392
CLP$5,934.90
List Price:  CLP$49,457.50
You save:  CLP$43,522.60
CN¥43.77
List Price:  CN¥364.82
You save:  CN¥321.04
RD$365.26
List Price:  RD$3,043.87
You save:  RD$2,678.60
DA809.19
List Price:  DA6,743.30
You save:  DA5,934.10
FJ$13.89
List Price:  FJ$115.82
You save:  FJ$101.92
Q46.21
List Price:  Q385.15
You save:  Q338.93
GY$1,254.94
List Price:  GY$10,457.88
You save:  GY$9,202.93
ISK kr834.78
List Price:  ISK kr6,956.50
You save:  ISK kr6,121.72
DH60.37
List Price:  DH503.08
You save:  DH442.71
L110.21
List Price:  L918.44
You save:  L808.23
ден354.03
List Price:  ден2,950.32
You save:  ден2,596.28
MOP$48.02
List Price:  MOP$400.17
You save:  MOP$352.15
N$110.43
List Price:  N$920.27
You save:  N$809.84
C$220.72
List Price:  C$1,839.39
You save:  C$1,618.67
रु815.93
List Price:  रु6,799.42
You save:  रु5,983.49
S/22.33
List Price:  S/186.13
You save:  S/163.79
K24.32
List Price:  K202.70
You save:  K178.37
SAR22.53
List Price:  SAR187.82
You save:  SAR165.28
ZK166
List Price:  ZK1,383.36
You save:  ZK1,217.36
L28.62
List Price:  L238.57
You save:  L209.94
Kč144.55
List Price:  Kč1,204.61
You save:  Kč1,060.06
Ft2,381.58
List Price:  Ft19,846.50
You save:  Ft17,464.92
SEK kr66.19
List Price:  SEK kr551.62
You save:  SEK kr485.43
ARS$6,130.23
List Price:  ARS$51,085.31
You save:  ARS$44,955.07
Bs41.45
List Price:  Bs345.41
You save:  Bs303.96
COP$26,158.34
List Price:  COP$217,986.20
You save:  COP$191,827.85
₡3,026.39
List Price:  ₡25,219.92
You save:  ₡22,193.53
L152.26
List Price:  L1,268.88
You save:  L1,116.61
₲46,772.03
List Price:  ₲389,766.91
You save:  ₲342,994.88
$U268.48
List Price:  $U2,237.41
You save:  $U1,968.92
zł24.52
List Price:  zł204.35
You save:  zł179.83

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