Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

pandas data frame from part of excel

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)
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #pandas #data #frame #part #excel
ADD COMMENT
Topic
Name
4+5 =