К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Answering Interesting Questions with Data · LearnSpace
Назад в каталог
courseraПрограммирование

Answering Interesting Questions with Data

Курс от University of Michigan
Средний≈ 29.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

There is a huge amount of raw data available on the internet with endless potential. This four-week course from the University of Michigan will help you learn how to read data in different formats and write programs to scrape data from the internet. Once you complete this course, you’ll be empowered with the ability to use data to answer high-level and interesting questions. An essential component of data collection and analysis is the ability to store and manage the data effectively once you’ve retrieved it. You’ll learn how to use SQL to manage data in relational databases in order to create linked datasets and gain insight into the relationships and meaning that can be derived from your data. Data is a powerful tool, but its potential can only be unleashed once it is converted and represented as logical information. This process is referred to as data visualization, and it is key to understanding and analyzing data. You’ll be taught to use charts, scatter plots, graphs, and other mediums in order to transform your data into valuable information that can be used to answer interesting questions. This course is designed for learners who are interested in extending their Python knowledge, learning a textual programming language, or who would like to be able to communicate with programmers in a professional setting.

Навыки, которые вы освоите

Data StoreRelational DatabasesData ManipulationHypertext Markup Language (HTML)Application Programming Interface (API)Data VisualizationWeb ScrapingDatabase ManagementSQLPython ProgrammingJSONExtensible Markup Language (XML)Scatter Plots

Программа курса

4 модулей · 143 учебных материалов

01Week 1: HTML and Beautiful Soup42 материалов

Introduction to the Course

Meet Dr. Barb EricsonВидеоWelcome to the CourseВидеоHow is This Course Different?ВидеоSyllabusЧтение

Учитесь у экспертов

Barbara Ericson

Associate Professor of Information, School of Information and Associate Professor of Electrical Engineering and Computer Science, College of Engineering

Answering Interesting Questions with Data
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 29.5 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Узбекский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Испанский, Дари, Японский, Казахский

Часть программы вашего университета
Community Engagement ArticleЧтение
Course Pre-SurveyЧтение
What is Python?Видео

Working in Groups

Why Work in Groups?ВидеоPOGIL RolesВидеоHow to Work in GroupsОбсуждение

How to Use the eBook

How to Write Code in the eBookВидеоReloading Your Code HistoryВидео

Introduction to Week 1

Week 1 OverviewЧтениеWelcome to the Week 1ВидеоIntroduce Yourself | Where in the World Are You?Обсуждение

HTML

Introduction to HTMLВидеоeBook LoginВнешний инструментExercise: Group Work | HTML BasicsЧтениеFix HTMLВидеоThe Document Object Model (DOM)ВидеоExercise: Group Work | More Group Work on HTMLЧтениеAttributesВидеоCSS ClassesВидео

HTML Practice

Peer Instruction | HTMLВнешний инструментPeer Instruction Discussion | HTMLОбсуждениеExercise: HTML PracticeВнешний инструмент

Beautiful Soup

Introduction to Beautiful SoupВидеоHow to read sections on Beautiful SoupВидеоExercise: Ebook Work | Beautiful SoupЧтениеfind vs find_allВидеоView page source and inspect HTML page elementsВидеоWhy use class_ with find or find_all?ВидеоCreate a Soup object from a URLВидео

Beautiful Soup Practice

Peer Instruction | Beautiful SoupВнешний инструментPeer Instruction Discussion | Beautiful SoupОбсуждениеExercise: Group Work | Beautiful SoupВнешний инструмент

Assignment 1 | Scraping Web Pages with Beautiful Soup

Assignment Brief | Scraping Web Pages with Beautiful SoupЧтениеAssignment Instructions | Scraping Web Pages with Beautiful SoupЧтениеAssignment Submission | Scraping Web Pages with Beautiful SoupВнешний инструментAssignment Reflection | Scraping Web Pages with Beautiful SoupОбсуждение

End of Week

Week 1 QuizВнешний инструментEnd of Week 1 Discussion | Working with HTML and Beautiful SoupОбсуждение
02Week 2: XML, JSON, and APIs32 материалов

Introduction to Week 2

Week 2 OverviewЧтениеWelcome to Week 2Видео

XML

What is XML?ВидеоExercise: Ebook Work | XML ReadingЧтениеXML termsВидеоExercise: Ebook Work | Parsing XMLЧтениеParsing XMLВидеоFixing XMLВидеоExercise: Ebook Work | Looping Through NodesЧтение

XML Practice

Peer Instruction | XMLВнешний инструментPeer Instruction Discussion | XMLОбсуждениеExercise: XML PracticeВнешний инструмент

JSON

What is JSON?ВидеоExercise: Ebook Work | JSON ReadingЧтениеXML vs JSONВидеоExercise: Ebook Work | Parsing JSONЧтениеProcessing JSONВидеоWhat is an API?ВидеоExercise: Ebook Work | Application Programming Interfaces

JSON Practice

Peer Instruction | JSONВнешний инструментPeer Instruction Discussion | JSONОбсуждениеExercise: JSON PracticeВнешний инструмент

Assignment 2 | Working with JSON and APIs

Assignment Brief | Working with JSON and APIsЧтениеAssignment Instructions | Working with JSON and APIsЧтениеAssignment Submission | Working with JSON and APIsВнешний инструментAssignment Reflection | Working with JSON and APIsОбсуждение

End of Week 2

Week 2 QuizВнешний инструментEnd of Week 2 Discussion | XML and JSONОбсуждение
03Week 3: Databases and SQL32 материалов

Introduction to Week 3

Week 3 OverviewЧтениеWelcome to Week 3Видео

Databases

Why use a Database?ВидеоExercise: Ebook Work | What is a Database?ЧтениеExercise: Ebook Work | Database ConceptsЧтениеIntro to SQLiteВидеоExercise: Ebook Work | Intro to DB BrowserЧтениеHow to Download DB BrowserВидеоExploring a database with DB BrowserВидеоIntroduction to SQL in DB BrowserВидеоBasic SQL StatementsВидео

Database Practice

Peer Instruction | DatabaseВнешний инструментPeer Instruction Discussion | DatabaseОбсуждениеExercise: Database PracticeВнешний инструмент

SQL in Python

Using Python to Execute SQLВидеоExercise: Ebook Work | Creating a Database TableЧтениеExercise: Ebook Work | SQL SummaryЧтениеExercise: Ebook Work | More SELECT KeywordsЧтениеMore SELECT KeywordsВидеоUsing Python to Select DataВидео

SQL in Python Practice

Peer Instruction | More SQLВнешний инструментPeer Instruction Discussion | More SQLОбсуждениеExercise: More SQL PracticeВнешний инструментExercise: Database PracticeВнешний инструмент

Assignment 3 | Storing API data in a Database

Assignment Brief | Storing API data in a DatabaseЧтениеAssignment Instructions | Storing API data in a DatabaseЧтениеAssignment Submission | Storing API data in a DatabaseВнешний инструментAssignment Reflection | Storing API data in a DatabaseОбсуждение

End of Week Reflections

Week 3 QuizВнешний инструментEnd of Week 3 Discussion | Relational Databases and SQLОбсуждение
04Week 4: More Databases and Visualizing Data37 материалов

Introduction to Week 4

Week 4 OverviewЧтениеWelcome to Week 4Видео

More Databases

Intro to Spidering TwitterВидеоExercise: Ebook Work | Spidering Twitter using a databaseЧтениеCode for spidering twitterВидеоExercise: Ebook Work | Basic Data ModelingЧтениеExercise: Ebook Work | Multiple TablesЧтениеCode for multiple tablesВидеоExercise: Ebook Work | Three kinds of keysЧтениеExercise: Ebook Work | Using JOINЧтениеCode with JOINВидеоGoals for Database DesignВидеоIntro to OMDBВидеоTables for OMDBВидеоTypes of keys and best practicesВидео

More Databases Practice

Peer Instruction | Database JoinВнешний инструментPeer Instruction Discussion | Database JoinОбсуждениеExercise: Ebook Work | Practice with SQL JOINВнешний инструмент

Visualizing Data (Matplotlib)

What is Matplotlib?ВидеоWhy plot data?ВидеоKey TermsВидеоExample PlotsВидеоEnhancementsВидеоExample Pie ChartВидеоPlotting Michigan and Georgia data

Visualizing Data (Matplotlib) Practice

Peer Instruction | MatplotlibВнешний инструментPeer Instruction Discussion | MatplotlibОбсуждениеExercise: Ebook Work | Matplotlib practiceВнешний инструмент

Assignment 4 | Selecting Data and Creating Figures

Assignment Brief | Selecting Data and Creating FiguresЧтениеAssignment Instructions | Selecting Data and Creating FiguresЧтениеAssignment Submission | Selecting Data and Creating FiguresВнешний инструментAssignment Reflection | Selecting Data and Creating FiguresОбсуждение

End of Week

Week 4 QuizВнешний инструментEnd of Week 4 Discussion | Visualizing DataОбсуждение

End of Course Recap

End of Course RecapОбсуждениеCourse Post-SurveyЧтение
Чтение
Free APIsВидео
API AuthorizationВидео
Get JSON data from an APIВидео
Using Params to Specify API ParametersВидео
Using Python for SQL StatementsВидео
Using fetchone and fetchallВидео
Видео
Paired barsВидео