I have CSV data in a file that looks like:
timestamp,operation,trace_id,elapsed 2019-10-16T04:00:02Z,tsm1_cache_snapshot,0IWgPXJG000,0.609221 2019-10-16T04:00:03Z,tsm1_compact_group,0IWgPTPG000,2.641524 2019-10-16T04:00:04Z,tsm1_cache_snapshot,0IWgPe7G000,0.451853
Read it with:
df = pandas.read_csv('ops.csv', parse_dates=['timestamp'])
df.dtypes timestamp datetime64[ns, UTC] operation object trace_id object elapsed float64 dtype: object
I want to scatter plot with ‘timestamp’ on the x-axis and ‘elapsed’ on the y-axis. I’ve tried:
TypeError: data type not understood
I’ve tried a number of other things. The best I’ve gotten so far is a scatter plot with all points stacked on top of each other.
How do I get it to plot correctly?