Importing from Excel in Pandas Python [duplicate]

Question

I am trying to import data from an excel file. I would like to import from a specific sheet and in that specific sheet only import certain columns. The code I am using is as follows:

%matplotlib inline

import pandas as pd
import math
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns

sns.set(style="darkgrid")

# Input Portfolio data

xl_file=pd.ExcelFile('C:/Users/e877780/Desktop/DEV/S2_SK_S_06_02_input.xlsx')
s2_0602=xl_file.parse("S.06.02")[('C0080','C0090')]

My idea is to only import columns C0080 and C0090. I I just use one, it works but also does not keep the column name. Can someone help Thks

Use pandas read_excel. You can specify the sheetname and columns to use. — m13op22
– m13op22, Commented Mar 28, 2019 at 15:45

miuxu · Accepted Answer · 2019-03-28 16:33:25Z

0

You can try this:

xl_file=pd.ExcelFile('C:/Users/e877780/Desktop/DEV/S2_SK_S_06_02_input.xlsx')
sheet1=xl_file.parse("S.06.02")
s2_0602 = sheet1[['C0080','C0090']]

Hope it help

answered Mar 28, 2019 at 16:33

miuxu

1811 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3038679 Over a year ago

Thank you. It works fine

Collectives™ on Stack Overflow

Importing from Excel in Pandas Python [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related