解决pandas写大量数据到mysql，报system error: 32 Broken pipe

把数据切成以一万为单位进行存储

        size = 10000
        df_size = len(df)
        num = df_size//size
        end_ = 0
        for i in range(num):
            begin = i*size
            end = begin+size
            end_ = end
            print(begin,end)
            df_sub = df.iloc[begin:end]
            df_sub.to_sql('xpa',engine,index=False,if_exists='append')
        df_sub = df.iloc[end_:]
        df_sub.to_sql('xpa_raw_data',con=engine,index=False,if_exists='append')