Python get_df Examples

Example #1

File: example_use_data.py Project: Oriundi/rosstat-kep-data

# -*- coding: utf-8 -*-
### Получение данных

from kep import get_ts, get_df, get_varnames, get_all_dfs 

# query by variable name(s) 
z = get_ts('SOC_WAGE_rub','a', 2014)
assert z.loc[2014] == 32495

e = get_df(['SOC_WAGE_rub', 'CPI_rog'], 'm', '2015-06', '2015-06')

# complete database:
annual_varnames = get_varnames("a")
qtr_varnames    = get_varnames("q")
month_varnames  = get_varnames("m")
all_varnames    = get_varnames()

dfa = get_df(annual_varnames, "a")
dfq = get_df(qtr_varnames, "q")
dfm = get_df(month_varnames, "m")

# TODO: maybe:
# import ...
# dfa = get_dfa()
# dfq = get_dfq()
# dfm = get_dfm()

# or simply: 
dfa, dfq, dfm = get_all_dfs()

Example #2

# -*- coding: utf-8 -*-
### Получение данных

from kep import get_ts, get_df, get_varnames, get_all_dfs

# query by variable name(s)
z = get_ts('SOC_WAGE_rub', 'a', 2014)
assert z.loc[2014] == 32495

e = get_df(['SOC_WAGE_rub', 'CPI_rog'], 'm', '2015-06', '2015-06')

# complete database:
annual_varnames = get_varnames("a")
qtr_varnames = get_varnames("q")
month_varnames = get_varnames("m")
all_varnames = get_varnames()

dfa = get_df(annual_varnames, "a")
dfq = get_df(qtr_varnames, "q")
dfm = get_df(month_varnames, "m")

# TODO: maybe:
# import ...
# dfa = get_dfa()
# dfq = get_dfq()
# dfm = get_dfm()

# or simply:
dfa, dfq, dfm = get_all_dfs()

Example #3

File: interface.py Project: epogrebnyak/rosstat-kep-data

#               from https://github.com/epogrebnyak/rosstat-kep-data/
#               You must be in directory from which 'kep' package is importable 

try:
    from kep import KEP, get_ts, get_df 
    dfa, dfq, dfm = KEP().dfs()
       
    # get_ts() - query to obtain timeseries
    ts1 = get_ts('a', 'SOC_WAGE_rub')
    assert ts1.loc[2014] == 32495
    
    ts2 = get_ts('a', 'CPI_rog')
    assert ts2.loc[2014] == 111.4
    
    # get_df() - query to obtain pandas dataframe
    df1 = get_df("m", ['SOC_WAGE_rub', 'CPI_rog'])
    assert df1.loc['2015-10-31','SOC_WAGE_rub'] == 33357.0    # note: data revision, was 33240.0
    assert df1.loc['2015-10-31','CPI_rog'] == 100.7
    print("Import from 'kep' package successful")
    
except AttributeError:
    print ('Check working dir and paths in Spyder or run script in console.')
    
except:
    print ("Cannot import 'kep' package.")
    
# check import results     
try:
   print(dfa.head())
   print(dfq.head())
   print(dfm.head())