0

How can I trim an entire dataframe for all spaces?

The code I tried is

for file in Path(a_directory).glob('*.xlsx'):
    dfTemp = pd.read_excel(file, sheet_name='Sheet1')
    dfTrimmed = dfTemp.replace(r'^ +| +$', r'', regex=True)

    dfTrimmed = dfPrep.sort_values(by=Keys, ignore_index = True)
    dfSheet2 = pd.read_excel(file, sheet_name='Sheet2')
        
    dfSheet2_adapted= dfSheet2.loc[:, dfTrimmed.columns].sort_values(by=Keys, ignore_index = True)

    print (dfTrimmed)

    print (dfSheet2)
    
    Checkdf= dfTrimmed.equals(dfSheet2_adapted)
TomH
  • 11
  • 2

0 Answers0