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.
120
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.11
List Price:  €42.63
You save:  €37.51
£4.48
List Price:  £37.38
You save:  £32.89
CA$8.25
List Price:  CA$68.79
You save:  CA$60.53
A$8.99
List Price:  A$74.98
You save:  A$65.98
S$7.75
List Price:  S$64.58
You save:  S$56.83
HK$46.71
List Price:  HK$389.28
You save:  HK$342.57
CHF 4.77
List Price:  CHF 39.77
You save:  CHF 34.99
NOK kr60.65
List Price:  NOK kr505.46
You save:  NOK kr444.81
DKK kr38.21
List Price:  DKK kr318.47
You save:  DKK kr280.25
NZ$10.32
List Price:  NZ$86.03
You save:  NZ$75.70
د.إ22.03
List Price:  د.إ183.62
You save:  د.إ161.59
৳731.86
List Price:  ৳6,098.87
You save:  ৳5,367.01
₹542.82
List Price:  ₹4,523.55
You save:  ₹3,980.72
RM24.60
List Price:  RM205.02
You save:  RM180.42
₦8,700.18
List Price:  ₦72,501.50
You save:  ₦63,801.32
₨1,684.37
List Price:  ₨14,036.44
You save:  ₨12,352.06
฿189.30
List Price:  ฿1,577.50
You save:  ฿1,388.20
₺256.16
List Price:  ₺2,134.73
You save:  ₺1,878.56
B$32.44
List Price:  B$270.35
You save:  B$237.90
R101.18
List Price:  R843.24
You save:  R742.05
Лв10
List Price:  Лв83.39
You save:  Лв73.38
₩8,862.36
List Price:  ₩73,853.04
You save:  ₩64,990.68
₪19.22
List Price:  ₪160.17
You save:  ₪140.95
₱354.30
List Price:  ₱2,952.50
You save:  ₱2,598.20
¥935.50
List Price:  ¥7,795.88
You save:  ¥6,860.37
MX$108.24
List Price:  MX$902.07
You save:  MX$793.82
QR21.82
List Price:  QR181.89
You save:  QR160.06
P79.44
List Price:  P662.04
You save:  P582.60
KSh772.32
List Price:  KSh6,436
You save:  KSh5,663.68
E£285.22
List Price:  E£2,376.87
You save:  E£2,091.64
ብር932.58
List Price:  ብር7,771.54
You save:  ብር6,838.95
Kz5,472.86
List Price:  Kz45,607.20
You save:  Kz40,134.33
CLP$5,485.50
List Price:  CLP$45,712.50
You save:  CLP$40,227
CN¥42.33
List Price:  CN¥352.75
You save:  CN¥310.42
RD$383.52
List Price:  RD$3,196.02
You save:  RD$2,812.49
DA778.16
List Price:  DA6,484.74
You save:  DA5,706.57
FJ$13.63
List Price:  FJ$113.59
You save:  FJ$99.95
Q45.86
List Price:  Q382.23
You save:  Q336.36
GY$1,252.77
List Price:  GY$10,439.75
You save:  GY$9,186.98
ISK kr758.22
List Price:  ISK kr6,318.50
You save:  ISK kr5,560.28
DH55.08
List Price:  DH459.07
You save:  DH403.98
L101.43
List Price:  L845.31
You save:  L743.87
ден314.89
List Price:  ден2,624.12
You save:  ден2,309.23
MOP$48
List Price:  MOP$400.01
You save:  MOP$352.01
N$101.42
List Price:  N$845.20
You save:  N$743.77
C$220.36
List Price:  C$1,836.39
You save:  C$1,616.02
रु864.92
List Price:  रु7,207.68
You save:  रु6,342.76
S/20.18
List Price:  S/168.20
You save:  S/148.02
K25.41
List Price:  K211.75
You save:  K186.34
SAR22.51
List Price:  SAR187.61
You save:  SAR165.10
ZK138.69
List Price:  ZK1,155.79
You save:  ZK1,017.10
L26.04
List Price:  L217
You save:  L190.96
Kč123.98
List Price:  Kč1,033.19
You save:  Kč909.21
Ft1,964.94
List Price:  Ft16,374.52
You save:  Ft14,409.58
SEK kr55.71
List Price:  SEK kr464.32
You save:  SEK kr408.60
ARS$8,619.03
List Price:  ARS$71,825.31
You save:  ARS$63,206.27
Bs41.38
List Price:  Bs344.86
You save:  Bs303.48
COP$23,039
List Price:  COP$191,991.69
You save:  COP$168,952.69
₡2,937.26
List Price:  ₡24,477.24
You save:  ₡21,539.97
L157.67
List Price:  L1,313.94
You save:  L1,156.27
₲40,928.79
List Price:  ₲341,073.32
You save:  ₲300,144.52
$U235.47
List Price:  $U1,962.25
You save:  $U1,726.78
zł21.61
List Price:  zł180.13
You save:  zł158.51

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