Skip to content
KCL TechAcademy
HomeCoursesSign in
Menu
HomeCoursesSign in
  1. Courses
  2. /Python: From 0 to 1
  3. /Week 4

File Handling & Intro To Data Wrangling

In Week 4, we level up from basic Python scripts to using industry-standard tools for real-world data analysis. We will introduce Pandas, Python’s most powerful data manipulation library, and show you how professionals handle massive spreadsheets. You will learn how to import data effortlessly, inspect thousands of rows in seconds, and filter information. By the end of the session, you will put your new skills to the test by analyzing a massive corporate database to extract key insights on employee salaries, performance ratings, and job satisfaction with just a few lines of code.

Content Covered:

File Handling Basics: A brief look at reading external files securely using with open().

Introducing Pandas: Importing third-party modules (import pandas as pd) into your PyCharm workspace.

Reading CSVs: Ditching manual text extraction for the lightning-fast pd.read_csv() function.

The DataFrame: Understanding how Pandas structures data into rows and columns, compared to standard Python lists.

Data Exploration: Using built-in methods to instantly inspect your data (like viewing the top rows and checking data types).

Data Slicing: Extracting specific columns (e.g., isolating Salary or Age from the rest of the dataset).

Practical Build: The Corporate HR Data Analyzer Boss Challenge.

Your next step

Take your time with the material. Mark it complete when you’re ready.

Sign in to track progress

Related to this lesson

← Data Structures and LoopsData Visualisation with Matplotlib →
KCL Tech AcademyLearn. Build. Share what you know.