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'))