python pandas 라이브러리를 이용한 엑셀(excel)파일 읽어들이기.

1. python Pandas 라이브러리 설치하기

   : pip install pandas
pip install xlrd

2. 샘플 엑셀파일 받기   

(위에 다운받은 파일을 넣은 폴더안에 임의의 python 파일을 만들어서 붙여넣는다)

import pandas as pd

excel_file = 'movies.xls'
movies = pd.read_excel(excel_file)
print(movies.head())
print(movies.shape)

print('---------------------------------------------------------------')
#sheet1 을 읽어온다.
movies_sheet1 = pd.read_excel(excel_file, sheet_name=0, index_col=0)
print(movies_sheet1.head())
print(movies_sheet1.shape)

print('---------------------------------------------------------------')
#sheet2 을 읽어온다
movies_sheet2 = pd.read_excel(excel_file, sheet_name=1, index_col=0)
print(movies_sheet2.head())
print(movies_sheet2.shape)

print('---------------------------------------------------------------')
#sheet3 을 읽어온다.
movies_sheet3 = pd.read_excel(excel_file, sheet_name=2, index_col=0)
print(movies_sheet3.head())
print(movies_sheet3.shape)

print('--------------------------------------------------------------')
#위의 sheet1, 2, 3 을 모두 합친다.
movies = pd.concat([movies_sheet1, movies_sheet2, movies_sheet3])
print(movies.shape)

————————————  실행결과 --------------------------------------------------

D:\ProgramData\miniconda3\python.exe D:/02_Workspace/python/ptest/movie.py
                                               Title  ...  IMDB Score
0  Intolerance: Love's Struggle Throughout the Ages   ...         8.0
1                    Over the Hill to the Poorhouse   ...         4.8
2                                    The Big Parade   ...         8.3
3                                        Metropolis   ...         8.3
4                                     Pandora's Box   ...         8.0

[5 rows x 25 columns]
(1338, 25)
---------------------------------------------------------------
                                                   Year  ... IMDB Score
Title                                                    ...           
Intolerance: Love's Struggle Throughout the Ages   1916  ...        8.0
Over the Hill to the Poorhouse                     1920  ...        4.8
The Big Parade                                     1925  ...        8.3
Metropolis                                         1927  ...        8.3
Pandora's Box                                      1929  ...        8.0

[5 rows x 24 columns]
(1338, 24)
---------------------------------------------------------------
                        Year  ... IMDB Score
Title                         ...           
102 Dalmatians          2000  ...        4.8
28 Days                 2000  ...        6.0
3 Strikes               2000  ...        4.0
Aberdeen                2000  ...        7.3
All the Pretty Horses   2000  ...        5.8

[5 rows x 24 columns]
(2100, 24)
---------------------------------------------------------------
                                        Year  ... IMDB Score
Title                                         ...           
127 Hours                             2010.0  ...        7.6
3 Backyards                           2010.0  ...        5.2
3                                     2010.0  ...        6.8
8: The Mormon Proposition             2010.0  ...        7.1
A Turtle's Tale: Sammy's Adventures   2010.0  ...        6.1

[5 rows x 24 columns]
(1604, 24)
--------------------------------------------------------------
(5042, 24)

Process finished with exit code 0

만족하셨나요? ~~~~~~~

#pandas #Python Pandas #Python Excel 읽기