PYTHON

Python function remove all whitespace from all character columns in dataframe

df.columns = df.columns.str.replace(' ', '')

pandas strips spaces in dataframe

df_obj = df.select_dtypes(['object'])
print (df_obj)
0    a  
1    c  

df[df_obj.columns] = df_obj.apply(lambda x: x.str.strip())
print (df)

   0   1
0  a  10
1  c   5

removing whitespaces from pandas dataframe csv

df = pd.read_csv('dataframe', sep = 's*,s*', engine = 'python')

pandas remove whitespace

str.strip() method

remove whitespace from data frame

# importing library
import pandas as pd
 
# reading csv file and at a same time using skipinitial attribute which will remove extra space
df = pd.read_csv('student_data.csv', skipinitialspace = True)
 
# printing dataset
print(df)