Skip to content

Instantly share code, notes, and snippets.

@devmnj

devmnj/pandas_xl_read_column.py

Last active December 31, 2023 05:59
Show Gist options
  • Save devmnj/cd1c76c7c83dee9b7ede62ddd31ffe58 to your computer and use it in GitHub Desktop.
Save devmnj/cd1c76c7c83dee9b7ede62ddd31ffe58 to your computer and use it in GitHub Desktop.
Download ZIP
Read excel file using Python, specify column range
Raw
pandas_xl_read_column.py
import pandas as pd
import numpy as np
series=pd.read_excel(r'C:/Users/hp/OneDrive/documents/mahdata.xlsx',sheet_name='EASY', usecols='B:G',header=None,
index_col=False)
series= series.to_numpy()
data = np.flip(series,axis=0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment