Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Вивчайте Reading XLS/XLSX Files | Reading and Exploring Data
Introduction to pandas [track]
course content

Зміст курсу

Introduction to pandas [track]

Introduction to pandas [track]

1. Basics
2. Reading and Exploring Data
3. Accessing DataFrame Values
4. Aggregate Functions

book
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)
copy

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 2. Розділ 2

Запитати АІ

expand

Запитати АІ

ChatGPT

Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат

course content

Зміст курсу

Introduction to pandas [track]

Introduction to pandas [track]

1. Basics
2. Reading and Exploring Data
3. Accessing DataFrame Values
4. Aggregate Functions

book
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)
copy

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 2. Розділ 2
some-alt