[pandas] Getting started

1. Define a pandas dataframe

pd.DataFrame({'Tom': ['three stars', 'one star'], 
              'Suzy': ['two stars', 'five stars']},
             index=['Product A', 'Product B'])

	Tom	Suzy
Product A	three stars	two stars
Product B	one star	five stars

2. Define a pandas series

pd.Series([3, 1, 5], index=['Product A', 'Product B', 'Product C'], name='My review')

Product A    3
Product B    1
Product C    5
Name: My review, dtype: int64

3. Load a csv

my_review = pd.read_csv("../data/my_review.csv", index_col=0)
# if csv already contains index column at 0 index

4. Indexing and assigning

df["Tom"]
df.Tom

product A    three stars
product B       one star

단.. 컬럼 이름에 space 가 들어가면? df["Tom 2"] 만 가능

 

df["Tom"]["Prouct A"]

three stars