import originpro as op
import pandas as pd
import os
fd = r'C:\Users\chris\Desktop\CSV Datasets 1000 files'
wks = op.new_sheet()
col = 0
for i, file in enumerate(os.listdir(fd)):
    if i == 0:
        df = pd.read_table(os.path.join(fd, file), sep=',')    
        df.rename(columns = {list(df)[2]:file}, inplace=True)
    else:
        df = pd.read_table(os.path.join(fd, file), sep=',', usecols=['Count'])    
        df.rename(columns = {list(df)[0]:file}, inplace=True)        
    wks.from_df(df, col)
    col = wks.cols
wks.cols_axis('x',1,1)

quote:

---

Originally posted by YimingChen

Would you mind sharing the project file with the deformed workbook?

---