Skip to main content

ColumbiaX: Analytics in Python

Learn the fundamental of programming in Python and develop the ability to analyze data and make data-driven decisions.

Analytics in Python
12 weeks
8–10 hours per week
Instructor-paced
Instructor-led on a course schedule
This course is archived
Future dates to be announced

About this course

Skip About this course

Data is the lifeblood of an organization. Competency in programming is an essential skill for successfully extracting information and knowledge from data.

The goal of this course is to introduce learners to the basics of programming in Python and to give a working knowledge of how to use programs to deal with data.

In this course, we will first cover the basics of programming and then focus on using Python on the entire data management process from data acquisition to analysis of data big data and small data.

This is an intensive hands-on course that will equip and reward learners with proficiency in data management skills.

At a glance

  • Institution: ColumbiaX
  • Subject: Business & Management
  • Level: Intermediate
  • Prerequisites:

    We will review basic Python programming concepts in week 1 and 2 and no prior programming experience is necessary. But, if you have had some exposure to programming you will get more out of this class.

    No specific math capability is required though it will be helpful if you are familiar with the basic concepts of algebra, set theory, and probability.

  • Language: English
  • Video Transcript: English
  • Associated skills:Data Management, Python (Programming Language), Data Acquisition, Big Data

What you'll learn

Skip What you'll learn
  • Become familiar with working with relational databases, using SQL based languages such as MySql, dealing with formatted data (XML, JSON, etc.)
  • Use Python to work with and analyze data from databases as well as from the web
  • Week 1: Python review
  • Week 2: Python review
  • Week 3: Data interchange formats: JSON and XML
  • Week 4: Web scraping and web crawling
  • Week 5: Database basics: Relational databases
  • Week 6: SQL
  • Week 7: Data analysis and visualization I
  • Week 8: Data analysis and visualization II
  • Week 9: Text mining
  • Week 10: Analysis of networks
  • Week 11: Machine learning: Part 1
  • Week 12: Machine learning: Part 2

Who can take this course?

Unfortunately, learners residing in one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. edX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.

Interested in this course for your business or team?

Train your employees in the most in-demand topics, with edX For Business.