How can I split this column in order to have for example my column [bike] with value 0, then 1, 17 ...so on and the same for [stands]', [mechanicalBikes] ... up to a [capacity] column so that I can have numbers per date/time? I have imported it in Jupyter Notebook. My data type is pandas.core.frame.DataFrame and new_bike_dataset['totalStands'].dtype is dtype('O'). Ps. I'm a new learner.
teste = new_bike_dataset['availabilities'],new_bike_dataset['bikes'],new_bike_dataset['stands'],
new_bike_dataset['mechanicalBikes'],new_bike_dataset['electricalBikes'],new_bike_dataset['electricalInternalBatteryBikes'],
new_bike_dataset['electricalRemovableBatteryBikes'],
new_bike_dataset['capacity']= new_bike_dataset['totalStands'].str.split(":").str
Tried this way to see if I would have any result but knowing this isn't the right one.
