时间戳

首页 > 解决方案 > 在下一个数据帧中将起始索引设置为 50001

python - 在下一个数据帧中将起始索引设置为 50001

问题描述

我有 5 个数据框

打开第一个有 50000 行的

                Date Clearing Member PAN Trading Member PAN  
0     01-15-2021          AAACM6094R         AAACM6094R  
1     01-15-2021          AAACM6094R         AAACM6094R  
2     01-10-2021          AAACM6094R         AAACM6094R  
3     01-15-2021          AAACM6094R         AAACM6094R  
4     01-16-2021          AAACM6094R         AAACM6094R  
...          ...                 ...                ...  
49999   11-1-2023          AAACG4267G         AAACK1089Q

打开下一个数据帧我需要将起始索引设置为 50001 并为下一个数据帧设置 smilially 它应该是 100001 在最后一个数据帧中它可以是任意数量的行但起始索引应该是 200001

        vaex_df2.index = range(50001, vaex_df2.shape[0] + 1)

这会引发错误

      File "D:\test\CR6645script.py", line 361, in <module>
    CompareCSV(c,d)
  File "D:\test\CR6645script.py", line 84, in CompareCSV
    vaex_df2.index = range(50001, vaex_df2.shape[0] + 1)
  File "C:\Users\ncdex1124\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\generic.py", line 5491, in __setattr__
    return object.__setattr__(self, name, value)
  File "pandas\_libs\properties.pyx", line 70, in pandas._libs.properties.AxisProperty.__set__
  File "C:\Users\ncdex1124\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\generic.py", line 763, in _set_axis
    self._mgr.set_axis(axis, labels)
  File "C:\Users\ncdex1124\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\internals\managers.py", line 216, in set_axis        
    self._validate_set_axis(axis, new_labels)
  File "C:\Users\ncdex1124\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\internals\base.py", line 57, in _validate_set_axis   
    raise ValueError(
ValueError: Length mismatch: Expected axis has 1024 elements, new values have 0 elements

标签： pythonpandasdataframe

解决方案

尝试：

vaex_df2.index += 50001
vaex_df3.index += 100001

或者

vaex_df2.index += vaex_df1.index[-1] + 1
vaex_df3.index += vaex_df2.index[-1] + 1

推荐阅读