Pandas 기초 2(데이터프레임파일 생성)

 

 

In [1]:

import pandas as pd

In [2]:

#데이터프레임 만들기

friend_dict_list = [
    {'name': 'John', 'age': 25, 'job': 'student'},
    {'name': 'Nate', 'age': 30, 'job': 'teacher'},
]

In [3]:

df = pd.DataFrame(friend_dict_list)

In [4]:

df.head()

Out[4]:

	name	age	job
0	John	25	student
1	Nate	30	teacher

In [5]:

#순서 지정
df = df[['name', 'age', 'job']]

In [6]:

df.head()

Out[6]:

	name	age	job
0	John	25	student
1	Nate	30	teacher

In [7]:

#컬럼 순서 고정(OrderedDict 사용)
from collections import OrderedDict

In [8]:

friend_ordered_dict = OrderedDict(
[
    ('name', ['John', 'Nate']),
    ('age', ['25', '30']),
    ('job', ['student', 'teacher']),
]
)

In [9]:

df = pd.DataFrame.from_dict(friend_ordered_dict)

In [10]:

df.head()

Out[10]:

	name	age	job
0	John	25	student
1	Nate	30	teacher

In [11]:

#리스트 두개 합쳐서 데이터프레임 만들기
friend_list = [
    ['John', 25, 'student'],
    ['Nate', 30, 'teacher'],
]

In [12]:

column_name = ['name', 'age', 'job']

In [14]:

df = pd.DataFrame.from_records(friend_list, columns = column_name)

In [15]:

df.head()

Out[15]:

	name	age	job
0	John	25	student
1	Nate	30	teacher

In [16]:

#한번에 만들고 싶을때
friend_list = [
    ['name', ['John', 'Nate']],
    ['age', [20, 30]],
    ['job', ['student', 'teacher']]
]

In [17]:

df.head()

Out[17]:

	name	age	job
0	John	25	student
1	Nate	30	teacher

In [ ]: