Python Lesson 4 | BehindTheBall

In this video, the instructor teaches how to scrape and save column headers (titles) from an NBA stats table into a CSV file. These headers (like Player, Age, Team, etc.) are essential for understanding what each stat represents. This step builds on earlier lessons where the raw data (like numbers and player names) was scraped.

This lesson focuses on scraping the column headers from an NBA stats table so that your dataset is complete and readable. It explains how to:

Use BeautifulSoup to find <th> tags (which hold the column titles),
Select only the valid titles using list indexing and filtering,
Prepare these titles to be written as the first row in your CSV file.

This is an important step to make your data more useful and ready for analysis in R, pandas, or any other tool.

CSV = Comma-Separated Values
- Each comma represents a new column.
- Each line represents a new row.
This format makes it easy to use in tools like Excel, R, or Python (pandas).
Why Add Title Labels?
- The first row in the web table contains headers like Player, Age, Team, etc.
- These were missing in the previous scraped data, so now we add them for clarity.
How to Find Headers in HTML:
- HTML uses <th> tags for table headers (column titles).
- All <th> elements are located inside the first <tr> (table row).
- The code grabs this first row using indexing (all_players[0]), then finds all <th> elements inside it.
Cleaning the Title Data:
- Some unwanted tags or extra whitespace appear.
- The instructor uses a counter to skip every other element (since only every other index contains real titles).
- A simple if counter % 2 != 0: is used to keep only the odd-numbered elements, which are the real titles.

Data Scraping: Lesson 4

Contact Us