wb = op.load_workbook(filename=BytesIO(bb)) ws = wb.worksheets[0] _data = ws.values columns = next(_data)[0:] df = pd.DataFrame(_data, columns=columns)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter