• FutureLearn logo

This course is part of the Data Analytics Using Python ExpertTrack

New

Data Analytics Using Python: Data Wrangling and Ingestion

Enhance your understanding of Python by diving deeper into functions including data wrangling, manipulation and transformation.

Data Analytics Using Python: Data Wrangling and Ingestion
  • Duration4 weeks
  • Weekly study4 hours
  • 100% onlineTry this course for free
  • Included in an ExpertTrackCourse 3 of 3
  • Get full ExpertTrack access$39/month
Overview
Syllabus
Requirements
Educators
More courses

Do you want to expand your data analytics skills and streamline your analysis processes? Having a solid understanding of Python can help to boost your career and make data analysis and manipulation considerably more efficient.

This course builds on the previous two within this Data Analytics Using Python ExpertTrack to give you a better understanding of the possibilities of using Python.

Deepen your understanding of Python functions

On this course, you’ll familiarise yourself with the data wrangling, manipulation and exploration steps of the CRISP-DM methodology, and perform data ingestion using Python.

You’ll learn how to demonstrate transformation activities in Python to further your data analysis.

You’ll also explore SQL in relation to data analytics, including the fundamentals of databases using SQL to perform various data analysis operations.

By the end of this course, you’ll be better equipped to create database tables using the data definition language and add data records using data manipulation language.

You’ll have also practised how to query the data stored in those database tables, and demonstrate various data processing activities using data query language and data manipulation language.

Syllabus

  • Week 1

    Data wrangling using Python I

    • Introduction

      Introduction to the week

    • What is data wrangling?

      What is data wrangling and why does it matter?

    • Data wrangling using Python

      How do we wrangle data using Python? Let's find out.

    • Wrap-up

      Wrap up of this week's concepts.

  • Week 2

    Data wrangling using Python II

    • Introduction

      Introduction to the week

    • Data wrangling using Python II

      Let's look at some intermediate approaches to wrangling data using Python.

    • Wrap-up

      Wrap up of Week 2's concepts.

  • Week 3

    Designing databases

    • Introduction

      Introduction to the week.

    • Designing databases

      Let's look at the fundamentals of designing databases.

    • Wrap-up

      Wrap up of this week's concepts.

  • Week 4

    Introduction to SQL

    • Introduction

      Introduction to the week

    • Introduction to SQL

      Let's look at the fundamentals of using SQL to perform analysis.

    • SQL for data analysis

      How do we use SQL to analyse data? Let's find out.

    • Wrap-up

      Now it's time to wrap up this week's concepts, look to what the future holds and demonstrate your learning in the final test.

What will you achieve?

By the end of the course, you‘ll be able to...

  • Demonstrate data wrangling, manipulation and transformation activities in Python
  • Create database tables using the data definition language and add data records using data manipulation language
  • Query the data stored in those database tables
  • Demonstrate various data processing activities using data query language and data manipulation language

Who is the course for?

This course is suitable for:

  • business analysis or junior data analysts looking to develop advanced data analytics skills and programming capabilities to progress their careers in data analytics
  • someone with existing programming capabilities looking to enter the data analytics field
  • an individual lacking the programming capabilities to conduct more advanced data analysis and modelling

What software or tools do you need?

During the ExpertTrack we’ll be using Jupyter notebook. We recommend you use a computer to access these elements.

Who will you learn with?

Ed Marks

I truly believe that leveraging the correct technologies in the appropriate way can take us towards a more sustainable economy. My focus is on converging M&E Engineering with Data Science/Analysis.

Who developed the course?

FutureLearn

The social learning platform with hundreds of online courses from a quarter of the world’s top universities.

In collaboration with

GitHub logo

About this ExpertTrack

Develop the fundamental Python programming knowledge and skills required to complete advanced analytics.

Find out more

Start learning today - free 7-day trial

After your free trial you can:

  • Pay $39 per month to keep learning online
  • Have complete control over your subscription; you can cancel any time
  • Work at your own pace and set your own deadlines at every stage
  • Only pay while you’re learning; the subscription will cancel automatically when you finish
  • Complete online assessments to test your knowledge and prove your skills
  • Earn digital course certificates and a final award that you can share online, with potential employers, and your professional network
  • Keep access to the content of courses you complete even after your subscription ends
    • Start your free 7-day trial

    Other courses in this ExpertTrack