Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Reading XLS/XLSX Files | Reading and Exploring Data
Introduction to pandas [track]
course content

Kursinnhold

Introduction to pandas [track]

Introduction to pandas [track]

1. Basics
What is pandas?SeriesIndexes and ValuesChallengeDataFramesIndexes and ColumnsChallenge
2. Reading and Exploring Data
Reading CSV FilesReading XLS/XLSX FilesExploring Data [1/3]ChallengeExploring Data [2/3]Exploring Data [3/3]Challenge
3. Accessing DataFrame Values
Accessing Specific ColumnsChallengeAccessing Specific RowsChallengeAccessing Rows and ColumnsAccessing using .loc[] [1/3]Accessing using .loc[] [2/3]Accessing using .loc[] [3/3]
4. Aggregate Functions
Number of ObservationsUnique ObservationsCounting ValuesChallengeSum and ProductMean and MedianChallengeMinimum and Maximum

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

Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 2. Kapittel 2

Spør AI

expand
ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

course content

Kursinnhold

Introduction to pandas [track]

Introduction to pandas [track]

1. Basics
What is pandas?SeriesIndexes and ValuesChallengeDataFramesIndexes and ColumnsChallenge
2. Reading and Exploring Data
Reading CSV FilesReading XLS/XLSX FilesExploring Data [1/3]ChallengeExploring Data [2/3]Exploring Data [3/3]Challenge
3. Accessing DataFrame Values
Accessing Specific ColumnsChallengeAccessing Specific RowsChallengeAccessing Rows and ColumnsAccessing using .loc[] [1/3]Accessing using .loc[] [2/3]Accessing using .loc[] [3/3]
4. Aggregate Functions
Number of ObservationsUnique ObservationsCounting ValuesChallengeSum and ProductMean and MedianChallengeMinimum and Maximum

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

Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 2. Kapittel 2
Vi beklager at noe gikk galt. Hva skjedde?
some-alt