Write like this

import pandas as pd excel = pd.ExcelFile('xxx.xlsx') xxx_projects = excel.parse ('project', index_col = "url") df_xxx= pd.DataFrame(xxx_projects)

Supplement

About the third line

From the sheet named project, url is indexed by the column and the contents are fetched.

index_col is not required either. However, it feels like it can have a role as an index by specifying it.

In other words, it feels like you're specifying the url as the index row. If not specified, the line starts at 0.

Recommended Posts

Create a dataframe from excel using pandas

Create a pandas Dataframe from a string.

Edit Excel from Python to create a PivotTable

Create a C array from a Python> Excel sheet

[Python pandas] Create an empty DataFrame from an existing DataFrame

[python] Create table from pandas DataFrame to postgres

Create a phylogenetic tree from Biopyton using ClustalW2

Run a python script from excel (using xlwings)

Export pandas dataframe to excel

Convert from Pandas DataFrame to System.Data.DataTable using Python for .NET

Create a GCE instance from a GCR Docker image using terraform

[Python] Random data extraction / combination from DataFrame using random and pandas

Create a nested dictionary using defaultdict

Create a CRUD API using FastAPI

Create a C wrapper using Boost.Python

How to paste a CSV file into an Excel file using Pandas

Create an API that returns data from a model using turicreate

Create a pandas Dataflame by searching the DB table using sqlalchemy

DataFrame of pandas From creating a DataFrame from two lists to writing a file

[Python] Create a Batch environment using AWS-CDK

Create a standings from JFL match results

Create a deb file from a python package

How to create a repository from media

Download Pandas DataFrame as a CSV file

100 Language Processing Knock-34 (using pandas): "A B"

Create multiple line charts from a data frame at once using Matplotlib

Create a tool to automatically furigana with html using Mecab from Python3

[Python] [Excel] Operate an Excel sheet from Python using openpyxl (using a test sheet as an example)

[Python / Tkinter] Search for Pandas DataFrame → Create a simple search form to display

Create a stack with a queue and a queue with a stack (from LetCode / Implement Stack using Queues, Implement Queue using Stacks)

Create a GIF file using Pillow in Python

How to create a function object from a string

Create a beauty pageant support app using PyLearn2

Automatically create Ansible configuration files (vars) from excel (Ansible)

Excel-> pandas-> sqlite

Python pandas: Search for DataFrame using regular expressions

Create a game UI from scratch with pygame2!

Let's create a REST API using SpringBoot + MongoDB

Create a New Todoist Task from Python Script

Create a record table from JFL match results

Create a binary data parser using Kaitai Struct

Create a web map using Python and GDAL

Create a protein sequence mutation library in pandas

Create a score ranking from JFL match results

Create a decision tree from 0 with Python (1. Overview)

Create a datetime object from a string in Python (Python 3.3)

Run a Python file from html using Django

Create a visitor notification system using Raspberry Pi

Create a Mac app using py2app and Python3! !!

Create a MIDI file in Python using pretty_midi

Create a Word Cloud from an academic program

Create a GUI on the terminal using curses

How to create a radial profile from astronomical images (Chandra, XMM etc.) using python

Create a data collection bot in Python using Selenium

[Python] Create a ValueObject with a complete constructor using dataclasses

DJango Note: From the beginning (using a generic view)

[Python] Summary of table creation method using DataFrame (pandas)

Create a pseudo REST API server using GitHub Pages

[CRUD] [Django] Create a CRUD site using the Python framework Django ~ 2 ~

I tried reading data from a file using Node.js.

Create a company name extractor with python using JCLdic