simple_sales="""
[
{
"购买时间": "2023-10-01 09:30:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 10:15:00",
"订单金额": 1999
},
{
"购买时间": "2023-10-01 09:31:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 11:20:00",
"订单金额": 12999
},
{
"购买时间": "2023-10-01 09:32:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 14:45:00",
"订单金额": 4599
},
{
"购买时间": "2023-10-01 10:16:00",
"订单金额": 1999
},
{
"购买时间": "2023-10-01 15:30:00",
"订单金额": 2999
},
{
"购买时间": "2023-10-01 09:30:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 16:10:00",
"订单金额": 2399
},
{
"购买时间": "2023-10-01 17:00:00",
"订单金额": 4399
},
{
"购买时间": "2023-10-02 09:30:00",
"订单金额": 1999
}
]
"""
import pandas as pd
sales_df = pd.read_json(simple_sales)
print(sales_df.duplicated())
simple_sales="""
[
{
"购买时间": "2023-10-01 09:30:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 10:15:00",
"订单金额": 1999
},
{
"购买时间": "2023-10-01 09:31:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 11:20:00",
"订单金额": 12999
},
{
"购买时间": "2023-10-01 09:32:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 14:45:00",
"订单金额": 4599
},
{
"购买时间": "2023-10-01 10:16:00",
"订单金额": 1999
},
{
"购买时间": "2023-10-01 15:30:00",
"订单金额": 2999
},
{
"购买时间": "2023-10-01 09:30:00",
"订单金额": 6999
},
{
"购买时间": "2023-10-01 16:10:00",
"订单金额": 2399
},
{
"购买时间": "2023-10-01 17:00:00",
"订单金额": 4399
},
{
"购买时间": "2023-10-02 09:30:00",
"订单金额": 1999
}
]
"""
import pandas as pd
sales_df = pd.read_json(simple_sales)
print(sales_df.duplicated())