How can you effectively use Python to clean, sort, and store data? What are the benefits of using the Pandas library for data science? What best practices can data scientists leverage to better work with multiple types of datasets? In the third course of Data Science Python Foundations Specialization from Duke University, Python users will learn about how Pandas — a common library in Python used for data science — can ease their workflow.
We recommend you should take this course after the first two courses of the specialization. However, if you hold a prerequisite knowledge of basic algebra, Python programming, and NumPy, you should be able to complete the material in this course.
In the first week, we’ll discuss Python file concepts, including the programming syntax that allows you to read and write to a file. Then in the following weeks, we’ll transition into discussing Pandas more specifically and the pros and cons of using this library for specific data projects. By the end of this course, you should be able to know when to use Pandas, how to load and clean data in Pandas, and how to use Pandas for data manipulation. This will prepare you to take the next step in your data scientist journey using Python; creating larger software programs.
This module, you will learn how to read data from files into your python program, and write that corresponding data to a file. We’ll be working primarily with string-type data in this unit and will give special attention to the way that python handles strings. Additionally we’ll go over some basic debugging in python using exception traces, and you’ll leverage these to create your own python program that is capable of reading and writing to a file.
涵盖的内容
5个视频8篇阅读材料3个作业3个编程作业
显示有关单元内容的信息
5个视频•总计25分钟
Course Introduction •3分钟
Paths and Filesystems •4分钟
Exceptions •8分钟
Using an Exception Traceback to Debug•4分钟
File IO•6分钟
8篇阅读材料•总计64分钟
Report a problem with the course•10分钟
Reading and Writing Data•10分钟
Strings•5分钟
File System Concepts•10分钟
Exceptions•2分钟
Understanding Exception Traces•15分钟
You Might Need Data Other than Pandas•10分钟
CSV Files•2分钟
3个作业•总计375分钟
Exception Concepts•15分钟
Understanding Exception Traces•180分钟
File Concepts•180分钟
3个编程作业•总计540分钟
Roman Numerals•180分钟
Get Parenthesized Regions•180分钟
Sort File•180分钟
Module 2: Tabular Data with Pandas
第 2 单元•小时 后完成
单元详情
This module, you’ll learn how to begin to utilize Pandas, one of the most commonly used libraries in Data Science with python. Pandas is predominantly used for working with tabular data. By the end of this module you’ll be able to identify the hallmarks and quirks of working with tabular data, describe the benefits and limitations of using Pandas, and be able to perform some basic data manipulation techniques in Pandas.
涵盖的内容
1个视频9篇阅读材料2个作业3个非评分实验室
显示有关单元内容的信息
1个视频•总计32分钟
Live Coding - Indexing and Subsetting•32分钟
9篇阅读材料•总计90分钟
Introduction to the Module: Tabular Data•10分钟
Pandas Series•10分钟
Manipulating Series: Subsetting and Indexing Series•10分钟
(OPTIONAL) Indexing with Brackets•10分钟
The object Data Type•10分钟
Tabular Data through Dataframes•10分钟
Subsetting DataFrames: Tips and Pitfalls•10分钟
The Categorical Data Type•10分钟
PyArrow: An Alternative to Numpy as Pandas Backend•10分钟
2个作业•总计60分钟
Module 2 Pandas Series Self-Check•30分钟
Module 2 Wrap Up Graded Quiz (For Submitting Answers Generated in Lab)•30分钟
3个非评分实验室•总计180分钟
Module 2 Pandas Series Exercises•60分钟
Live Coding Lab•60分钟
Module 2 Wrap Up Lab (For Graded Quiz)•60分钟
Module 3: Loading and Cleaning Data
第 3 单元•小时 后完成
单元详情
This Module, you will learn how to perform basic file operations in Pandas, as well as how to clean up large datasets. You’ll learn to read and write from common tabular file formats, and Pandas-specific intricacies for working with that data. Additionally, you’ll learn best practices for cleaning your data.
涵盖的内容
1个视频13篇阅读材料3个作业4个非评分实验室
显示有关单元内容的信息
1个视频•总计50分钟
Live Coding: Cleaning Data •50分钟
13篇阅读材料•总计130分钟
Intro to Module 3•10分钟
Storing and Reading Data: Plain Text•10分钟
Storing and Reading Data: Binary Files•10分钟
Pandas Indices•10分钟
Views and Copies: NumPy Review•10分钟
Views and Copies: Pandas •10分钟
Views and Copies: Copy on Write •10分钟
Indexing Lab Discussion•10分钟
Cleaning Data: Identifying•10分钟
Cleaning Data: Editing Globally•10分钟
Cleaning Data: Editing Specific Data•10分钟
Cleaning Data: Datatypes•10分钟
Cleaning Data: Missing Data•10分钟
3个作业•总计90分钟
Module 3 Missing Data Exercises Self-Check•30分钟
Module 3 Missing Data Exercises Self-Check•30分钟
Module 3 Wrap Up Graded Quiz (For Submitting Answers Generated in Lab)•30分钟
4个非评分实验室•总计240分钟
Indexing Lab•60分钟
Module 3 Missing Data Exercises (Ungraded)•60分钟
Module 3 Live Coding Lab•60分钟
Module 3 Wrap Up Lab (for Graded Quiz)•60分钟
Module 4: Data Manipulation
第 4 单元•小时 后完成
单元详情
This module you will learn how to combine datasets from different sources. Pandas has different methods of combining data depending on your preferred outcome, and you’ll be able to differentiate between when to use each kind. Additionally, we’ll go over computationally efficient ways of querying your data, which, while similar to selecting data via subsetting in its outcomes, has a distinct set of advantages.
Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.