pandas-lookup adds remote lookup tables to a Pandas DataFrame.
Project description
pandas-lookup
A port of agate-lookup that provides the lookup in Pandas DataFrames instead of Agate Tables.
This uses lookup tables from Wireservice's lookup project.
Installation
pip install git+https://github.com/ghing/pandas-lookup.git#egg=pandas-lookup
Look up a column from a lookup table
>>> import pandaslookup
>>> import pandas as pd
>>> df = pd.DataFrame({'state_abbr': ['CT', 'NY', 'NJ']})
>>> print(df)
state_abbr
0 CT
1 NY
2 NJ
>>> import pandaslookup
>>> import pandas as pd
>>> df = pd.DataFrame({'state_abbr': ['CT', 'NY', 'NJ']})
>>> print(df)
state_abbr
0 CT
1 NY
2 NJ
Retrieve a table without joining
>>> import pandaslookup
>>> table = pandaslookup.from_lookup(['usps', 'year'], 'population')
>>> print(table.head())
usps year population
0 AL 1970 3454557
1 AL 1971 3497349
2 AL 1972 3540003
3 AL 1973 3580759
4 AL 1974 3627778
Installing for development
pipenv install --dev -e .
Running tests
pipenv run python -m unittest
Prior art
- harbolkn/pandas-lookup: This is the same idea, but it relies on the
agate-lookup
package, which createds a needless dependency on Agate. Also, I don't think I like monkey-patchingDataFrame
.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pandas-lookup-0.1.2.tar.gz
(4.4 kB
view hashes)
Built Distribution
Close
Hashes for pandas_lookup-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7f72ba2f21e7dbf038ed93402049ad911083c3db82ed9ecbcf6db691889daffe |
|
MD5 | 5bb84cb820420419416462289795cb43 |
|
BLAKE2b-256 | 25c54e8ed78eb496cefa073ef0f45e0ca347379b72b37e668ba02a2d67230be4 |