Time Series Help, Excel file will not load

Community Support
1

I’m super new to Bokeh and I have started to run into problems when trying to work with my own personal data. I’m using the IPython Notebook to run this project on Windows 8.1. I was able to run the example Timeseries on the IPython notebook with no problems.

#Setup properly
import pandas as pd
from bokeh.charts import TimeSeries, output_file, output_notebook, show

#Get data

xl_file = pd.ExcelFile(test_processed_data)

``

My data is currently saved in my computer as test_processed_data(it’s a .xlsx) in my Documents folder on my windows laptop. I first used the pd.read_csv Remember this is my first time using Bokeh period, so I need all the help/ advice you’re willing to give.

Thanks,

Caroline

2

You need to use the read_excel method from pandas. See the pandas documentation: https://pandas-docs.github.io/pandas-docs-travis/io.html#io-excel

···

On Sun, Jul 26, 2015 at 7:33 AM, Caroline Dikibo [email protected] wrote:

I’m super new to Bokeh and I have started to run into problems when trying to work with my own personal data. I’m using the IPython Notebook to run this project on Windows 8.1. I was able to run the example Timeseries on the IPython notebook with no problems.

#Setup properly
import pandas as pd
from bokeh.charts import TimeSeries, output_file, output_notebook, show

#Get data

xl_file = pd.ExcelFile(test_processed_data)

``

My data is currently saved in my computer as test_processed_data(it’s a .xlsx) in my Documents folder on my windows laptop. I first used the pd.read_csv Remember this is my first time using Bokeh period, so I need all the help/ advice you’re willing to give.

Thanks,

Caroline

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].

To post to this group, send email to [email protected].

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/bacd312e-2f7e-430a-a35b-d4f2928e27ec%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

3

I’m using the read_excel method now, but I’m still having problems. Below, my code and the error statements. Please help me resolve this issue.

In [2]:

import pandas as pd

from bokeh.charts import TimeSeries, output_notebook, show

#Get data

df = pd.read_excel('test_processed_data')


<details class='elided'>
<summary title='Show trimmed content'>&#183;&#183;&#183;</summary>

---------------------------------------------------------------------------
IOError                                   Traceback (most recent call last)
<ipython-input-2-a1330d211f6d> in <module>()
      4
      5 #Get data
----> 6 df = pd.read_excel('test_processed_data')

C:\Anaconda\lib\site-packages\pandas\io\excel.pyc in read_excel(io, sheetname, **kwds)
    149     engine = kwds.pop('engine', None)
    150
--> 151     return ExcelFile(io, engine=engine).parse(sheetname=sheetname, **kwds)
    152
    153

C:\Anaconda\lib\site-packages\pandas\io\excel.pyc in __init__(self, io, **kwds)
    186                 self.book = xlrd.open_workbook(file_contents=data)
    187             else:
--> 188                 self.book = xlrd.open_workbook(io)
    189         elif engine == 'xlrd' and isinstance(io, xlrd.Book):
    190             self.book = io

C:\Anaconda\lib\site-packages\xlrd\__init__.pyc in open_workbook(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)
    392         peek = file_contents[:peeksz]
    393     else:
--> 394         f = open(filename, "rb")
    395         peek = f.read(peeksz)
    396         f.close()

IOError: [Errno 2] No such file or directory: 'test_processed_data'

On Sunday, July 26, 2015 at 5:18:23 AM UTC-5, Sarah Bird wrote:

You need to use the read_excel method from pandas. See the pandas documentation: https://pandas-docs.github.io/pandas-docs-travis/io.html#io-excel

On Sun, Jul 26, 2015 at 7:33 AM, Caroline Dikibo [email protected] wrote:

I’m super new to Bokeh and I have started to run into problems when trying to work with my own personal data. I’m using the IPython Notebook to run this project on Windows 8.1. I was able to run the example Timeseries on the IPython notebook with no problems.

#Setup properly
import pandas as pd
from bokeh.charts import TimeSeries, output_file, output_notebook, show

#Get data

xl_file = pd.ExcelFile(test_processed_data)

``

My data is currently saved in my computer as test_processed_data(it’s a .xlsx) in my Documents folder on my windows laptop. I first used the pd.read_csv Remember this is my first time using Bokeh period, so I need all the help/ advice you’re willing to give.

Thanks,

Caroline

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].

To post to this group, send email to [email protected].

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/bacd312e-2f7e-430a-a35b-d4f2928e27ec%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

4

Hi Caroline,

The problems you are having are not actually with Bokeh, they are with a different library called Pandas. A better place to seek support for Pandas problems would be the Pandas community:

  http://pandas.pydata.org/community.html

That said, the error you are getting is saying that the file you want to open can't be found. Perhaps double check that the filename is correct, and use a full path to the file.

Bryan

···

On Jul 26, 2015, at 9:06 PM, Caroline Dikibo <[email protected]> wrote:

I'm using the read_excel method now, but I'm still having problems. Below, my code and the error statements. Please help me resolve this issue.

In [2]:

import pandas as pd
from bokeh.charts import TimeSeries, output_notebook, show
#Get data
df = pd.read_excel('test_processed_data')
---------------------------------------------------------------------------
IOError
                                   Traceback (most recent call last)

<ipython-input-2-a1330d211f6d> in <module>()
      4
      5 #Get data
----> 6 df = pd.read_excel('test_processed_data')

C:\Anaconda\lib\site-packages\pandas\io\excel.pyc in read_excel(io, sheetname, **kwds)
    149 engine = kwds.pop('engine', None)
    150
--> 151 return ExcelFile(io, engine=engine).parse(sheetname=sheetname, **kwds)
    152
    153

C:\Anaconda\lib\site-packages\pandas\io\excel.pyc in __init__(self, io, **kwds)
    186 self.book = xlrd.open_workbook(file_contents=data)
    187 else:
--> 188 self.book = xlrd.open_workbook(io)
    189 elif engine == 'xlrd' and isinstance(io, xlrd.Book):
    190 self.book = io

C:\Anaconda\lib\site-packages\xlrd\__init__.pyc in open_workbook(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)
    392 peek = file_contents[:peeksz]
    393 else:
--> 394 f = open(filename, "rb")
    395 peek = f.read(peeksz)
    396 f.close()

IOError
: [Errno 2] No such file or directory: 'test_processed_data'

On Sunday, July 26, 2015 at 5:18:23 AM UTC-5, Sarah Bird wrote:
You need to use the read_excel method from pandas. See the pandas documentation: https://pandas-docs.github.io/pandas-docs-travis/io.html#io-excel

On Sun, Jul 26, 2015 at 7:33 AM, Caroline Dikibo <[email protected]> wrote:
I'm super new to Bokeh and I have started to run into problems when trying to work with my own personal data. I'm using the IPython Notebook to run this project on Windows 8.1. I was able to run the example Timeseries on the IPython notebook with no problems.

#Setup properly
import pandas as pd
from bokeh.charts import TimeSeries, output_file, output_notebook, show

#Get data
xl_file = pd.ExcelFile(test_processed_data)

My data is currently saved in my computer as test_processed_data(it's a .xlsx) in my Documents folder on my windows laptop. I first used the pd.read_csv Remember this is my first time using Bokeh period, so I need all the help/ advice you're willing to give.

Thanks,

Caroline

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+un...@continuum.io.
To post to this group, send email to bo...@continuum.io.
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/bacd312e-2f7e-430a-a35b-d4f2928e27ec%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/89066820-85b1-4fbc-b4ac-b2a954c12e68%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.