def test_valuecount():
"""Test the valuecount function."""
table = (('foo', 'bar'), ('a', 1), ('b', 2), ('b', 7))
n, f = valuecount(table, 'foo', 'b')
eq_(2, n)
eq_(2. / 3, f)
def test_valuecount():
"""Test the valuecount function."""
table = (("foo", "bar"), ("a", 1), ("b", 2), ("b", 7))
n, f = valuecount(table, "foo", "b")
eq_(2, n)
eq_(2.0 / 3, f)
def test_valuecount():
"""Test the valuecount function."""
table = (('foo', 'bar'), ('a', 1), ('b', 2), ('b', 7))
n, f = valuecount(table, 'foo', 'b')
eq_(2, n)
eq_(2./3, f)
#########
import petl as etl
table = [['foo', 'bar'], ['a', 1], ['b', 2]]
etl.nrows(table)
# valuecount()
##############
import petl as etl
table = [['foo', 'bar'],
['a', 1],
['b', 2],
['b', 7]]
etl.valuecount(table, 'foo', 'b')
# valuecounter()
################
import petl as etl
table = [['foo', 'bar'],
['a', True],
['b'],
['b', True],
['c', False]]
etl.valuecounter(table, 'foo').most_common()
# valuecounts()
print('TRIMMED HEADERS = ' + str(etl.header(table)))
table = etl.select(table, 'occ_dt', lambda x: x > datetime(2000, 1, 1))
print('ROWS POST YR 2000 = ' + str(etl.nrows(table)))
mine_table = etl.fromcsv('mines.csv', encoding='utf-8')
##handle leading 0's
mine_table = etl.convert(mine_table, 'mine_no', lambda x: str(int(x)))
table = etl.convert(table, 'mine_no', lambda x: str(int(x)))
#MAP mine_no to mine_guid
table = etl.leftjoin(table, mine_table, key='mine_no')
table = clean_up(table, 'mine_no')
#make sure this is 0
if etl.valuecount(table, 'mine_guid', None)[0] > 0:
print('mine_guid, mine_no pair missing from mines.csv')
exit(1)
######
print('CONVERT AND RENAME descript1 to recommendation')
table = etl.addfield(table, 'recommendation', lambda x: x['descript1'])
table = clean_up(table, 'descript1')
######
print('CONVERTING sta_cd to status_code')
table = etl.addfield(table, 'status_code', lambda x: x['sta_cd'])
table = etl.convert(table, 'status_code', 'replace', 'O', 'F')
table = etl.convert(table, 'status_code', 'replace', 'F', 'FIN')
table = etl.convert(table, 'status_code', 'replace', 'P', 'PRE')
print(etl.valuecounter(table, 'sta_cd'))
