Data Manipulation Cookbook

Adding a prefix to column values Adding leading zeros to strings of a column Adding new column using lists Adding padding to a column of strings Bit-wise OR Changing column type to string Conditionally updating values of a DataFrame Converting all object-typed columns to categorical type Converting column type to date Converting column type to float Converting column type to integer Converting K and M to numerical form Converting string categories or labels to numeric values Encoding categorical variables Expanding lists vertically in a DataFrame Expanding strings vertically in a DataFrame Extracting numbers from column Filling missing value in Index of DataFrame Filtering column values using boolean masks Logical AND operation Making DataFrame string column lowercase Mapping True and False to 1 and 0 respectively Mapping values of a DataFrame using a dictionary Modifying a single value in a DataFrame Removing characters from columns Removing comma from column values Removing first n characters from column values Removing last n characters from column values Removing leading substring Removing trailing substring Replacing infinities with another value in DataFrame Replacing values in a DataFrame Rounding values Sorting categorical columns Using previous row to create new columns

thumb_up

thumb_down

chat_bubble_outline
0
 auto_stories new 
settings

Making DataFrame string column lowercase in Python

Programming

Python

Pandas

Cookbooks

DataFrame Cookbooks

Data Manipulation Cookbook

Jul 1, 2022

Last updated

local_offer Python●Pandas

Examples

Consider the following DataFrame:


        
        
            
                
                
                    df = pd.DataFrame({"A": ["HELLO", "Friend"], "B": ["Sky", "ToWnEr"]})
df
                
            
                    A       B
0   HELLO     Sky
1  Friend  ToWnEr

To convert strings in column "A" to lowercase:


        
        
            
                
                
                    df["A"] = df["A"].str.lower()
df
                
            
                    A       B
0   hello     Sky
1  friend  ToWnEr

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Share on Twitter

Share on Facebook

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!