python-agate-doc 1.6.0-3 / usr / share / doc / python-agate-doc / html / searchindex.js

Search.setIndex({docnames:["about","api","api/aggregations","api/columns_and_rows","api/computations","api/config","api/csv","api/data_types","api/exceptions","api/fixed","api/misc","api/table","api/tableset","api/testcase","api/type_tester","api/warns","changelog","contributing","cookbook","cookbook/charting","cookbook/columns","cookbook/compute","cookbook/create","cookbook/datetime","cookbook/excel","cookbook/filter","cookbook/homogenize","cookbook/locale","cookbook/lookup","cookbook/r","cookbook/rank","cookbook/remove","cookbook/save","cookbook/search","cookbook/sort","cookbook/sql","cookbook/standardize","cookbook/statistics","cookbook/transform","cookbook/underscore","extensions","index","install","license","release_process","tutorial"],envversion:51,filenames:["about.rst","api.rst","api/aggregations.rst","api/columns_and_rows.rst","api/computations.rst","api/config.rst","api/csv.rst","api/data_types.rst","api/exceptions.rst","api/fixed.rst","api/misc.rst","api/table.rst","api/tableset.rst","api/testcase.rst","api/type_tester.rst","api/warns.rst","changelog.rst","contributing.rst","cookbook.rst","cookbook/charting.rst","cookbook/columns.rst","cookbook/compute.rst","cookbook/create.rst","cookbook/datetime.rst","cookbook/excel.rst","cookbook/filter.rst","cookbook/homogenize.rst","cookbook/locale.rst","cookbook/lookup.rst","cookbook/r.rst","cookbook/rank.rst","cookbook/remove.rst","cookbook/save.rst","cookbook/search.rst","cookbook/sort.rst","cookbook/sql.rst","cookbook/standardize.rst","cookbook/statistics.rst","cookbook/transform.rst","cookbook/underscore.rst","extensions.rst","index.rst","install.rst","license.rst","release_process.rst","tutorial.rst"],objects:{"agate.AgateTestCase":{assertColumnNames:[13,1,1,""],assertColumnTypes:[13,1,1,""],assertRowNames:[13,1,1,""],assertRows:[13,1,1,""]},"agate.Aggregation":{get_aggregate_data_type:[2,1,1,""],run:[2,1,1,""],validate:[2,1,1,""]},"agate.All":{run:[2,1,1,""]},"agate.Boolean":{cast:[7,1,1,""]},"agate.Column":{data_type:[3,3,1,""],index:[3,3,1,""],name:[3,3,1,""],values:[3,1,1,""],values_distinct:[3,1,1,""],values_sorted:[3,1,1,""],values_without_nulls:[3,1,1,""],values_without_nulls_sorted:[3,1,1,""]},"agate.Computation":{get_computed_data_type:[4,1,1,""],run:[4,1,1,""],validate:[4,1,1,""]},"agate.DataType":{cast:[7,1,1,""],csvify:[7,1,1,""],jsonify:[7,1,1,""],test:[7,1,1,""]},"agate.Date":{cast:[7,1,1,""]},"agate.DateTime":{cast:[7,1,1,""]},"agate.Deciles":{run:[2,1,1,""]},"agate.MappedSequence":{dict:[3,1,1,""],get:[3,1,1,""],items:[3,1,1,""],keys:[3,1,1,""],values:[3,1,1,""]},"agate.MaxLength":{run:[2,1,1,""]},"agate.Number":{cast:[7,1,1,""]},"agate.Percent":{run:[4,1,1,""]},"agate.PercentChange":{run:[4,1,1,""]},"agate.PercentileRank":{run:[4,1,1,""]},"agate.Percentiles":{run:[2,1,1,""]},"agate.Quantiles":{locate:[10,1,1,""]},"agate.Quartiles":{run:[2,1,1,""]},"agate.Quintiles":{run:[2,1,1,""]},"agate.Rank":{run:[4,1,1,""]},"agate.Slug":{run:[4,1,1,""]},"agate.Table":{aggregate:[11,1,1,""],bar_chart:[11,1,1,""],bins:[11,1,1,""],column_chart:[11,1,1,""],column_names:[11,3,1,""],column_types:[11,3,1,""],columns:[11,3,1,""],compute:[11,1,1,""],denormalize:[11,1,1,""],distinct:[11,1,1,""],exclude:[11,1,1,""],find:[11,1,1,""],from_csv:[11,4,1,""],from_fixed:[11,4,1,""],from_json:[11,4,1,""],from_object:[11,4,1,""],group_by:[11,1,1,""],homogenize:[11,1,1,""],join:[11,1,1,""],limit:[11,1,1,""],line_chart:[11,1,1,""],merge:[11,4,1,""],normalize:[11,1,1,""],order_by:[11,1,1,""],pivot:[11,1,1,""],print_bars:[11,1,1,""],print_csv:[11,1,1,""],print_html:[11,1,1,""],print_json:[11,1,1,""],print_structure:[11,1,1,""],print_table:[11,1,1,""],rename:[11,1,1,""],row_names:[11,3,1,""],rows:[11,3,1,""],scatterplot:[11,1,1,""],select:[11,1,1,""],to_csv:[11,1,1,""],to_json:[11,1,1,""],where:[11,1,1,""]},"agate.TableSet":{aggregate:[12,1,1,""],bar_chart:[12,1,1,""],bins:[12,1,1,""],column_chart:[12,1,1,""],column_names:[12,3,1,""],column_types:[12,3,1,""],compute:[12,1,1,""],count:[12,1,1,""],denormalize:[12,1,1,""],dict:[12,1,1,""],distinct:[12,1,1,""],exclude:[12,1,1,""],find:[12,1,1,""],from_csv:[12,4,1,""],from_json:[12,4,1,""],get:[12,1,1,""],group_by:[12,1,1,""],having:[12,1,1,""],homogenize:[12,1,1,""],index:[12,1,1,""],items:[12,1,1,""],join:[12,1,1,""],key_name:[12,3,1,""],key_type:[12,3,1,""],keys:[12,1,1,""],limit:[12,1,1,""],line_chart:[12,1,1,""],merge:[12,1,1,""],normalize:[12,1,1,""],order_by:[12,1,1,""],pivot:[12,1,1,""],print_structure:[12,1,1,""],scatterplot:[12,1,1,""],select:[12,1,1,""],to_csv:[12,1,1,""],to_json:[12,1,1,""],values:[12,1,1,""],where:[12,1,1,""]},"agate.Text":{cast:[7,1,1,""]},"agate.TimeDelta":{cast:[7,1,1,""]},"agate.TypeTester":{run:[14,1,1,""]},"agate.config":{get_option:[5,6,1,""],set_option:[5,6,1,""],set_options:[5,6,1,""]},"agate.csv_py2":{DictReader:[6,0,1,""],DictWriter:[6,0,1,""],Reader:[6,0,1,""],Writer:[6,0,1,""],reader:[6,6,1,""],writer:[6,6,1,""]},"agate.csv_py3":{DictReader:[6,0,1,""],DictWriter:[6,0,1,""],Reader:[6,0,1,""],Writer:[6,0,1,""],reader:[6,6,1,""],writer:[6,6,1,""]},"agate.fixed":{DictReader:[9,0,1,""],Reader:[9,0,1,""],reader:[9,6,1,""]},"agate.fixed.Reader":{fieldnames:[9,3,1,""]},agate:{AgateTestCase:[13,0,1,""],Aggregation:[2,0,1,""],All:[2,0,1,""],Any:[2,0,1,""],Boolean:[7,0,1,""],CastError:[8,2,1,""],Change:[4,0,1,""],Column:[3,0,1,""],Computation:[4,0,1,""],Count:[2,0,1,""],DataType:[7,0,1,""],DataTypeError:[8,2,1,""],Date:[7,0,1,""],DateTime:[7,0,1,""],Deciles:[2,0,1,""],DuplicateColumnWarning:[15,0,1,""],FieldSizeLimitError:[8,2,1,""],Formula:[4,0,1,""],HasNulls:[2,0,1,""],IQR:[2,0,1,""],MAD:[2,0,1,""],MappedSequence:[3,0,1,""],Max:[2,0,1,""],MaxLength:[2,0,1,""],MaxPrecision:[2,0,1,""],Mean:[2,0,1,""],Median:[2,0,1,""],Min:[2,0,1,""],Mode:[2,0,1,""],NullCalculationWarning:[15,0,1,""],NullOrder:[10,0,1,""],Number:[7,0,1,""],Percent:[4,0,1,""],PercentChange:[4,0,1,""],PercentileRank:[4,0,1,""],Percentiles:[2,0,1,""],PopulationStDev:[2,0,1,""],PopulationVariance:[2,0,1,""],Quantiles:[10,0,1,""],Quartiles:[2,0,1,""],Quintiles:[2,0,1,""],Rank:[4,0,1,""],Row:[3,0,1,""],Slug:[4,0,1,""],StDev:[2,0,1,""],Sum:[2,0,1,""],Summary:[2,0,1,""],Table:[11,0,1,""],TableSet:[12,0,1,""],Text:[7,0,1,""],TimeDelta:[7,0,1,""],TypeTester:[14,0,1,""],UnsupportedAggregationError:[8,2,1,""],Variance:[2,0,1,""],aggregations:[2,5,0,"-"],computations:[4,5,0,"-"],config:[5,5,0,"-"],data_types:[7,5,0,"-"],table:[11,5,0,"-"],tableset:[12,5,0,"-"],type_tester:[14,5,0,"-"],warn_duplicate_column:[15,6,1,""],warn_null_calculation:[15,6,1,""]}},objnames:{"0":["py","class","Python class"],"1":["py","method","Python method"],"2":["py","exception","Python exception"],"3":["py","attribute","Python attribute"],"4":["py","classmethod","Python class method"],"5":["py","module","Python module"],"6":["py","function","Python function"]},objtypes:{"0":"py:class","1":"py:method","2":"py:exception","3":"py:attribute","4":"py:classmethod","5":"py:module","6":"py:function"},terms:{"05_leslie3d_bas":16,"10th":2,"15th":23,"1st_column_nam":20,"2000_chang":21,"2001_chang":21,"2002_chang":21,"20th":2,"25th":2,"2nd_column_nam":20,"3rd_column_nam":20,"40th":2,"50th":2,"60th":2,"75th":2,"80th":2,"90th":2,"\u0192":7,"boolean":[7,14,16],"break":16,"byte":11,"case":[11,13,16,18,22,23,38],"class":[0,2,3,4,6,7,9,10,11,12,13,14,15,16,17,21,24,28,30,40],"default":[3,4,5,7,8,11,12,14,16,21,22,23,26,38,44],"final":[11,21,28],"float":[16,21],"function":[2,4,11,12,16,21,24,26,29,34,37,39,40,41],"import":[6,7,11,16,19,21,22,23,25,28,32,33,34,37,40,41],"int":[2,4,12,16],"long":[16,17],"new":[0,2,4,5,12,15,16,17,18,20,26,28,31,35,40,41,44,45],"null":[2,3,4,7,10,11,15,16,21],"public":[16,19,44],"return":[2,3,4,7,9,11,12,14,16,21,24,25,26,28,33,34,35,37,38,39],"short":0,"throw":16,"true":[2,4,6,7,11,12,16,22,30,32,34,35,36,37,41],"try":[17,23],AND:43,Added:16,And:[11,28],BUT:43,Being:35,FOR:43,For:[2,4,8,11,14,22,23,25,27,33,35,37,38,40],NOT:43,Not:[11,17],One:24,THE:43,That:17,The:[2,3,4,5,6,7,9,11,12,14,16,17,21,23,24,26,28,30,34,35,36,37,38,39,40,41,43,45],There:[4,9,11,16,23,24,30],These:[6,9,12,16,33,40],USE:43,Use:[11,16,22,32,35,38],Used:[11,12],Uses:4,Using:[21,36],WITH:43,With:25,__init__:[11,12,16,21],__repr__:16,__setitem__:16,__str__:16,_cast:16,_column_nam:21,_compare_str:21,_create_column:16,_fork:16,_interv:21,_io:[11,12],_is_fork:[11,12],_prepar:16,abc:[3,10],abil:[16,40],about:[11,13,16,17,35,41],abov:[6,11,23,37,43],absolut:[2,37],accept:[16,17],access:[3,11,12,16],accessor:16,accident:11,accomplish:[24,37,41],accordingli:16,account:[15,16],accur:16,acknowledg:17,across:12,act:40,action:43,activ:[17,40],actual:[16,21,35,38],add:[0,6,11,12,16,17,24,26,28,35,37,40,44],added:[15,16,44],adding:40,addit:[11,12,16,17,37,38,40],affect:[11,27],affili:17,after:[4,14,16,22,40],after_column_nam:4,against:[2,14,16],agat:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22,23,24,25,27,28,29,30,32,35,36,37,38,39,40,42,44,45],agatedbf:22,agateexcel:22,agatelookup:28,agateremot:22,agatesql:[22,32,40],agatestat:37,agatetestcas:[13,16],age:[11,19,29,35,37,38],age_at_death:21,age_mean:[35,37],age_median:[35,37],ages:[17,38],aggeg:16,aggreg:[1,8,11,12,16,19,24,25,38,39,41],agre:[17,30],alabama:[19,24],alaska:[19,24],algorithm:21,align:[16,17],all:[0,2,11,12,16,17,23,24,25,26,27,33,35,37,38,43,44],allow:[0,16,27,38],allow_tableset_proxi:16,almost:[9,12],alon:[7,16],along:41,alreadi:[11,17,21],also:[4,11,12,14,16,17,21,22,24,25,26,36,37,38,39,40,42],alter:0,altern:[11,41],alwai:[0,2,4,11,14,19,23,33,35],american_indian:21,amount:22,analysi:[16,38,41],ani:[2,3,4,11,12,14,16,17,21,25,27,33,34,37,43,44],annual:[16,28],anoth:[21,23,24,30,37],answer:2,anyon:16,anyth:[17,22],anywher:11,api:[0,16,41],appear:16,append:[4,11,21,36],appli:[2,4,7,8,11,12,14,16,21,23,24,30,37,38],approxim:11,arbitrari:[2,4,24],arcgi:22,archiv:22,area:[21,22],aren:17,arg:[6,9,12,16],argument:[2,4,11,14,16,21,22,23,30,36,38],aris:[14,43],arizona:[19,24],arkansa:19,around:[6,7,9,16],arrai:[11,14,16,20],ascend:4,ascii:16,asian:[11,21,38],assert:13,assertcolumnnam:[13,16],assertcolumntyp:13,assertrow:13,assertrownam:[13,16],assertsequenceequ:16,asset:24,assign:11,associ:43,assum:[11,21],astimezon:23,ated:16,atom:0,attempt:[7,8,23],attribut:16,author:[16,17,43],auto:16,automat:[6,11,16,22,23],avail:[5,16,35,41,45],averag:[2,16,35],average_star:35,awar:[6,35],awesom:16,axi:[5,11,12],babel:16,balanc:30,bar:[5,11,12],bar_char:5,bar_chart:[11,12,19],base:[2,3,4,6,7,8,9,10,11,12,13,14,15],basic:[4,30],batting_averag:24,bdist_wheel:44,bear:0,becaus:[16,21,34],becom:[0,4,11],bedi:[16,41],been:[11,16,44],befor:[2,4,11,12,14,17],before_column_nam:4,behav:16,behavior:[14,16],behind:16,being:[3,11,16],below:[6,35],ben:[16,41],benchmark:16,best:16,better:[16,21],between:[3,4,6,7,11,23,25,27,30,35],bewar:14,beyond:[21,37],big:0,bin:[11,12,16,19],binari:11,birth_dat:34,bit:30,black:[11,21,38],blank:16,block:16,bool:[2,7,16],boolean_typ:24,booleancolumn:16,booleantyp:16,boost:[16,42],born:21,both:[2,3,6,11,16,19,22,36,37,42],branch:17,brien:[16,41],bring:16,broken:17,brown:41,brutish:0,buffer:16,bug:[16,17],build:[17,21,41,44],built:[9,19],builtin:[6,11,19,21,22,25],by_counti:41,by_crim:19,by_year:19,by_year_exoner:19,cach:16,calcul:[2,4,8,15,16,18,21,33,37,38],california:[19,35],call:[2,4,11,12,16,28,40],can:[2,3,4,6,7,8,9,11,12,14,15,16,17,19,20,21,22,23,24,25,26,28,29,30,34,35,36,37,38,39,40,42],cannot:23,care:[14,17],carri:11,cast:[2,4,7,8,14,16],cast_nul:[7,14,16],casterror:[8,16],catherin:33,caus:[14,16],cdecim:[16,42],cdf:2,cell:[11,24,38],celliter:16,censu:22,central:11,certain:[2,4,11,12],chain:[12,25,37],chang:[4,11,14,16,17,27,41],changelog:[41,44],charact:[2,5,11,16],charg:43,chart:[5,16,18,44],check:[2,4,11,16,17,21],checkout:44,choos:17,chri:41,christoph:[41,43],circumst:23,cite:21,citi:[22,27],citizen:0,claim:[16,43],classifi:16,classmethod:[11,12,40],clean:16,clearer:35,clone:42,cls:40,cmp:16,coalesc:12,code:[6,11,16,21,35,40],codebas:[16,17],coerc:[7,11,16],coffei:41,collaps:16,collect:[3,9,10,12],colorado:19,columbia:19,column:[1,2,4,7,8,9,10,11,12,13,14,15,16,18,21,23,24,25,26,27,28,29,30,35,37,39],column_chart:[11,12,19],column_info:16,column_nam:[2,4,11,12,14,15,16,20,21,22,23,27,40],column_name_on:[22,31],column_name_two:[22,31],column_renam:15,column_typ:[11,12,14,16,22,23,27,40],columndoesnotexisterror:16,columniter:16,columnoper:16,columnsequ:16,columntyp:16,com:[2,11,22,41,42],combin:[11,19,25,30,37],come:16,comma:27,command:17,comment:[17,41],commit:[17,44],common:[11,12,16,18,21,24,28,37,38,41],commun:41,compar:[2,4,11,16,21],compare_str:21,compare_valu:11,comparison:[4,21,35,41],compat:[11,16],competit:[4,16],compil:0,complet:[0,16,17],complex:[0,19],comput:[0,1,2,11,12,16,18,23,24,25,28,30,33,36,37,38],concept:11,condit:[16,43],conf:44,config:1,configu:5,configur:[5,16],confus:0,connect:43,connecticut:19,consid:[0,7,16,37,38],consist:[11,16,17],construct:[3,11,16,38],constructor:[11,14,16,23,27],contain:[2,3,4,5,6,9,11,12,14,15,16,21,23,24,37],content:[3,12],contract:43,contribut:[16,41],contributor:[17,43],control:[7,14],convers:16,convert:[4,7,11,12,16,24,36],cookbook:[16,17,41],copi:[0,11,41,43],copyright:43,core:[0,37,40],correct:[2,4,8,11],correctli:[16,21,27],correl:[16,19],correspond:12,cost:[28,34],cost_2015:28,could:[7,16,23],count:[2,11,12,16,19,24,35,38],count_millionair:37,counti:41,countri:27,county_cost:41,cours:21,cover:[18,41],coverag:[0,16,42,44],cpi:16,cpi_2015:28,cpi_adjust_2015:28,creat:[0,2,3,4,7,14,16,18,23,24,31,35,37,40,44],create_column:16,creation:7,creed:17,crime:19,crosstab:[11,16,24],csv:[1,7,8,9,11,12,16,23,27,41],csv_py2:6,csv_py3:6,csvifi:[7,16],csvkit:16,currenc:[7,16,27],currency_symbol:[7,16],current:3,custom:[2,4,16,21],dai:17,damag:43,dangl:11,data:[0,1,2,3,4,10,12,13,14,16,18,19,21,23,27,28,29,30,35,37,38,41],data_typ:[2,3,4,7,16,21],databas:[35,40],dataset:[0,11,16,18,22,25,38],datatyp:[2,3,4,7,8,11,12,14,16],datatypeerror:[8,16,21],date:[2,4,7,14,16,18,27,44],date_format:[7,16],date_typ:23,datecolumn:16,datetim:[2,4,7,14,16,23,25],datetime_format:7,datetime_typ:23,datetimecolumn:16,datetimetyp:16,datetyp:16,dateutil:16,dbf:[16,40],de_d:[7,27],deal:[16,43],decad:21,decil:[2,16],decim:[0,2,4,7,11,16,25,28],decimal_symbol:[7,16],decimalcolumn:16,decor:16,deem:41,deepcopi:16,def:[21,24,26,28,33,40],default_local:5,default_null_valu:[7,16],default_row:[11,26],default_valu:11,defer:[3,16],defin:[7,37],definit:[12,16],deflat:16,delawar:19,delimit:11,delta:4,denomin:21,denorm:[11,12,16,18,24,29],depend:[0,16,40,42],deprec:16,deriv:[11,16],desc:35,descend:11,describ:[11,12,16],descript:[5,24],deser:11,design:[0,9,40],destruct:16,detail:[27,30,41],detect:16,determin:[11,37],develop:[17,41,44],deviat:[2,3,37],dialect:[6,11,35],dict:[3,12,16,22],dictionari:[5,11,12,14,20,22,24],dictread:[6,9],dictwrit:6,died:21,differ:[4,6,11,14,16,24,35],differenti:16,dimens:12,dimension:16,dir_path:12,directli:3,directori:[12,16,17],disabl:[2,4,7,11,14,16],discret:16,displai:[11,12,16,27],dispos:24,dist:19,distinct:[3,11,12,16,27],distribut:[16,38,43],divers:16,diversity_index:21,divid:[2,4,11,21,24],dmetaphon:33,doc:[16,17,19,44],docstr:17,doctor:[35,37],doctors_by_st:[35,37],document:[0,6,16,27,30,41,43,44],doe:[0,2,11,12,16,21,22,27,35],doesn:11,domain:11,don:[0,17,22,25],done:[16,17],dots_chart:19,downstream:16,dozen:41,drop:[6,11,16],due:[6,42],dummi:10,dupic:11,duplic:[4,11,16,17,36],duplicatecolumnwarn:15,dure:[7,16,25],dutch:27,dutch_citi:27,dutch_numb:27,dynam:40,each:[2,4,7,11,12,14,16,21,24,26,28,30,35,37,38,41],earli:16,easi:[0,33],easier:38,eastern:23,edg:16,effect:25,effici:[19,22],effort:17,either:[2,3,11,12,16,17,38],element:[11,12,16],eli:[16,41],elimin:16,ellipsi:[5,11],ellipsis_char:5,els:21,employe:[24,29],employee_count:24,empti:16,emul:16,en_u:[5,7],enabl:[11,16],encod:[6,11,12,16,22],encount:[7,16],encourag:17,end:[11,12,16,19],enforc:11,enjoi:17,enough:[4,11,24],ensur:[2,4,21,44],ensure_uniqu:[4,36],enter:21,entir:[11,12,14,24,25,30],entri:16,enumer:21,environ:44,equal:[2,11,12,27],equival:[2,3,12,16,24,28,29,35],eric:[16,41],error:[2,4,14,16,22],especi:37,etc:[10,11,14,16,27,41],ethnic:17,europ:23,evalu:[14,21],even:[11,16],evenli:11,event:[23,25,43],everi:[11,16,25,41],everybodi:0,everyon:17,everyth:10,everywher:[0,16,17],evid:16,exactli:[9,12,21,39],exampl:[2,4,8,11,16,19,21,22,23,24,25,27,33,35,37,38,40,41,44],exce:8,excel:[0,6,16,18,40],except:[1,3,11,12,16,37],exclud:[11,12,14,16,29,37],exclude_column:31,execut:[2,12],exhaust:0,exist:[11,12,16,17,21,28,33,36],exoner:19,expect:[11,13,17,25],expected_valu:26,expertis:41,explan:[2,17],explicit:[16,35],explicitli:[7,16,35],explor:19,express:[16,25,43],extend:41,extens:[0,16,22,28,32,37,41],extent:17,extra:[16,23],extran:23,facilit:[16,27],factor:[12,16],fail:[16,22],fall:4,fals:[2,4,6,7,11,12,16,22,37],false_valu:7,famili:33,fanci:16,fashion:3,fast:[16,19],faster:[16,42],featur:[0,3,6,11,12,16,17,23,41],feedback:17,femal:[11,38],female_count:26,few:[16,17,24,40],fewer:11,ffs:[9,11],field:[8,11],field_column:11,field_size_limit:[6,16],fieldnam:[6,9],fieldsizelimiterror:8,fifth:2,figur:23,file:[8,9,11,12,16,17,27,40,43],filenam:[16,22,32],filepath:[11,12],fill:[0,11,16,18,26],filter:[16,18,35],find:[2,11,12,16,17,21,22,25,30,33,37,44,45],fine:17,finish:17,finnei:41,first:[0,11,12,16,17,21,23,25,35,37],first_nam:[24,29,33,34],first_year:29,fit:43,five_year_tot:24,fix:[1,11,16,17,21],flag:44,flexibl:[4,16,24,30],float_precis:16,floatcolumn:16,florida:19,fnmatch:25,follow:[0,11,16,17,21,23,38,41,42,43],forc:[14,16,22,23],ford:41,foreign:[18,27],fork:[16,17],form:11,format:[5,7,9,11,12,14,16,17,22,27,37,38,40,45],formula:[4,16,21,23,28],found:[11,12],four:[4,24,35,37],fourth:2,fraction:27,free:[0,43],frequenc:16,frequent:24,fresh:44,friendli:[0,11,16],from:[3,4,7,9,11,12,14,16,17,21,23,24,25,26,27,30,33,34,35,37,40,42,43],from_csv:[11,12,16,22,23,27,41],from_dbf:22,from_fix:[11,16],from_json:[11,12,16,22],from_object:[11,16,22],from_sql:[22,40],from_url:22,from_xl:22,from_xlsx:22,full:[11,12,16,26,37],full_nam:24,full_out:[11,16,35],func:[2,4,16],furnish:43,further:14,fuss:17,futur:3,fuzzi:16,fuzzy_famili:33,gap:16,gender:[11,17,38],gener:[3,11,16,17,19,21,22,24,26,28,30,37,38],geoffrei:[16,41],get:[0,2,3,5,12,16,22,24,25,28,33,37],get_aggregate_data_typ:2,get_column_nam:16,get_column_typ:16,get_computed_data_typ:[4,21],get_data:16,get_data_sort:16,get_data_without_nul:16,get_opt:5,get_tabl:22,gfm:[11,16],git:[17,42,44],github:[11,16,17,18,22,41,42,45],githubusercont:22,give:22,given:[2,4,7,10,11,12,13,14,21,26,38],glob:16,global:5,going:[17,40],good:[17,35],gplv3:16,grant:43,great:[17,42],greater:10,grid:12,groskoff:33,groskopf:[33,41,43],grosskopf:33,group:[2,7,11,12,16,22,24,38],group_bi:[11,12,16,19,24,29,35,37,41],group_nam:[12,16],group_symbol:[7,16],group_typ:[12,16],groupdict:16,guess:[7,14,16,22,23],guid:41,guidanc:41,hack:[17,42],hacker:17,hand:[11,24],handl:[11,16,18,27],happi:17,hard:[23,27],has:[11,12,16,17,19,21,36,38,44],hash:[5,11],hasnul:2,hate:25,have:[0,11,12,16,17,18,19,22,23,24,28,37,38,41,44],haven:17,header:[6,11,12,16,22],heart:17,heasli:[16,41],height:[11,12],help:38,helper:1,here:[17,19,24,25,35,37,40],herebi:43,hing:[16,41],his:16,hispan:21,hispanic_squar:21,histori:17,hold:22,holder:43,homerun:19,homogen:[11,12,16],horizont:[5,11],horizontal_line_char:5,hospit:37,host:40,hour:23,how:[7,11,14,16,17,18,19,23,24,27,35,41],howev:[16,21,40],html:11,http:[2,11,22,41],human:[0,41],hundredth:2,hydrogen:0,i_chang:21,idea:[17,35],ident:[12,16],identif:4,identifi:[10,11,36],ids:16,ignor:[11,16,23],imag:19,imagin:23,immut:3,implement:[2,3,4,6,11,12,16,17,21,24,30,33,34,35],impli:43,implment:16,improv:[16,45],includ:[2,11,12,16,17,33,35,37,41,43],include_column:31,incom:25,incorrect:14,incorrectli:[16,22],increas:16,indent:[11,12,16],index:[2,3,11,12,16,28,41],indexerror:16,indici:16,individu:[12,14,33,41],infer:[1,7,11,16],inform:[16,23],inherit:4,init:16,initi:16,inlin:[11,12],inner:[11,16],inner_join:16,input:[11,16,21,37],input_t:[22,40],insert:26,instal:41,instanc:[2,3,4,11,12,14,16,21,23,26,37],instanti:4,instantli:40,instead:[3,7,11,12,16,21,24,35,37,41],intcolumn:16,integ:[12,16,21],integr:[0,16,37],intend:[0,6,19],inter:16,interfac:[16,40,44],intern:[11,12,16,34],interquartil:2,intersect:[24,38],interv:[7,21],intial:16,introduc:[16,25],introductori:16,intuit:[2,30],invalid:[8,22],invalidoper:16,invers:12,invis:16,invok:[4,16],ipynb:44,ipython:[0,11,12,42],iqr:[2,16],isinst:21,isn:[4,18,24],iso8601:16,isod:16,issu:[16,17,18,41],item:[3,12],iter:[3,11,16],its:[2,11,12,16,28,38,41,42],jack:[11,38],jane:[11,38],jeff:[16,41],jill:38,jim:[11,38],joan:38,job:[24,29],job_titl:24,jobs_by_state_and_year:24,joe:[11,38],john:[16,41],johnson:41,join:[11,12,16,24,29,40],join_year_cpi:28,josh:11,journal:41,journalist:17,json:[7,11,12,16],jsonifi:[7,16],julia:38,jump:11,jupyt:[0,11,16,41,42,45],just:[7,16,21,22],keep:17,kei:[3,5,11,12,14,16,26,34,37],keller:41,kevin:[16,41],key_nam:[11,12,16],key_typ:[11,12,16],keyerror:16,keyword:[12,16,21,24,34,35],kill:16,kind:[19,43],kiowa:41,know:[17,22],known:[21,22,40,41],ks_1033_data:41,kwarg:[4,6,7,9,11,12],kwd:6,label:[11,12],label_column_nam:11,lambda:[19,23,24,25,29,33,34,35,37,39],languag:24,larg:[11,17,22,38],larger:17,larson:[16,41],last:[4,11,14],last_nam:[24,29,33,34],latest:44,latino:38,latter:16,lattic:[12,16],lc_numer:5,lead:[0,16,35],lean:21,least:35,leather:[11,12,16,19],left:[11,16],left_kei:[11,16],left_outer_join:16,len:16,length:[2,8,9,11,12,16],less:0,lesser:11,let:[17,22],letter:[16,22],letter_nam:11,level:[11,12,17],levenshtein:33,levenshteindist:21,leverag:33,liabil:43,liabl:43,librari:[16,21,33,37,40,41],licens:[0,16,41],like:[0,6,9,11,12,14,16,17,21,25,26,28,35,39],limit:[8,11,12,14,16,19,25,41,43],linderborg:41,line:[5,11,12,16],line_chart:[11,12,19],line_numb:[6,16],link:41,linux:42,list:[3,14,16,17,22,25,29,35,41,44],live:[0,17],load:[3,11,12,16,22,23],local:[5,7,11,14,16,18],locat:[10,11,12,16,30],logic:[13,15],longer:16,longest:2,look:[24,25,28],lookup:[16,18,24,40],loop:21,lost:[12,16],love:[0,17],lower:35,lowercas:16,machin:41,mad:[2,16,37],mad_outli:[16,37],made:[0,12,16,41],mai:[2,3,8,11,12,14,17,22,23,24,30],mail:33,maintain:[3,9,11,17,40,41],major:[12,16,44],make:[0,17,19,21,23,27,40,44],male:[11,38],male_count:26,mani:[11,14,16,17,30,35],manner:30,manual:[16,21],map:[11,16,18,20,28],mapped_sequ:[3,12],mappedseqeu:11,mappedsequ:[3,11,12,16],march:23,markdown:[11,16],massiv:16,master:[17,22,44],match:[11,13,16,24,25],mathemat:11,matplotlib:16,matt:[16,41],max:[2,37],max_column:11,max_column_width:[11,16],max_length:16,max_precis:[11,16],max_row:[11,12],maxfields:16,maximum:[2,8,11,12],maxlength:[2,16],maxprecis:[2,16],mean:[2,12,14,16,17,24,27,29,35,37],measur:21,median:[2,24,35,37],meet:4,memoiz:16,memori:16,merchant:43,merg:[11,12,16,17,43,44],messag:16,metadata:11,method:[2,4,6,11,14,16,17,20,21,22,23,24,25,28,30,36,37,38,40,44],methodnam:13,mick:[16,41],middl:4,middle_nam:24,might:[19,37],migrat:16,min:[2,37],mind:[0,17],minim:[17,42],minimum:[2,11],minor:[6,16],minu:11,minut:23,mirror:16,miscalcu:2,miscellan:1,misnom:30,miss:[11,16,18],missing_valu:26,mit:[0,16,17,41,43],mix:11,mkvirtualenv:42,mode:[2,11,12,16,37],model:30,modifi:[5,11,12,16,43],modul:[5,16,25,27,41,44],modular:16,monkei:[16,40],monkeypatch:16,montgomeri:41,month:25,more:[0,4,11,12,16,17,19,22,23,35,37,38,40,42],most:[0,2,11,12,14,16,24,35],move:16,much:[16,17,38],multi:[16,34],multipl:[4,12,15,16,37],murphi:41,murrai:[16,41],must:[0,4,9,11,12,16,21,23,27,42],mutabl:0,mvp_candid:24,mvp_tabl:24,myextens:40,naiv:23,name:[2,3,4,5,9,11,12,13,14,15,16,18,19,20,21,22,24,29,33,35,37,38],name_strip:24,namespac:16,nasti:0,nation:17,nativ:[7,16,21,34],navig:16,necessari:[2,4,16,25],necessarili:16,need:[0,3,4,16,17,19,21,23,24,30,42,44],neg:16,negat:39,neil:[16,41],neither:16,nest:[11,12,16],new_class_method:40,new_column:[21,24],new_column_nam:12,new_method:40,new_tabl:[20,21,24,25,26,29,30,31,34,35,36,39],new_table2:30,newdata:29,newlin:11,nich:0,nikhil:41,no_null_comput:16,nobodi:17,non:[2,11,16,17,27],none:[2,3,4,6,7,10,11,12,14,16,21,22],nonetyp:16,noninfring:43,nonnullaggreg:16,nor:[16,23],normal:[9,11,12,16,18,22,23,24,29],nosetest:[17,42,44],not_outli:37,note:[2,7,11,14,16,22,23,30,38],notebook:[16,41,45],notic:[16,43],now:[16,21,28,33,34,40,45],nth:25,nuanc:6,null_valu:7,nullcalculationerror:16,nullcalculationwarn:15,nullord:10,number:[2,4,5,7,10,11,12,14,16,21,22,24,25,28,37,38],number_typ:[21,22,24],numbercolumn:16,numbertyp:16,numer:[3,7,11,16,21],numpi:[0,41],obj:11,object:[2,4,6,7,9,10,11,12,14,16,24,36],obtain:43,obviou:16,occur:[2,38],occurr:[2,12],off:16,offer:19,often:40,old:[20,44],olson:[16,41],onc:[11,17,37],one:[2,4,6,8,11,12,16,20,21,23,28,30,37],ones:20,onli:[2,4,6,11,12,16,21,31,35,37],onto:40,onyxfish:[22,42],open:[11,16,17,41],oper:[0,12,15,16,24,38],opportun:22,opposit:[11,16],ops:16,optim:[0,16,41],option:[3,4,5,7,11,14,16,36,38],order:[3,4,11,12,14,16,20,22],order_bi:[11,12,16,19,25,29,34,35,41],ordereddict:[3,9,11,12],org:41,organ:[11,16,17],origin:12,osx:42,other:[6,7,10,11,12,14,16,17,21,24,27,30,38,40,43],otherwis:[11,12,43],ourselv:21,out:[11,17,21,23,43],outer:[11,16],outlier:16,output:[4,11,12,16,37],output_t:[32,40],outsid:16,over:[3,11,21],overrid:[7,14,16,21],overridden:16,overwritten:16,own:[6,11,16,24,37,38,41],pacific_island:21,packag:[16,44],page:41,pair:[11,12,16],panda:[0,18,41],paramet:[2,3,4,5,7,11,12,14,16,17,25,27],parlanc:23,pars:[7,11,16,23,27],part:[10,12,17,27,40],partial:16,particular:[0,16,43],pass:[2,11,12,14,16,22,24,27,35,39,44],patch:[16,17,22,28,37,40],patchabl:16,path:[11,12,22],patient:[35,37],patient_ag:[35,37],patient_count:[35,37],pattern:[16,23,40],pearson:16,pearson_correl:16,peform:11,peopl:17,per:12,percent:[4,16],percent_chang:16,percentag:[4,21,37,38],percentchang:[4,16,21],percentil:[2,4,8,10,16,25],percentile_rank:30,percentilerank:[4,16,30],perfectli:[11,42],perform:[2,4,11,12,15,16,35,37,42],period:[17,27],permiss:[17,43],permit:43,person:43,persuas:17,phone:25,phonet:16,phonetic_famili:33,phonetic_match:33,phonetic_search:33,pickl:16,pip:42,pivot:[11,12,16,18,19,37],place:[2,10,16],plain:11,plan:17,platform:16,pleas:[0,16,17,18],plot:[11,12,16,19],pluggabl:0,plugin:40,point:[16,17],popul:[2,16,21,22,27],popular:35,popular_doctor:35,populationstdev:2,populationvari:2,portion:43,possibl:[7,11,14,16,23,33,40],postgresql:[22,32,35,40],power:24,practic:17,precis:[0,11,16,21,30,38],prefer:16,present:[2,12],pretti:16,pretty_print:16,prevent:[11,16],previou:[22,37,38],previous:[16,41],price:21,price_round:21,primari:35,primarili:42,primarli:16,principl:[17,41],print:[11,12,16,27,40],print_bar:[11,16,19,41],print_csv:[11,16],print_html:[11,16],print_json:11,print_structur:[11,12,16],print_tabl:[11,16,21],printabl:[5,11,16],printable_bar_char:5,printable_zero_line_char:5,prior:[21,38],prioriti:17,privat:16,problem:41,process:[0,2,14,23,38,41],produc:[2,4,19],program:0,project:17,proof:16,propag:[11,12],properli:27,properti:[16,38],property_column:11,prototyp:16,prove:14,provid:[2,4,6,7,11,12,14,16,17,43],proxi:[3,16,44],publicschool:22,publish:[41,43],pull:17,purchas:41,pure:0,purpos:[0,7,16,43],push:44,put:11,py2:42,py3:42,pycalcstat:2,pygal:16,pylab:19,pypi:[42,44],python:[0,2,7,9,11,16,17,21,23,24,25,27,33,34,41,42,44],pytimepars:16,pytz:[7,23],quantil:[2,10,16],quantiz:[21,28],quartil:[2,10,16],queri:25,quickli:13,quintil:[2,16],race:[11,17,21,38],race_squar:21,racial:21,rais:[2,11,12,15,16,21],random:16,rang:[2,16,21,24],rank2014:30,rank2015:30,rank:[4,16,18],rank_chang:30,raphael:41,rather:[9,11,16,19,21],raw:[11,22],rdataset:22,reach:16,read:[9,11,16,17,35,40],readabl:[0,41],reader:[1,11,16],readi:19,real:[40,41],realdata:41,realist:17,realli:[7,17,30],reason:17,receiv:[16,17],recent:44,recip:17,recommend:42,record:41,recreat:29,reduc:16,refer:[2,11,16,22,37],refus:17,regardless:11,regex:[7,16],regular:25,reimplement:16,reject:[16,37],rejoic:17,relat:[11,12,16],releas:[16,17,41],relev:[16,17],reli:40,remain:11,remaind:11,remot:[16,40],remov:[3,16,18],renam:[11,16,18,22,36],render:[5,11,12,16],reorder:18,reorgan:16,reorgniz:16,repeat:16,replac:[6,11,16,44],replic:12,report:16,repositori:[9,11,18,41],repr:16,repres:[7,10],request:17,requir:[11,16,21,35,42],require_match:[11,16],reshap:16,resolv:17,respect:11,rest:22,restkei:6,restrict:[16,43],restructur:[16,17],restval:6,result:[2,11,12,16,21,24,25,26,33,35,37,38],retain:7,retriev:[3,11,12,25],rev:44,revers:[4,11,16,30,35,41],review:[17,35],revis:[16,17,44],revisit:17,rewritten:17,riggott:[16,41],right:[0,11,16,43],right_kei:[11,16],right_tabl:11,robin:41,robust:[16,37],roll:37,rome:23,round:16,round_pric:21,routin:16,row:[1,2,4,11,12,13,14,16,18,20,21,22,24,28,29,33,34,35,38,39,40],row_nam:[3,11,12,16],rowdoesnotexisterror:16,rowiter:16,rowsequ:16,rst:44,rtfd:[41,44],run:[2,4,11,12,14,16,17,21,42,44],rune:17,runtest:13,runtimewarn:15,ryan:41,safe:16,sagara:[16,41],sai:11,salari:[24,25,29,37,39],salary_mean:24,salary_median:24,salin:41,same:[9,11,12,14,15,21,22,27,35,37,40],sampl:[2,16,41],sandwich:22,save:[18,21],scatterplot:[11,12,19],schaul:[16,41],schema:[9,11],schema_encod:11,schema_f:9,schema_path:11,scipi:37,scope:[17,37],scratch:21,script:[16,44],sdist:44,seamlessli:27,search:[2,16,18,41],second:[11,12,23,37],second_year:29,section:[16,17,35],sedgwick:41,see:[2,4,11,12,16,17,23,27,30,35],seek:17,seekabl:11,select:[11,12,14,16,20,25,29,31],self:[11,21,40],sell:43,sens:23,separ:[7,12,16,27],seper:6,sequenc:[2,3,4,7,10,11,12,14,16,18,26,30,34,38],sequenti:[11,16],seri:[11,16,21,26],serial:[7,16,27],set:[0,2,5,8,11,12,14,16,18,23,31,37],set_opt:5,setup:[16,42,44],sever:[6,16,37],shall:43,shape:17,shapefil:[22,40],share:[3,16,38],sharir:41,sheet:22,should:[0,2,3,5,7,11,12,14,16,17,23,26,41,42],show:19,shown:[23,37],signific:16,similar:[3,11,12,16,21,35],similarli:16,simpl:[4,16,18,19,28,30,37],simplemovingaverag:[16,21],simplest:38,simpli:[21,25,39],simplifi:16,simul:[24,39],simultan:5,singl:[2,7,11,12,16,37],six:21,six_month_moving_averag:21,size:[2,11,17],skill:17,skip:[11,12],skip_lin:[11,16],slice:[11,16],slightli:[16,35],slow:[14,22],slug:[4,11,16,36],slug_column:[11,16,36],slug_row:[11,16,36],slugifi:[11,16],small:[0,16],smart:16,smarter:16,smooth:21,snif:11,sniff:11,sniff_limit:[11,16],sniffer:16,snippet:25,softwar:[30,43],solv:41,some:[11,12,16,17,21,22,23,24,37,38],someth:[17,40],sometim:[11,35,37,38],sonnad:41,soon:18,sort:[3,4,10,11,16,18,21,25],sort_bi:16,sourc:[17,18,24,41],space:11,special:[16,22,40],specif:[2,7,11,16,17,25],specifi:[2,4,7,11,12,14,16,20,26,30,37],specified_typ:22,speed:42,spell:21,split:16,spread:11,spreadsheet:[16,23],sql:[0,11,12,16,18,40,41],stabl:44,stackoverflow:2,stai:17,standard:[2,4,16,18,30,37],star:35,start:[9,11,12,16,19,21,25,26,28,41],start_or_stop:11,startswith:39,stat:[16,37,40],state:[16,19,24,25,29,35,37,39],state_abbr:24,statist:[16,18,24,40],stdev:[2,16,37],stdev_outli:[16,37],stdin:16,stdout:[11,12],step:[11,12,25,35,41],still:[4,16,24,44],stop:[11,12],store:[21,38],str:7,straightforward:40,streak:16,streamlin:16,string:[2,4,7,11,12,16,21,23,33],stringifi:38,strip:[7,16,24],strive:[27,30],strongli:42,strptime:[7,23],structur:[12,16,22,35],style:[11,17,40],stylist:17,subclass:[3,11,12,16,24],subject:43,sublicens:43,submit:[17,18],subset:[11,37],substanti:[16,43],suffix:[11,16],suggest:17,suit:17,sum:[2,4,16,21,37,41],summar:[2,24],summari:[2,16,37,44],summer:25,suppli:[11,38],support:[0,2,3,6,8,11,12,16,17,21,22,30,40],suppress:16,sure:[17,44],svg:[11,12,16],swap:21,symbol:[7,16],syntax:[16,25],sys:11,system:[11,16],tabl:[1,2,3,4,7,13,14,15,16,18,19,20,21,23,25,26,27,28,29,30,31,33,34,35,36,37,38,39,40,44],table2:22,tableset:[1,2,4,8,11,16,24,29,35,40,44],tablset:12,tabular:22,tack:28,tag:44,take:[2,4,11,12,14,16],target:16,task:[17,41],tauru:[16,41],technic:41,tenth:2,test:[0,1,2,7,11,12,14,16,17,22,25,35,39,42,44],testcas:[13,16],tester:22,texa:39,text:[0,4,7,11,12,14,16,17,21,22,36],text_typ:[22,23,24,27],textcolumn:16,textiowrapp:[11,12],texttyp:16,than:[0,9,10,11,16,19,21,35,37,42],thank:16,thei:[3,11,14,16,17,23,27],them:[3,4,6,7,11,16,22,35],themselv:11,therefor:17,thi:[2,3,4,5,6,7,8,9,11,12,14,16,17,21,22,23,24,25,26,27,28,30,34,35,37,38,41,43,44],thin:7,thing:21,think:38,third:16,those:[4,9,11,12,16,30,33,35,37],though:16,thousand:27,three:[2,11,16,20,35],through:[11,18],tick:5,tick_char:5,ticket:17,tied:4,time:[0,4,7,11,16,18,21,26],timedelta:[4,7,14,16],timedeltacolumn:16,timedeltatyp:16,timezon:[7,16],timezone_shift:23,titl:[19,36],to_csv:[11,12,16,32],to_json:[11,12,16,32],to_sql:[32,40],todai:16,togeth:38,too:[25,42],tool:40,top:[11,12,16],top_crim:19,top_ten_perc:25,tort:43,total:[4,19,21,35,37,41],total_cost:41,tox:[17,42,44],tracker:17,trail:16,transform:[16,18],translat:24,transpos:11,treat:16,tremend:24,trivial:33,true_or_fals:39,true_valu:7,truli:11,truncat:[11,12],truth:[25,39],tupl:[2,3,11,12,14,16,21,24,34],tutori:[16,17,41,44],two:[4,7,11,12,16,19,20,23,24,35,38],txt:42,type:[1,2,3,4,8,11,12,13,16,18,21,23,37],typeerror:8,typetest:[7,11,14,16,22],typic:[11,17,21,37],typo:21,un33k:11,under:[16,17,23],underli:[3,12],underscor:[16,18],unexpect:14,ungroup:16,unicod:[0,2,6,7,11,16],unicodedictread:6,unicodedictwrit:6,unicoderead:6,unicodewrit:6,uniqu:[3,4,11,36,37,38],unit:[1,5,16,44],unittest:13,unless:[0,11,16],unlik:35,unmatch:11,unmodifi:11,unnecessari:16,unreason:22,unspecifi:16,unsupportedaggregationerror:[2,8,16],until:3,updat:[16,17,44],upgrad:[16,42],upload:44,uppercas:16,upstream:44,us_eastern:23,usa:16,usag:[11,16],usatodaydiversityindex:21,use:[4,5,6,7,11,16,17,18,19,21,22,23,24,25,27,35,39,41,42,43],used:[2,4,6,7,9,10,11,12,14,16,21,22,26,29,36,37,38],useful:[11,25,37],user:[0,5,8,16,17,27,41],uses:[6,11,22],using:[2,4,7,9,11,12,14,16,20,21,23,24,25,27,30,33,34,37,40,41],usp:29,usual:11,utc:23,utf:[6,11,12],util:16,val:21,valid:[2,4,7,11,12,16,21],valu:[2,3,4,5,7,8,10,11,12,14,15,16,18,24,28,30,37,39],value2014:30,value2015:30,value_column:[11,16],value_column_nam:11,valueerror:12,values_distinct:[3,16,25],values_sort:[3,16],values_without_nul:[3,16],values_without_nulls_sort:[3,16],variabl:[16,29],varianc:[2,16,37],variat:21,varieti:[4,11,16],variou:[2,11,18],veri:[0,19,35,38],verifi:[2,4,13,17,21,44],version:[6,11,16,17,21,38,42,44],vertic:[5,11],vertical_line_char:5,via:[11,16,19],view:11,vincentarelbundock:22,vlookup:16,wai:[0,2,9,12,16,23,24,30,35],wait:17,want:[14,17,20,21,24,25,35,40,41,42],warn:[1,16],warn_duplicate_column:15,warn_null_calcul:15,warranti:43,welcom:[17,18],well:[16,27],welsh:[16,41],were:[16,23,38],what:[11,13,14,17,21,23,24],wheel:16,when:[0,2,4,7,11,12,14,16,17,21,22,23,27,30,38,40],when_in_rom:23,where:[11,12,14,16,24,25,29,33,38,39],whether:[11,43],which:[2,4,7,8,10,11,12,15,16,22,27,30,37],white:[11,21,38],whitespac:16,whole:21,whom:43,whose:[11,33,35],why:41,wide:[2,21],width:[1,11,12,16,19,41],wilson:41,wimpi:24,win:19,window:[16,42],wireservic:[9,11,41],wish:11,with_averag:21,with_index:21,within:[3,33],without:[2,4,11,16,31,43],won:[11,17],work:[0,9,11,12,16,17,18,21,22,23,27,34,35,39,40,42,44],workflow:16,world:[27,40,41],worri:17,would:[6,11,12,16,21,23,30,35,38],wrap:11,wrapper:[6,7,9,16],write:[11,12,16,17,21,35],writer:[1,11,16],written:16,wrote:16,xlabel:19,xls:[22,40],xlsx:[22,40],year:[11,21,24,25,26,28],yes:7,yet:21,yield:[11,16],ylabel:19,you:[2,4,6,11,12,14,16,17,19,20,21,22,23,24,25,27,30,35,37,38,39,40,41,42],your:[2,4,6,11,14,16,17,18,21,22,23,24,25,26,30,37,38,41],yourself:17,z_score:16,zealous:0,zen:0,zero:[5,16,23],zero_line_char:5,zeroth:2,zone:16,zscore:16},titles:["About agate","API","Aggregations","Columns and rows","Computations","Config","CSV reader and writer","Data types","Exceptions","Fixed-width reader","Miscellaneous","Table","TableSet","Unit testing helpers","Type inference","Warnings","Changelog","Contributing","Cookbook","Charts","Renaming and reordering columns","Compute new values","Creating tables","Dates and times","Emulate Excel","Filter rows","Homogenize rows","Locales","Lookup","Emulate R","Rank","Remove columns","Save a table","Search","Sort","Emulate SQL","Standardize names and values","Statistics","Transform","Emulate underscore.js","Extensions","agate 1.6.0","Installation","License","Release process","Tutorial"],titleterms:{"function":35,"new":[11,21],Using:[19,40],about:0,advanc:[11,18],agat:[0,41],aggreg:[2,29,35,37],all:39,alphabet:34,ani:39,api:1,august:16,averag:21,bar:19,base:[19,26],basic:[2,11,18],between:21,calcul:[11,23],cast:29,chain:35,chang:[21,30],changelog:16,chart:[11,12,19],code:[17,41],column:[3,19,20,22,31,34,36,38],come:18,command:35,competit:30,comput:[4,21],concaten:24,config:5,contribut:17,convert:23,cookbook:18,count:37,cpi:28,creat:[11,12,22,26],cross:24,csv:[6,22,32],cumul:21,custom:37,data:[7,11,22],databas:[22,32],date:[21,23,25,34],dbf:22,decemb:16,decim:21,deflat:28,delimit:[22,32],denorm:38,descend:30,descript:37,detail:[2,4,6,7,9,11,12],develop:42,differ:[21,23],distanc:[21,33],distinct:[25,35],distribut:37,divers:21,doc:41,document:17,dot:19,dynam:26,edit:[21,33],emul:[24,29,35,39],exact:33,excel:[22,24],except:8,exclud:31,extens:40,februari:16,file:22,filter:[25,39],find:39,fix:9,format:23,formula:24,frequenc:37,from:[18,22],full:35,fuzzi:33,glob:25,group:35,have:35,helper:13,histogram:19,homogen:26,identifi:37,includ:31,index:21,indic:41,infer:[14,22],inner:35,instal:42,januari:16,join:[35,41],json:[22,32],kei:38,latin1:22,lattic:19,left:35,levenshtein:21,licens:[17,43],limit:22,line:19,list:[2,4,7,9,11,12,40],local:27,lookup:28,mai:16,manual:22,march:16,mathemat:4,matplotlib:19,melt:29,memori:22,merg:29,method:12,miscellan:10,miss:26,move:21,multipl:[34,38],name:36,newlin:[22,32],normal:38,novemb:16,number:27,numer:34,octob:16,order:[25,29,34,35],other:18,outer:35,outlier:37,overrid:22,own:40,percent:[21,25,37,38],percentil:30,phonet:33,pivot:[24,38],place:21,platform:42,preview:[11,12],principl:0,process:[11,12,17,44],properti:[11,12],proxi:12,python:6,random:[25,34],rang:25,rank:30,rbind:29,reader:[6,9],regex:25,reject:39,releas:44,remot:22,remov:31,renam:20,reorder:20,revers:34,round:21,row:[3,25,26,36],sampl:25,save:[11,12,32],search:33,select:35,semicolon:22,separ:38,septemb:16,set:27,show:41,similar:33,simpl:[21,24],singl:38,sort:[23,34],specif:31,specifi:[22,23,27],spreadsheet:22,sql:[22,32,35],standard:36,statist:[2,37],subset:29,sum:[24,38],summari:24,support:[7,42],svg:19,tab:22,tabl:[11,12,22,24,32,41],tableset:12,tabul:24,techniqu:18,test:13,text:[2,19],time:23,timezon:23,todai:21,togeth:35,tool:18,top:25,total:38,transform:38,trim:24,tsv:22,tutori:45,two:21,type:[7,14,22],underscor:39,unicod:22,unit:13,usa:21,user:42,valu:[21,25,26,36,38],vlookup:24,warn:15,where:35,who:41,why:0,width:9,within:25,write:40,writer:6,your:[27,40]}})