....

df=pd.read_csv(os.path.join(directory,'1.csv'))



cols =['Order Qty (SL)','Confirmed Qty (SL)','Unconfirmed Qty (SL)','Cancelled Qty (SL)','Open Qty (SL)','Reserved Qty (SL)',

    'Fixed Qty (SL)','% Allocation (SL)','Delivered Qty (SL)','PGI Qty (SL)','Invoiced Qty (SL)',
    'Net Unit Price','Confirmed Net Value (SL)','Dollars Shipped (SL)','% Shipped/Allocated (SL)']

print(*df.loc[:len(df) - 2, cols].replace(',', '', regex=True).apply(pd.to_numeric).dtypes.value_counts().items())

import sys
sys.exit()