Blogs

Updating Rows and Columns - Modifying Data Within DataFrames in Python

 Updating/Modifying Data in Columns Within DataFrames:

people = {

    "first": ["Corey", 'Jane', 'John'], 

    "last": ["Schafer", 'Doe', 'Doe'], 

    "email": ["CoreyMSchafer@gmail.com", 'JaneDoe@email.com', 'JohnDoe@email.com']

}

import pandas as pd

df = pd.DataFrame(people)

Python Codes:

 #1. Renaming all column headers in pandas at once

df.columns = ['first_name', 'last_name', 'email']

#2. Upper case all columns name in pandas at once

df.columns  = [x.upper() for x in df.columns]

#3. lower case all columns name in pandas at once

df.columns  = [x.lower() for x in df.columns]

Exploratory Data Analysis (EDA)