我有一个带有这些列的汽车的数据框.
Car_code
、car_model
、update_Date
、sensor_codes
每辆车都有多个传感器,分别列在sensor_codes
和/
之间,如下所示:
df = pd.DataFrame([['x','iii-2019-10-16','18/04/2019','115/556/879/115'],
['x','iii-2019-10-16','21/07/2019','87/998/115'],
['x','iii-2019-10-16','','115/556/879'],
['x','zzz-2020-10-25','12/04/2022',''],
['y','qqq-2018-05-28','10/12/2017','789/554/745'],
['y','qqq-2018-05-28','15/02/2018','789/554/75'],
['y','ooo-2019-11-22','30/05/2019','55'],
['y','rrr-16-12-2020','16/12/2020',''],
['z','ppt-2019-12-03','07/02/2018','889/654/750'],
['z','ttt-2019-12-03','28/05/2019','119/55/75'],
['z','ttt-2019-12-03','09/09/2019'],
['z','ttt-2019-12-03','30/09/2019']
],
columns=['Car_code','car_model','update_Date','sensor_codes'])
df
我需要创建一个只有两列的新数据框:Car_code
和传感器代码(将包含唯一的传感器),因此每个car_code
都有多行,每个行都有一个传感器,如下所示: