Breaking News: Grepper is joining You.com. Read the official announcement!

pandas data frame from part of excel openpyxl

Add Answer

Pleasant Panther answered on July 14, 2021 Popularity 2/10 Helpfulness 1/10

answer pandas data frame from part of excel openpyxl

related pandas data frame from part of excel better example

related pandas data frame from part of excel

related pandas data frame from part of excel easy

pandas data frame from part of excel openpyxl

Comment

from openpyxl import load_workbook

wb = load_workbook(filename='data.xlsx', 
                   read_only=True)

ws = wb['Sheet2']

# Read the cell values into a list of lists
data_rows = []
for row in ws['A3':'D20']:
    data_cols = []
    for cell in row:
        data_cols.append(cell.value)
    data_rows.append(data_cols)

# Transform into dataframe
import pandas as pd
df = pd.DataFrame(data_rows)

Popularity 2/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: excel frame openpyxl pandas python

Link to this answer
Share Copy Link

Contributed on Jul 14 2021

Pleasant Panther

0 Answers Avg Quality 2/10

Closely Related Answers

pandas data frame from part of excel better example

Comment

pd.read_excel('resultat-elections-2012.xls', sheet_name = 'France entière T1T2', skiprows = 2,  nrows= 5, usecols = 'A:H')
pd.read_excel('resultat-elections-2012.xls', index_col = None, skiprows= 2, nrows= 5, sheet_name='France entière T1T2', usecols=range(0,8))

Popularity 3/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: frame python excel pandas

Link to this answer
Share Copy Link

Contributed on Jul 14 2021

Pleasant Panther

0 Answers Avg Quality 2/10

pandas data frame from part of excel

Comment

import openpyxl
import pandas as pd

wb = openpyxl.load_workbook('data.xlsx')
sheet = wb.get_sheet_by_name('Sheet2')
range = ['A3':'D20']   #<-- how to specify this?
spots = pd.DataFrame(sheet.range) #what should be the exact syntax for this?

print (spots)

Popularity 3/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: frame pandas excel python

Link to this answer
Share Copy Link

Contributed on Jul 14 2021

Pleasant Panther

0 Answers Avg Quality 2/10

pandas data frame from part of excel easy

Comment

df = read_excel(filename, 'Sheet2', skiprows = 2, parse_cols = 'A:D')

Popularity 3/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: pandas python frame excel

Link to this answer
Share Copy Link

Contributed on Jul 14 2021

Pleasant Panther

0 Answers Avg Quality 2/10

pandas data frame from part of excel openpyxl

Contents

More Related Answers

pandas data frame from part of excel openpyxl

Closely Related Answers

pandas data frame from part of excel better example

pandas data frame from part of excel

pandas data frame from part of excel easy

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.