import pandas as pd

path = r'd://data//11.csv'

df = pd.read_csv(path, encoding='gb18030')
df.reset_index(inplace=True)
print(df.columns)
df.columns = [i.replace('()', '') for i in df.columns]
wind_names = set([i.split('#-')[0] for i in df.columns if i.find('#-') > -1])
print(df.columns)
print(wind_names)
for wind_name in wind_names:
    select_cols = [i for i in df.columns if str(i).startswith(wind_name)]
    print(select_cols)
    select_cols.insert(0, '时间')
    print(select_cols)
    df_temp = df[select_cols]
    df_temp.columns = [i.split('#-')[-1] for i in df_temp.columns]

    df_temp.sort_values(by='时间', inplace=True)

    df_temp.to_csv("d://data//najiade//"+str(wind_name) + '.csv', encoding='utf8', index=False)