Pandas DataFrame and Series

1. Make data

 

#시리즈 만들기
import pandas as pd
s=pd.Series(['banana',42])
print(s)

 

#딕셔너리로 시리즈 만들기
import pandas as pd
dict_data = {'a':1,'b':2,'c':3}
series_data = pd.Series(dict_data,)

print(type(series_data))
print('\n')
print(series_data)

#시리즈 인덱스 지정
s=pd.Series(['Abc','Def'])
print(s)
print()
s=pd.Series(['Abc','Def'],index=['first','second'])
print(s)

#데이터 프레임 만들기
scientists1 = pd.DataFrame({'Name':['Rosaline franklin','William Gosset'],
                           'Occupation':['Chemist','Statistican'],
                           'Born':['1920-07-25','1876-06-13'],
                           'Died':['1958-04-16','1937-10-16'],
                           'Age':[37,61]})
print(scientists1)
print()
#인덱스주고 열지정
scientists2 = pd.DataFrame(
    data={'Occupation':['Chemist','Statistican'],
                           'Born':['1920-07-25','1876-06-13'],
                           'Died':['1958-04-16','1937-10-16'],
                           'Age':[37,61]},
                          index=['Rosaline franklin','William Gosset'],
                          columns=['Occupation','Born','Age','Died'])
print(scientists2)
print()
#데이터 순서 보장
from collections import OrderedDict
scientists3 = pd.DataFrame(OrderedDict([
                            ('Name',['Rosaline franklin','William Gosset']),
                           ('Occupation',['Chemist','Statistican']),
                           ('Born',['1920-07-25','1876-06-13']),
                           ('Died',['1958-04-16','1937-10-16']),
                           ('Age',[37,61])
])
)
print(scientists3)

---

2. Handle Series

scientists = pd.DataFrame(
    data={'Occupation':['Chemist','Statistican'],
                           'Born':['1920-07-25','1876-06-13'],
                           'Died':['1958-04-16','1937-10-16'],
                           'Age':[37,61]},
                          index=['Rosaline franklin','William Gosset'],
                          columns=['Occupation','Born','Age','Died'])

first_row=scientists.loc['William Gosset']
print(type(first_row))

print(first_row)
print(first_row.index)
print(first_row.values)
print(first_row.keys())
print(first_row.index[0])