Search
 
SCRIPT & CODE EXAMPLE
 

PYTHON

pandas read excel certain columns

df = pd.read_excel(file_location,sheet_name='Sheet1', usecols="A,C,F")
Comment

pandas read excel certain columns

import pandas as pd
import numpy as np
file_loc = "path.xlsx"
df = pd.read_excel(file_loc, index_col=None, na_values=['NA'], usecols = "A,C:AA")
print(df)
Comment
PREVIOUS NEXT
Code Example
Python :: how to print all items in a list python 
Python :: openpyxl read cell value 
Python :: python reference parent module 
Python :: turtle with python 
Python :: multiline comment in python 
Python :: How to Adjust Title Position in Matplotlib 
Python :: open gui window python 
Python :: concatenate string and int python 
Python :: how to add python interpreter in vscode 
Python :: prime number checking algorithm 
Python :: xls in python 
Python :: format column from string to numeric in python 
Python :: pygame.events 
Python :: multiprocessing pool pass additional arguments 
Python :: python gui 
Python :: timedelta python days 
Python :: polish notation python 
Python :: how to get the last value in a list python 
Python :: smtp python set subject 
Python :: how to change todays date formate in python 
Python :: vscode python workding directory 
Python :: odoo order by xml rpc 
Python :: how to change values of dictionary in python 
Python :: ValueError: query data dimension must match training data dimension 
Python :: uninstall python3 from source on centos 7 
Python :: python close gile 
Python :: python if elif else 
Python :: pip --version 
Python :: how to add subtitle to matplotlib 
Python :: range of y & x in scatter 
ADD CONTENT
Topic
Content
Source link
Name
3+9 =