Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Data Wrangling With Python
1. Introduction
1. Welcome! (0:44)
2. What is Data Wrangling? (1:34)
3. Motivation (1:09)
4. What You'll Learn (2:02)
5. What You're Going to Get (0:55)
6. How to use this course
2. Data Wrangling Tools
1. Introduction (0:25)
2. Python (0:32)
3. Anaconda (1:06)
4. Spyder (1:16)
5. Jupyter (2:34)
6. Text Editor (0:46)
BONUS: Python Quick-Start Guide
3. Importing Data
1. Introduction (0:30)
2. XLS Format (1:24)
3. XLS Basics (2:33)
4. Multiple Sheets (3:18)
5. Messy Sheets (2:08)
6. Quiz: XLS (0:42)
7. Answer: XLS (0:39)
8. CSV Format (2:57)
9. CSV Part 1 (1:41)
10. CSV Part 2 (1:53)
11. CSV Part 3 (2:27)
12. Quiz: CSV (0:32)
13. Answer: CSV (0:46)
14. JSON Format (4:33)
15. JSON Data (2:32)
16. JSON Import (2:27)
17. JSON Formatting (2:07)
18. Quiz: JSON (0:43)
19. Answer: JSON (1:17)
20. XML Format (4:57)
21. XML Data (1:21)
22. XML Basics (2:39)
23. Parsing XML (2:29)
24. Organizing XML Data (3:45)
25. Quiz: XML (0:49)
26. Answer: XML (3:49)
27. Conclusion
4. Cleaning Data
1. Introduction (0:30)
2. Sources of Messy Data (1:25)
3. Missing Values (1:22)
4. Missing Values Part 1 (2:58)
5. Missing Values Part 2 (3:00)
6. Quiz: Missing Values (0:53)
7. Answer: Missing Values (1:14)
8. Consistency (1:37)
9. Consistent Strings (4:09)
10. Consistent Dates Part 1 (4:46)
11. Consistent Dates Part 2 (3:00)
12. Quiz: Consistency (1:34)
13. Answer: Consistency (0:46)
14. Correct Types (2:28)
15. Correct Types Part 1 (4:46)
16. Correct Types Part 2 (3:41)
17. Correct Types Part 3 (4:35)
18. Quiz: Correct Types (0:29)
19. Answer: Correct Types (1:00)
20. Accuracy (2:13)
21. Accuracy Part 1 (2:43)
22. Accuracy Part 2 (1:38)
23. Accuracy Part 3 (1:23)
24. Accuracy Part 4 (1:25)
25. Accuracy Part 5 (2:44)
26. Quiz: Accuracy (0:52)
27. Answer: Accuracy (1:44)
28. Conclusion
5. Reshaping Data
1. Introduction (0:30)
2. Reshaping Data (1:45)
3. Concatenate (0:39)
4. Concatenate with Pandas (3:06)
5. Quiz: Concatenate (0:31)
6 Answer: Concatenate (0:43)
7. Merge (2:12)
8. Inner Merge (2:16)
9. Left Merge (2:19)
10. Right Merge (2:03)
11. Outer Merge (2:15)
12. Quiz: Merge (0:47)
13. Answer: Merge (1:52)
14. Pivot (1:43)
15. Basic Pivot (2:56)
16. Multi-Index Pivot (2:55)
17. Quiz: Pivot (0:34)
18. Answer: Pivot (0:53)
19. Melt (1:11)
20. Melting a Dataframe (2:41)
21. Quiz: Melt (0:33)
22. Answer: Melt (0:36)
23. Conclusion
6. Project
1. Final Project (1:25)
2. Data Overview (3:44)
3. Project Details
4. Project Outline
Hint 1 - Consistent Dates
Hint 2 - Missing Values
Hint 3 - Consistent Strings
BONUS: Hint 4 - Correct Types
BONUS: Hint 5 - Importing XML
BONUS: Hint 6 - Pivot Table
BONUS: Example Project
5. Next Steps
6. Conclusion (0:24)
16. JSON Import
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock