Dealing With Data Using Python

Catalog description

This class is designed to teach students to handle data programmatically, without being software engineers. This course guides students through the whole data management process, from initial data acquisition to final data analysis. From a tools perspective, we cover Python and SQL. SQL is the lingua franca for all data analysts, and virtually all companies store their data in SQL-accessible repositories. Python serves as a great general-purpose programming language for a wide variety of data management tasks, and is commonly used as the “glue” that brings together all the different aspects of the analytics process. The list of topics that we plan to cover: ● Data modeling and ER model ● Relational databases and SQL ● Accessing data sources: Web APIs ● Data manipulation using Python Pandas ● Regular expressions and Web Crawling ● Text Analytics