擅长:python、mysql、java
<p>将datetime64列转换为python datetime对象对我很有用。在</p>
<pre><code>from pandas import Series
def convert_to_python_datetime(df):
df_copy = df.copy()
for column_name, column in df_copy.iteritems():
if column.dtype.kind == 'M':
df_copy[column_name] = Series(column.dt.to_pydatetime(), dtype=object)
return df_copy
tmp = convert_to_python_datetime(timestamp_pandas_df)
roundtrip_df = sqlContext.createDataFrame(tmp)
roundtrip_df.printSchema()
roundtrip_df.show()
</code></pre>
<p>输出:</p>
^{pr2}$