VOOZH about

URL: https://www.coursera.org/learn/data-processing-and-manipulation

⇱ Data Processing and Manipulation | Coursera


Data Processing and Manipulation

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Data Processing and Manipulation

Instructor: Di Wu

Included with

β€’

Learn more

Ask Coursera

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

3 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

3 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Understand the importance of data processing and manipulation in the data analysis pipeline.

  • Learn techniques to handle missing values and outliers, data reduction, and data scaling and discretization.

  • Understand the concept of data cube and perform multidimensional aggregation for exploratory analysis.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

6 assignments

Taught in English

Build your subject-matter expertise

This course is part of the Data Wrangling with Python Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 4 modules in this course

The "Data Processing and Manipulation" course provides students with a comprehensive understanding of various data processing and manipulation concepts and tools. Participants will learn how to handle missing values, detect outliers, perform sampling and dimension reduction, apply scaling and discretization techniques, and explore data cube and pivot table operations. This course equips students with essential skills for efficiently preparing and transforming data for analysis and decision-making.

Learning Objectives: 1. Understand the importance of data processing and manipulation in the data analysis pipeline. 2. Learn techniques to handle missing values in datasets, including imputation and exclusion strategies. 3. Identify and detect outliers to assess their impact on data analysis and decision-making. 4. Explore sampling methods and dimension reduction techniques for large datasets and high-dimensional data. 5. Apply data scaling techniques to normalize and standardize variables for meaningful comparisons. 6. Utilize discretization to transform continuous data into categorical representations, simplifying analysis. 7. Understand the concept of data cube and perform multidimensional aggregation for exploratory analysis. 8. Create pivot tables to summarize and reshape data, gaining valuable insights from complex datasets. Throughout the course, students will actively engage in practical exercises and projects, allowing them to apply data processing and manipulation techniques to real-world datasets. By the end of the course, participants will be well-equipped to effectively prepare, clean, and transform data for subsequent analysis tasks and data-driven decision-making.

The "Missing Values and Outliers" week focuses on how to handle missing values and detect outliers using the Pandas library. You will learn essential techniques to identify and address missing data effectively, as well as methods to detect and manage outliers in datasets.

What's included

3 videos6 readings2 assignments1 discussion prompt

3 videosβ€’Total 33 minutes
  • Missing Valuesβ€’20 minutes
  • Outliers Detection using Statisticsβ€’6 minutes
  • Outliers Detection using IQRβ€’8 minutes
6 readingsβ€’Total 221 minutes
  • Course Updates and Accessibility Supportβ€’1 minute
  • Assessment Strategyβ€’30 minutes
  • Activity Strategyβ€’10 minutes
  • Missing Values Demoβ€’60 minutes
  • Outliers Detection using Statistics Demoβ€’60 minutes
  • Outliers Detection using IQRβ€’60 minutes
2 assignmentsβ€’Total 60 minutes
  • Missing Values Quizβ€’30 minutes
  • Outliers Detection Quizβ€’30 minutes
1 discussion promptβ€’Total 120 minutes
  • Missing Value and Outliers Detection Exploration Exerciseβ€’120 minutes

The "Data Reduction" week focuses on how to reduce data through sampling and dimensionality reduction using the Pandas library. You will learn essential techniques to obtain manageable subsets of data while preserving meaningful information for analysis and visualization.

What's included

2 videos3 readings1 assignment1 discussion prompt

2 videosβ€’Total 14 minutes
  • Dimension Eliminationβ€’6 minutes
  • Samplingβ€’7 minutes
3 readingsβ€’Total 240 minutes
  • Dimension Elimination Demoβ€’60 minutes
  • Sampling Demoβ€’60 minutes
  • Data Reduction Case Studyβ€’120 minutes
1 assignmentβ€’Total 30 minutes
  • Data Reduction Quizβ€’30 minutes
1 discussion promptβ€’Total 120 minutes
  • Data Reduction Exploration Exerciseβ€’120 minutes

The "Scaling and Discretization" week focuses on the importance of data scaling and discretization in the data preprocessing process. You will learn why and how to perform data scaling to normalize variables and handle data with different scales. Additionally, you will explore the concept of data discretization and its application in transforming continuous data into categorical representations.

What's included

2 videos3 readings1 assignment1 discussion prompt

2 videosβ€’Total 24 minutes
  • Data Scalingβ€’12 minutes
  • Data Discretizationβ€’12 minutes
3 readingsβ€’Total 240 minutes
  • Data Scaling Demoβ€’60 minutes
  • Data Discretization Demoβ€’60 minutes
  • Scaling and Discretization Case Studyβ€’120 minutes
1 assignmentβ€’Total 30 minutes
  • Scaling and Discretization Quizβ€’30 minutes
1 discussion promptβ€’Total 120 minutes
  • Scaling and Discretization Exploration Exerciseβ€’120 minutes

The "Data Warehouse" week focuses on the concepts and methodologies of organizing data using data cubes and pivot tables in Pandas. You will learn the importance of data warehousing for efficient data management and analysis, as well as how to construct data cubes and pivot tables to facilitate multidimensional data exploration.

What's included

2 videos3 readings2 assignments1 discussion prompt

2 videosβ€’Total 22 minutes
  • Pivot Tableβ€’10 minutes
  • Data Cubeβ€’12 minutes
3 readingsβ€’Total 240 minutes
  • Pivot Table Demoβ€’60 minutes
  • Data Cube Demoβ€’60 minutes
  • Data Warehouse Case Studyβ€’120 minutes
2 assignmentsβ€’Total 90 minutes
  • Data Warehouse Quizβ€’30 minutes
  • Self Reflectionβ€’60 minutes
1 discussion promptβ€’Total 120 minutes
  • Data Warehouse Exploration Exerciseβ€’120 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

University of Colorado Boulder
21 Coursesβ€’62,723 learners

Explore more from Data Analysis

Why people choose Coursera for their career

πŸ‘ Image

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
πŸ‘ Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
πŸ‘ Image

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
πŸ‘ Image

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Financial aid available,