Skip to content

"Querying a table" within Sector HDF5 in User Guide #32039

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
xushengun opened this issue Feb 16, 2020 · 5 comments
Closed

"Querying a table" within Sector HDF5 in User Guide #32039

xushengun opened this issue Feb 16, 2020 · 5 comments

Comments

@xushengun
Copy link

Code Sample, a copy-pastable example if possible

string = "HolyMoly'"
store.select('df','index == string')

#### Problem description
string = "HolyMoly'" do not work 

pandas 1.0.1
@MarcoGorelli
Copy link
Member

Thanks @xushengun

The following works for me:

>>> import pandas as pd                                                                                     
>>> store = pd.HDFStore('store.h5')                                                                         
>>> df = pd.DataFrame([1], index=['HolyMoly'])
>>> store.append('df', df)
>>> string = "HolyMoly" 
>>> store.select('df', 'index == string')
          0
HolyMoly  1

Seems that there's a typo in the user guide:

string = "HolyMoly'"

instead of

string = "HolyMoly"

, are you interested in submitting a pull request to fix it?

@danjglick
Copy link

take

@virajmavani
Copy link

take

@PSY27
Copy link
Contributor

PSY27 commented Feb 20, 2020

i am intrested in doing it

@PSY27 PSY27 mentioned this issue Feb 20, 2020
5 tasks
@MarcoGorelli
Copy link
Member

Seems that there's a typo in the user guide:

closing there's no reproducible example, and as it turns out this was intentional

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants