Data Processing and Manipulation
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Data Processing and Manipulation
This course is part of Data Wrangling with Python Specialization
Instructor: Di Wu
Included with
Learn more
Ask Coursera
Recommended experience
Recommended experience
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
6 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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
Offered by
Explore more from Data Analysis
- Status: Free TrialM
Microsoft
Course
Guided Project
- Status: Free TrialU
University of California San Diego
Course
- Status: Free Trial
Course
Why people choose Coursera for their career
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.
More questions
Financial aid available,
