pandas-test.py

import pandas as pd
import numpy as np
import datetime


df = pd.DataFrame()
df1 = pd.DataFrame(
	{
	'col_0': [0, 1, 2],
	'col_1': np.arange(3, 6),
	'col_2': (6, 7, 8),
	'col_3':	(
		datetime.datetime.now(),
		datetime.datetime.now() + datetime.timedelta(hours=3),
		datetime.datetime.now() + datetime.timedelta(hours=6)
		),
	}
	)
df = df.append(df1, ignore_index=True)
df = df.append({
		'col_0': 0,
		'col_1': 100,
		'col_2': 200,
		'col_3': datetime.datetime.now(),
	},
	ignore_index=True)

df2 = pd.DataFrame(
	{
	'col_0': [3, 4, 5],
	'col_1': np.arange(3, 6),
	'col_2': (6, 7, 8),
	'col_3':	(
		datetime.datetime.now(),
		datetime.datetime.now() + datetime.timedelta(hours=7),
		datetime.datetime.now() + datetime.timedelta(hours=8)
		),
	}
	)
print(df)
print("-----------------------------")
print(df['col_0'])
print("-----------------------------")
print(df[ ['col_0', 'col_3'] ])
print("-----------------------------")
print(df[ ['col_0'] ])
print("-----------------------------")
print(df[ df['col_0'] > 1])

print("-----------------------------")
df = df.append(df2, ignore_index=True)

df.insert(0, "basetime", df['col_3'][0])
df["diff"] = df["col_3"] - df["basetime"]
del df["basetime"]

df["diffhour"] = df["diff"] / np.timedelta64(1, "h")

print(df)
df.to_csv('to_csv_out.csv')

with pd.ExcelWriter('test.xlsx') as writer:
	df.to_excel(writer, sheet_name='sheet1')
	df.to_excel(writer, sheet_name='sheet2')