Search code examples
pythonpandasbokeh

Using excel tables as a source for Bokeh plot


How can I use an existing data table (e.g. Excel sheet) as a source for Bokeh data plot?


Solution

  • Pandas natively supports reading from Excel sheets in to DataFrames with read_excel:

    df = pd.read_excel(...)
    

    And Bokeh can adapt Pandas DataFrames directly:

    source = ColumnDataSource(df)