pandas snippets
from pandas import DataFrame
raw = {
'a': [1, 2, 3],
'b': [4, 5, 6],
'c': [7, 8, 9]
}
data1 = DataFrame(raw)
data2 = DataFrame(raw, columns=['a', 'b', 'c']) # set the order of columns
data3 = DataFrame(raw, columns=['a', 'b', 'c'], index=['2017-01-01', '2017-01-02', '2017-01-03', '2017-01-04'])
print(data3['a'])
print(data3.ix['2017-01-01'])
print(data3.columns)
print(data3.index)
from pandas import Series
s1 = Series([1, 2, 3], index=['a', 'b', 'c'])
s2 = Series([4, 5, 6], index=['b', 'c', 'a'])
s3 = s1 + s2 # 'a': 1+6, 'b': 2+4, 'c': 3+5
for i in s3.index:
print(i)
for v in s3.values:
print(v)