String type (object, string) in Pandas - Mini Project: Build & Apply

Working with String Type Columns in pandas

📖 Scenario: You have a small dataset of book titles and their authors. You want to work with the text data in pandas to understand how string columns behave and how to manipulate them.

🎯 Goal: Learn how to create a pandas DataFrame with string columns, check their data types, and perform simple string operations.

📋 What You'll Learn

Create a pandas DataFrame with specific string data

Check the data type of the string columns

Use pandas string methods to manipulate text data

Print the final manipulated DataFrame

💡 Why This Matters

🌍 Real World

Working with text data is common in data science, such as analyzing product names, customer reviews, or book titles.

💼 Career

Understanding string types and how to manipulate them in pandas is essential for data cleaning and preparation tasks in many data science roles.

1

Create a pandas DataFrame with book titles and authors

Import pandas as pd and create a DataFrame called books with two columns: 'Title' and 'Author'. Use these exact entries: Titles: 'The Hobbit', '1984', 'Pride and Prejudice'; Authors: 'J.R.R. Tolkien', 'George Orwell', 'Jane Austen'.

Pandas

# Import pandas and create the DataFrame 'books' with the specified titles and authors
# Your code here

Need a hint?

Use pd.DataFrame with a dictionary where keys are column names and values are lists of strings.

2

Check the data type of the 'Title' column

Create a variable called title_dtype and assign it the data type of the 'Title' column in the books DataFrame using books['Title'].dtype.

Pandas

import pandas as pd

books = pd.DataFrame({
    'Title': ['The Hobbit', '1984', 'Pride and Prejudice'],
    'Author': ['J.R.R. Tolkien', 'George Orwell', 'Jane Austen']
})

# Assign the data type of the 'Title' column to 'title_dtype'
# Your code here

Need a hint?

Use books['Title'].dtype to get the data type of the column.

3

Convert all book titles to uppercase

Create a new column in the books DataFrame called 'Title_Upper' that contains the uppercase version of the 'Title' column. Use the pandas string method str.upper() on books['Title'].

Pandas

import pandas as pd

books = pd.DataFrame({
    'Title': ['The Hobbit', '1984', 'Pride and Prejudice'],
    'Author': ['J.R.R. Tolkien', 'George Orwell', 'Jane Austen']
})

title_dtype = books['Title'].dtype

# Create 'Title_Upper' column with uppercase titles
# Your code here

Need a hint?

Use books['Title'].str.upper() to convert strings to uppercase.

4

Print the updated DataFrame

Print the books DataFrame to display all columns including the new 'Title_Upper' column.

Pandas

import pandas as pd

books = pd.DataFrame({
    'Title': ['The Hobbit', '1984', 'Pride and Prejudice'],
    'Author': ['J.R.R. Tolkien', 'George Orwell', 'Jane Austen']
})

title_dtype = books['Title'].dtype

books['Title_Upper'] = books['Title'].str.upper()

# Print the 'books' DataFrame
# Your code here

Need a hint?

Use print(books) to show the DataFrame.