gpt4 book ai didi

python - pandas DataFrame 删除连续的重复项

转载 作者:行者123 更新时间:2023-12-01 22:35:50 36 4
gpt4 key购买 nike

<分区>

如何删除 DataFrame 中连续/连续/相邻的重复项?

我正在处理 CSV 格式的数据,按日期排序,然后按标识号排序。标识号可以出现在不同的日子,但我只想删除每天的重复项。 drop_duplicates 留下一个唯一实例,但随后在所有其他日期删除该标识符。我试过了 this ,但得到错误:

localhost:~/Desktop/Public$ python3 test.py 
Traceback (most recent call last):
File "test.py", line 31, in <module>
df2.loc[df2.shift(1) != df2]
File "/usr/lib/python3/dist-packages/pandas/core/indexing.py", line 1028, in __getitem__
return self._getitem_axis(key, axis=0)
File "/usr/lib/python3/dist-packages/pandas/core/indexing.py", line 1148, in _getitem_axis
raise ValueError('Cannot index with multidimensional key')
ValueError: Cannot index with multidimensional key

编辑原始帖子以添加:

我试过 index_reset() 来删除任何多索引。这是数据集的示例:

,DATE,REC,NAME
0,07/02/2009,682566,"Schmoe, Joe"
1,07/02/2009,244828,"Doe, Joe"
2,07/11/2009,325640,"Black, Joe"
3,07/11/2009,544440,"Dirt, Joe"
4,07/11/2009,544440,"Dirt, Joe"
5,07/16/2009,200560,"White, Joe"
6,07/16/2009,685370,"Purple, Joe"
7,07/16/2009,685370,"Purple, Joe"
8,07/16/2009,635400,"Red, Joe"
9,07/16/2009,348562,"Blue, Joe

36 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com