Beginning Data Science with Python

The Beginning Data Science with Python course is the continuation of our Python Programming course. It is an ideal course for people involving data analytics or having interest in the subject of Data Science.

In the course, students will know how to load data from various sources , dealing with a big dataset, handling problematic data and processing and manipulating the data using Pandas and Numpy. Finally, data can be visualized and plotted graphically with the matplotlib.

The course is suitable for data analysts, data science or finance students or Excel users require computations on large datasets.

You'll Learn

Data Preparation and loading

  • Data loading using Pandas
  • Working with problematic data
  • Dealing with big datasets

Data Processing with Pandas

  • Introduction to Data Structures
  • Series / DataFrame / Index Objects
  • Viewing and selecting data
  • Statistical and histogramming operations
  • String methods
  • Concatenating / joining / appending data
  • Arithmetic methods
  • Operations between DataFrame and Series
  • Function application and mapping
  • Sorting and Ranking
  • Doing common Excel tasks in Pandas
  • Doing Pivot Table in Pandas

Data Processing with Numpy

  • Array Creation - N-dimensions
  • Printing Arrays
  • Numpy DataTypes and conversion
  • numpy.ndarray methods
  • Basic arrays elementwise operations
  • Matrix product using dot function
  • Universal functions
  • Indexing, slicing and iterating
  • Shape manipulation
  • Copies and views
  • Data Processing Using Arrays

Data Visualization

  • pyPlot Basics
  • Knowing different chart elements
  • Charting with Pandas
  • Plotting a single interactive chart
  • Saving your charts
  • Subplots
  • Plotting multiple charts

Web Scraping

  • Downloading web pages
  • Parsing web pages
  • Locating the search point
  • Processing the target section
  • Tabulating the data
  • Scraping stock data from Yahoo Finance

PYD8032 - 廣東話 16 Mar enrol
  Access SQL
  Excel Dashboards and Reports
  Excel VBA
  Python Programming