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

Removing first n characters from column values in Pandas DataFrame

Programming

Python

Pandas

Cookbooks

DataFrame Cookbooks

Data Manipulation Cookbook

Mar 10, 2022

Last updated

local_offer Python●Pandas

Tags

Table of Contents

Consider the following Pandas DataFrame with a column of strings:


        
        
            
                
                
                    df = pd.DataFrame({"A":["a","ab","abc"]})
df
                
            
               A
0  a
1  ab
2  abc

To remove the first n characters from values from column A from this DataFrame:


        
        
            
                
                
                    df["A"].str[1:]
                
            
            0      
1     b
2    bc
Name: A, dtype: object

Note that a new DataFrame is returned here and the original is kept intact.

Published by Isshin Inada

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

A modern learning experience for data science and analytics