Book Image

Data Acquisition and Manipulation with Python [Video]

By : Curtis Miller
Book Image

Data Acquisition and Manipulation with Python [Video]

By: Curtis Miller

Overview of this book

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.
Table of Contents (6 chapters)
Chapter 1
Getting and Saving Data
Content Locked
Section 5
Query a Database
In this, we will see how we extract data from a database. Here we use SQL and Pandas to load a table’s data into a DataFrame. - Learn how to get data from a database with Pandas and SQL - Form an SQL command to select the desired data - Use from_sql() to save the query results to a DataFrame