Real Python
  • Start Here
  • Learn Python
    Start Learning
    Your Learning Plan →Your personalized Python learning plan Python Tutorials →In-depth articles and video courses Learning Paths →Guided study plans for accelerated learning
    Practice
    Quizzes & Exercises →Check your learning progress Browse Topics →Focus on a specific area or skill level Reference →Concise definitions for common Python terms
    Get Help
    Mentor AI →NewYour personal Python mentor Office Hours →Live Q&A calls with Python experts Community Chat →Learn with other Pythonistas
    Go Deeper
    Live Courses →Live, instructor-led Python courses Books →Round out your knowledge and learn offline Podcast →Hear what’s new in the world of Python
    Unlock All Content and Become a Python Expert →Get unlimited access to all Real Python has to offer
    Unlock All Content →Become a Python Expert
  • More
    Learner Stories Python Newsletter Python Job Board Meet the Team Become a Contributor
  • Search
/
  • Join
  • Sign‑In

— FREE Email Series —

🐍 Python Tricks 💌

Dictionary merging in Python 3.5+

🔒 No spam. Unsubscribe any time.

Browse Topics Guided Learning Paths
Basics Intermediate Advanced
ai algorithms api best-practices career community databases data-science data-structures data-viz devops django docker editors flask front-end gamedev gui machine-learning news numpy projects python stdlib testing tools web-dev web-scraping

Table of Contents

  • Understanding the Need for a Data Analysis Workflow
  • Setting Your Objectives
  • Acquiring Your Data
    • Reading Data From CSV Files
    • Reading Data From Other Sources
  • Cleansing Your Data With Python
    • Creating Meaningful Column Names
    • Dealing With Missing Data
    • Handling Financial Columns
    • Correcting Invalid Data Types
    • Fixing Inconsistencies in Data
    • Correcting Spelling Errors
    • Checking for Invalid Outliers
    • Removing Duplicate Data
    • Storing Your Cleansed Data
  • Performing Data Analysis With Python
    • Performing a Regression Analysis
    • Practicing Your Intuition for a Regression Analysis
    • Investigating a Statistical Distribution
    • Finding No Relationship
  • Communicating Your Findings
  • Resolving an Anomaly
  • Conclusion