Ok my problem is the following I have a CSV that looks like the following
ML INT .10 534.15 0:00
ML EXT .25 654.23 3:00
ML INT .35 743.12 6:30
I want to be able to plot the 4th column as x axis and 5th column as y axis . the y axis will be in 12 hr format from 0:00 to 11:59
I would also like to color code the scatterplot so that INT and EXT will be either blue or red
But my problem is when i try to import the CSV it gives me an error. the following
ValueError: could not convert
string to float: b'1:00'
and also ValueError: could not convert string to float
now i guess i can only import numbers that way and not txt and o clock format
any suggestions or ideas as to how i can convert this data so i can plot??
this is the code i have so far