如何使用Pandas删除常用索引值？

Question

我有一个源于csv文件的文件。索引列中的所有条目都有一个公共值。如何删除此公共值？常用值为“00:00:00”

 Date/Time
 2021-01-04 00:00:00                           Compost Maker
 2021-01-05 00:00:00                    Green Up Feed & Weed
 2021-01-05 00:00:00              Nippon Mouse Trap in a Box
 2021-01-06 00:00:00                  Organic Liquid Seaweed
 2021-01-06 00:00:00                  Organic Rooting Powder                                      
 Name: Product, dtype: object

Answer 1

尝试：

df.index = pd.to_datetime(df.index).normalize()

结果:

print(df)

                               Product
Date/Time                             
2021-01-04               Compost Maker
2021-01-05        Green Up Feed & Weed
2021-01-05  Nippon Mouse Trap in a Box
2021-01-06      Organic Liquid Seaweed
2021-01-06      Organic Rooting Powder