Panda: read CSV datetime index plot
Jump to navigation
Jump to search
import pandas as pd
import glob
csv_file = '/home/onno/TensorFlow/TEMP-train.csv'
df = pd.read_csv(csv_file, names=['Time', 'Value'])
df['Time'] = pd.to_datetime(df['Time'], errors='coerce')
df['Value'] = pd.to_numeric(df['Value'], errors='coerce')
# print df
print df.head()
print df.shape
print df.dtypes
df = df.set_index('Time')
df = df.resample('1 Min').mean()
print df
print df.head()
import seaborn as sns
sns.set()
# df_plot = df_time.resample('M').mean()
df_plot = df
plt.plot(df_plot)
plt.title('Suhu')
plt.ylabel('Suhu (Celcius)')
plt.xticks(rotation=45)
plt.show()