I have 3 column data in large text file which each column contains 1d array. first column (x) is time as datetime format, second column (y) is frequency and third column (z) is Power in dB. Here is the example data.
x (datetime) y(freq(hz)) z(power(dB))
2017-10-03 14:23:14.787976 80000000.0 3.410517462
2017-10-03 14:23:14.788147 80006250.0 3.74720499199
2017-10-03 14:23:14.788245 80012500.0 3.48457072216
2017-10-03 14:23:14.788334 80018750.0 3.82477967161
2017-10-03 14:23:14.788423 80025000.0 4.10110487733
I would like to plot these data to spectrogram using matplotlib contour with time(x) as x axis, freq as y axis and power as contour. I've mesh x and y as coordinat with np.meshgrid but z is still 1d array, it seem like 1d array format doesn't support to plot with contour. Should i convert z into 2d array? If so, how do i turn z into 2d array?