๊ด€๋ฆฌ ๋ฉ”๋‰ด

์†œ์”จ์ข‹์€์žฅ์”จ

[Python] Pandas read_excel ์—๋Ÿฌ - ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead. ํ•ด๊ฒฐ๋ฐฉ๋ฒ• ๋ณธ๋ฌธ

Programming/Python

[Python] Pandas read_excel ์—๋Ÿฌ - ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead. ํ•ด๊ฒฐ๋ฐฉ๋ฒ•

์†œ์”จ์ข‹์€์žฅ์”จ 2021. 9. 6. 11:44
728x90
๋ฐ˜์‘ํ˜•

๐Ÿ‘จ๐Ÿป‍๐Ÿ’ป ์˜ค๋ฅ˜ ๋‚ด์šฉ

excel_df = pd.read_excel("./test_excel.xlsx")

ExcelํŒŒ์ผ์„ ์ฝ์–ด์˜ค๋ ค๊ณ  Pandas์˜ read_excel์„ ํ™œ์šฉํ•˜๋ ค๊ณ  ํ•˜๋‹ˆ

ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead.

์œ„์™€ ๊ฐ™์€ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ–ˆ์Šต๋‹ˆ๋‹ค.

 

๋‚ด์šฉ์„ ์ž˜ ์ฝ์–ด๋ณด๋ฉด xlrd์˜ ๋ฒ„์ „์ด 2.0 ์ด์ƒ๋ถ€ํ„ฐ๋Š” xls ํ˜•์‹๋งŒ ์ง€์›ํ•œ๋‹ค! ๋ผ๊ณ  ๋˜์–ด์žˆ์Šต๋‹ˆ๋‹ค.

์ด์— xlrd์˜ ๋ฒ„์ „์„ ๋‚ฎ์ถ”์–ด ๋ณด์•„๋„ ์˜ค๋ฅ˜๊ฐ€ ํ•ด๊ฒฐ๋˜์ง€ ์•Š์•˜์Šต๋‹ˆ๋‹ค.

๐Ÿ‘จ๐Ÿป‍๐Ÿ’ป ํ•ด๊ฒฐ๋ฐฉ๋ฒ•

$ pip install openpyxl

xlrd ๋Œ€์‹  openpyxl์„ ์„ค์น˜ํ•˜๋ฉด ํ•ด๊ฒฐ๋ฉ๋‹ˆ๋‹ค.

 

์ฝ์–ด์ฃผ์…”์„œ ๊ฐ์‚ฌํ•ฉ๋‹ˆ๋‹ค.

 

728x90
๋ฐ˜์‘ํ˜•
0 Comments
๋Œ“๊ธ€์“ฐ๊ธฐ ํผ