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.
118
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.73
List Price:  €47.78
You save:  €42.04
£4.75
List Price:  £39.65
You save:  £34.89
CA$8.51
List Price:  CA$70.95
You save:  CA$62.44
A$9.43
List Price:  A$78.61
You save:  A$69.17
S$8.05
List Price:  S$67.10
You save:  S$59.05
HK$46.65
List Price:  HK$388.77
You save:  HK$342.12
CHF 5.40
List Price:  CHF 45.02
You save:  CHF 39.61
NOK kr66.79
List Price:  NOK kr556.60
You save:  NOK kr489.81
DKK kr42.76
List Price:  DKK kr356.38
You save:  DKK kr313.62
NZ$10.50
List Price:  NZ$87.56
You save:  NZ$77.05
د.إ22.03
List Price:  د.إ183.64
You save:  د.إ161.61
৳730.06
List Price:  ৳6,083.84
You save:  ৳5,353.77
₹521.54
List Price:  ₹4,346.23
You save:  ₹3,824.68
RM26.67
List Price:  RM222.27
You save:  RM195.60
₦9,060.90
List Price:  ₦75,507.50
You save:  ₦66,446.60
₨1,677.71
List Price:  ₨13,980.97
You save:  ₨12,303.25
฿202.14
List Price:  ฿1,684.55
You save:  ฿1,482.40
₺217.64
List Price:  ₺1,813.71
You save:  ₺1,596.06
B$34.35
List Price:  B$286.28
You save:  B$251.92
R110.29
List Price:  R919.11
You save:  R808.81
Лв11.21
List Price:  Лв93.46
You save:  Лв82.25
₩8,643.90
List Price:  ₩72,032.56
You save:  ₩63,388.65
₪21.39
List Price:  ₪178.31
You save:  ₪156.92
₱349.02
List Price:  ₱2,908.57
You save:  ₱2,559.54
¥911.08
List Price:  ¥7,592.39
You save:  ¥6,681.30
MX$121.56
List Price:  MX$1,013.07
You save:  MX$891.50
QR21.90
List Price:  QR182.52
You save:  QR160.61
P82.94
List Price:  P691.18
You save:  P608.23
KSh775.50
List Price:  KSh6,462.50
You save:  KSh5,687
E£303.66
List Price:  E£2,530.50
You save:  E£2,226.84
ብር771.29
List Price:  ብር6,427.44
You save:  ብር5,656.15
Kz5,472
List Price:  Kz45,600
You save:  Kz40,128
CLP$5,687.70
List Price:  CLP$47,397.50
You save:  CLP$41,709.80
CN¥43.67
List Price:  CN¥363.99
You save:  CN¥320.31
RD$372.95
List Price:  RD$3,107.93
You save:  RD$2,734.98
DA808.97
List Price:  DA6,741.45
You save:  DA5,932.47
FJ$13.79
List Price:  FJ$114.92
You save:  FJ$101.12
Q46.36
List Price:  Q386.33
You save:  Q339.97
GY$1,257.18
List Price:  GY$10,476.52
You save:  GY$9,219.34
ISK kr841.14
List Price:  ISK kr7,009.50
You save:  ISK kr6,168.36
DH59.86
List Price:  DH498.85
You save:  DH438.98
L111.90
List Price:  L932.57
You save:  L820.66
ден352.78
List Price:  ден2,939.91
You save:  ден2,587.12
MOP$48.14
List Price:  MOP$401.23
You save:  MOP$353.08
N$110.76
List Price:  N$923.04
You save:  N$812.27
C$221.10
List Price:  C$1,842.51
You save:  C$1,621.40
रु834.83
List Price:  रु6,956.98
You save:  रु6,122.14
S/22.22
List Price:  S/185.24
You save:  S/163.01
K24.16
List Price:  K201.40
You save:  K177.23
SAR22.50
List Price:  SAR187.52
You save:  SAR165.02
ZK169
List Price:  ZK1,408.34
You save:  ZK1,239.34
L28.53
List Price:  L237.81
You save:  L209.27
Kč143.78
List Price:  Kč1,198.20
You save:  Kč1,054.41
Ft2,303.36
List Price:  Ft19,194.66
You save:  Ft16,891.30
SEK kr64.29
List Price:  SEK kr535.77
You save:  SEK kr471.48
ARS$6,356.25
List Price:  ARS$52,968.75
You save:  ARS$46,612.50
Bs41.67
List Price:  Bs347.25
You save:  Bs305.58
COP$24,791.58
List Price:  COP$206,596.53
You save:  COP$181,804.95
₡3,043.37
List Price:  ₡25,361.49
You save:  ₡22,318.11
L153.18
List Price:  L1,276.56
You save:  L1,123.37
₲47,489.85
List Price:  ₲395,748.76
You save:  ₲348,258.91
$U259.49
List Price:  $U2,162.44
You save:  $U1,902.95
zł23.84
List Price:  zł198.67
You save:  zł174.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
118
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.