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)
Merci pour vos commentaires !
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion
Posez-moi des questions sur ce sujet
Résumer ce chapitre
Afficher des exemples du monde réel
Génial!
Completion taux amélioré à 3.33Reading XLS/XLSX Files
Glissez pour afficher le menu
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)
Merci pour vos commentaires !
