In this chapter, you'll learn how to import data into Python from all types of flat files, which are a simple and prevalent form of data storage. You've previously learned how to use NumPy and pandas—you will learn how to use these packages to import flat files and customize your imports.

Welcome to the course!

Importing entire text files

Importing text files line by line

The importance of flat files in data science

Pop quiz: what exactly are flat files?

Why we like flat files and the Zen of Python

Importing flat files using NumPy

Using NumPy to import flat files

Customizing your NumPy import

Importing different datatypes

Importing flat files using pandas

Using pandas to import flat files as DataFrames (1)

Using pandas to import flat files as DataFrames (2)

Customizing your pandas import

Final thoughts on data import

Introduction and flat files

You've learned how to import flat files, but there are many other file types you will potentially have to work with as a data scientist. In this chapter, you'll learn how to import data into Python from a wide array of important file types. These include pickled files, Excel spreadsheets, SAS and Stata files, HDF5 files, a file type for storing large quantities of numerical data, and MATLAB files.

Introductie tot andere bestandstypen

Niet meer zo ‘flat’

Een gepickeld bestand laden

Werkbladen in Excel-bestanden weergeven

Bladen importeren uit Excel-bestanden

Je spreadsheetimport aanpassen

SAS- en Stata-bestanden importeren met pandas

Hoe importeer je SAS7BDAT

SAS-bestanden importeren

Stata-bestanden importeren met read_stata

Stata-bestanden importeren

HDF5-bestanden importeren

File gebruiken om HDF5-bestanden te importeren

HDF5-bestanden importeren met h5py

Gegevens uit je HDF5-bestand halen

MATLAB-bestanden importeren

MAT-bestanden laden

De structuur van .mat in Python

Importing data from other file types

In this chapter, you'll learn how to extract meaningful data from relational databases, an essential skill for any data scientist. You will learn about relational models, how to create SQL queries, how to filter and order your SQL records, and how to perform advanced queries by joining database tables.

Introduction to relational databases

Pop quiz: The relational model

Creating a database engine in Python

Creating a database engine

What are the tables in the database?

Querying relational databases in Python

The Hello World of SQL Queries!

Customizing the Hello World of SQL Queries

Filtering your database records using SQL's WHERE

Ordering your SQL records with ORDER BY

Querying relational databases directly with pandas

Pandas and The Hello World of SQL Queries!

Pandas for more complex querying

Advanced querying: exploiting table relationships

The power of SQL lies in relationships between tables: INNER JOIN

Filtering your INNER JOIN

Final Thoughts

Working with relational databases in Python

Chinook (SQLite)

LIGO (HDF5)

Battledeath (XLSX)

Extent of infectious diseases (DTA)

Gene expressions (MATLAB)

MNIST

Sales (SAS7BDAT)

Seaslugs

Titanic

Course Glossary

Als data scientist moet je data opschonen, verwerken en transformeren, visualiseren, voorspellende modellen bouwen en deze modellen interpreteren. Maar eerst moet je weten hoe je data in Python krijgt. In deze cursus leer je de vele manieren om data in Python te importeren: uit platte bestanden zoals .txt en .csv; uit bestanden van andere software zoals Excel-spreadsheets en Stata-, SAS- en MATLAB-bestanden; en uit relationele databases zoals SQLite en PostgreSQL.

De video's bevatten live-transcripts die je kunt tonen door linksonder in de video op "Show transcript" te klikken.
De cursuswoordenlijst vind je rechts in de sectie met bronnen.
Om CPE-credits te behalen moet je de cursus afronden en een score van 70% halen op de kwalificerende toets. Je gaat naar de toets via de CPE-creditsvermelding aan de rechterkant.

Intermediate Python

Leer data in Python inlezen: van CSV-bestanden tot Excel en relationele databases zoals SQLite & PostgreSQL.

Introductie tot data importeren in Python

Leer hoe je gegevens in Python importeert vanuit verschillende bronnen, zoals Excel, SQL, SAS en direct vanaf het web.

Associate Data Scientist  in Python

Data-engineer in Python

Gegevens importeren en opschonen  in Python

Data Scientist at DataCamp

SAS/Stata-bestanden importeren met pandas

SAS- en Stata-bestanden

SAS-bestanden

Laten we oefenen!

Importing data from other file types - SAS- en Stata-bestanden importeren met pandas

SAS- en Stata-bestanden importeren met pandas

Create Your Free Account