擅长:python、mysql、java
<p>基于Mike N的答案…转换为unix时间以正确分散,然后将轴标签从int64s转换回字符串:</p>
<pre><code>type(df.ts1[0])
</code></pre>
<p><code>pandas.tslib.Timestamp</code></p>
<pre><code>df['t1'] = df.ts1.astype(np.int64)
df['t2'] = df.ts2.astype(np.int64)
fig, ax = plt.subplots(figsize=(10,6))
df.plot(x='t1', y='t2', kind='scatter', ax=ax)
ax.set_xticklabels([datetime.fromtimestamp(ts / 1e9).strftime('%H:%M:%S') for ts in ax.get_xticks()])
ax.set_yticklabels([datetime.fromtimestamp(ts / 1e9).strftime('%H:%M:%S') for ts in ax.get_yticks()])
plt.show()
</code></pre>
<p><a href="https://i.stack.imgur.com/MWYfy.png" rel="noreferrer"><img src="https://i.stack.imgur.com/MWYfy.png" alt="enter image description here"/></a></p>