Data Acquisition and Manipulation with Python

Data Acquisition and Manipulation with Python

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 2h 39m | 637 MB

Acquire, Analyse, and Play with Data. Acquire and analyse data in different formats with the help of Python data analysis tools

Python, a multi-paradigm programming language, has become the language of choice for data scientists for data analysis, visualization, and machine learning.

In this course, you’ll start by learning how to acquire data from the web in its already “clean” format, such as in a .csv file, or a database. You’ll then learn to transform this data so it’s in its most useful format for analysis. After that, you’ll dive into data aggregation and grouping, where you’ll learn to group similar data for easier analysis purposes.
From there, you’ll be shown different methods of web scraping using Python. Finally, you’ll learn to extract large amounts of data using BeautifulSoup, as well as work with Selenium and Scrapy.

What You Will Learn

  • See how to acquire and save different formats of data
  • Find out how to connect to a database and add information to it
  • Combine and merge data sets, and manipulate strings using Python
  • Aggregate your data and employ group-wise operations and transformations
  • Know how to download and read a web page using the BeautifulSoup package
  • Extract useful information from websites using Selenium in Python
  • Program and employ a Scrapy spider for successful web scraping
Table of Contents

01 The Course Overview
02 Getting Data in Its Different Formats
03 Connecting to a Database
04 Adding Information to a Database
05 Query a Database
06 Combining and Merging Datasets
07 Reshaping Data
08 Data Transformation
09 String Manipulation
10 Grouping Basics
11 Data Aggregation
12 GroupWise Operations and Transformations
13 Pivot Tables and Cross Tabulation
14 Exploring Web Scraping
15 Scraping the Web Safely
16 Let’s Have a BeautifulSoup
17 Downloading and Reading a Webpage
18 Extracting Useful Information
19 Making Use of Selenium
20 Navigating the Web with Selenium
21 Extracting Information with Selenium
22 Diving into Scrapy
23 Creating a Scrapy Spider
24 Programming a Spider
25 Deploying a Spider