Reading XLS/XLSX Files
In addition to the csv format, there is also the equally popular xls/xlsx format, representing Excel spreadsheets.
Can pandas
handle with this format? Unfortunately, not itslef. In order to be able to read excel files, you need to have openpyxl
library being installed.
To install library in Python, open Terminal/Command Prompt (MacOC/Windows, respectively), and write
pip3 install library_name
. For instance,pip3 install openpyxl
.
123456# Importing library import pandas as pd # Reading excel file df = pd.read_excel('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.xlsx') print(df)
Дякуємо за ваш відгук!
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
Запитайте мені питання про цей предмет
Сумаризуйте цей розділ
Покажіть реальні приклади
Awesome!
Completion rate improved to 3.33
Reading XLS/XLSX Files
Свайпніть щоб показати меню
In addition to the csv format, there is also the equally popular xls/xlsx format, representing Excel spreadsheets.
Can pandas
handle with this format? Unfortunately, not itslef. In order to be able to read excel files, you need to have openpyxl
library being installed.
To install library in Python, open Terminal/Command Prompt (MacOC/Windows, respectively), and write
pip3 install library_name
. For instance,pip3 install openpyxl
.
123456# Importing library import pandas as pd # Reading excel file df = pd.read_excel('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.xlsx') print(df)
Дякуємо за ваш відгук!