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)