znagadeon
10/24/2017 - 10:35 AM

pandas snippets

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)