Index

A

addcolumn() (in module petl.transform.basics) addfield() (in module petl.transform.basics) addfields() (in module petl.transform.basics) addfieldusingcontext() (in module petl.transform.basics) addrownumbers() (in module petl.transform.basics) aggregate() (in module petl.transform.reductions) annex() (in module petl.transform.basics) antijoin() (in module petl.transform.joins) appendavro() (in module petl.io.avro)

appendbcolz() (in module petl.io.bcolz) appendcsv() (in module petl.io.csv) appenddb() (in module petl.io.db) appendgsheet() (in module petl.io.gsheet) appendhdf5() (in module petl.io.pytables) appendpickle() (in module petl.io.pickle) appendtext() (in module petl.io.text) appendtextindex() (in module petl.io.whoosh) appendtsv() (in module petl.io.csv) appendxlsx() (in module petl.io.xlsx)

B

biselect() (in module petl.transform.selects)

boolparser() (in module petl.util.parsers) BZ2Source (class in petl.io.sources)

C

cache() (in module petl.util.materialise) capture() (in module petl.transform.regex) cat() (in module petl.transform.basics) clock() (in module petl.util.timing) coalesce() (in module petl.util.misc) collapsedintervals() (in module petl.transform.intervals) columns() (in module petl.util.materialise)

complement() (in module petl.transform.setops) conflicts() (in module petl.transform.dedup) convert() (in module petl.transform.conversions) convertall() (in module petl.transform.conversions) convertnumbers() (in module petl.transform.conversions) crossjoin() (in module petl.transform.joins) cut() (in module petl.transform.basics) cutout() (in module petl.transform.basics)

D

data() (in module petl.util.base) dateparser() (in module petl.util.parsers) datetimeparser() (in module petl.util.parsers) dictlookup() (in module petl.util.lookups) dictlookupone() (in module petl.util.lookups) dicts() (in module petl.util.base) diff() (in module petl.transform.setops)

diffheaders() (in module petl.util.misc) diffvalues() (in module petl.util.misc) display() (in module petl.util.vis) displayall() (in module petl.util.vis) distinct() (in module petl.transform.dedup) dummytable() (in module petl.util.random) duplicates() (in module petl.transform.dedup)

E

empty() (in module petl.util.base)

expr() (in module petl.util.base) extendheader() (in module petl.transform.headers)

F

facet() (in module petl.transform.selects) facetcolumns() (in module petl.util.materialise) facetintervallookup() (in module petl.transform.intervals) facetintervallookupone() (in module petl.transform.intervals) facetintervalrecordlookup() (in module petl.transform.intervals) facetintervalrecordlookupone() (in module petl.transform.intervals) failonerror (in module petl.config) fieldmap() (in module petl.transform.maps) fieldnames() (in module petl.util.base) FileSource (class in petl.io.sources) filldown() (in module petl.transform.fills) fillleft() (in module petl.transform.fills) fillright() (in module petl.transform.fills) flatten() (in module petl.transform.reshape) fold() (in module petl.transform.reductions) format() (in module petl.transform.conversions) formatall() (in module petl.transform.conversions) fromarray() (in module petl.io.numpy)

fromavro() (in module petl.io.avro) frombcolz() (in module petl.io.bcolz) fromcolumns() (in module petl.io.base) fromcsv() (in module petl.io.csv) fromdataframe() (in module petl.io.pandas) fromdb() (in module petl.io.db) fromdicts() (in module petl.io.json) fromgsheet() (in module petl.io.gsheet) fromhdf5() (in module petl.io.pytables) fromhdf5sorted() (in module petl.io.pytables) fromjson() (in module petl.io.json) frompickle() (in module petl.io.pickle) fromtext() (in module petl.io.text) fromtextindex() (in module petl.io.whoosh) fromtsv() (in module petl.io.csv) fromxls() (in module petl.io.xls) fromxlsx() (in module petl.io.xlsx) fromxml() (in module petl.io.xml)

G

get_reader() (in module petl.io.sources) get_writer() (in module petl.io.sources) groupcountdistinctvalues() (in module petl.transform.reductions) groupselectfirst() (in module petl.transform.reductions)

groupselectlast() (in module petl.transform.reductions) groupselectmax() (in module petl.transform.reductions) groupselectmin() (in module petl.transform.reductions) GzipSource (class in petl.io.sources)

H

hashantijoin() (in module petl.transform.hashjoins) hashcomplement() (in module petl.transform.setops) hashintersection() (in module petl.transform.setops) hashjoin() (in module petl.transform.hashjoins)

hashleftjoin() (in module petl.transform.hashjoins) hashlookupjoin() (in module petl.transform.hashjoins) hashrightjoin() (in module petl.transform.hashjoins) head() (in module petl.transform.basics) header() (in module petl.util.base)

I

interpolate() (in module petl.transform.conversions) interpolateall() (in module petl.transform.conversions) intersection() (in module petl.transform.setops) intervalantijoin() (in module petl.transform.intervals) intervaljoin() (in module petl.transform.intervals) intervaljoinvalues() (in module petl.transform.intervals) intervalleftjoin() (in module petl.transform.intervals)

intervallookup() (in module petl.transform.intervals) intervallookupone() (in module petl.transform.intervals) intervalrecordlookup() (in module petl.transform.intervals) intervalrecordlookupone() (in module petl.transform.intervals) intervalsubtract() (in module petl.transform.intervals) issorted() (in module petl.transform.sorts) isunique() (in module petl.transform.dedup)

J

join() (in module petl.transform.joins)

L

leftjoin() (in module petl.transform.joins) limits() (in module petl.util.statistics) listoflists() (in module petl.util.materialise) listoftuples() (in module petl.util.materialise) log_progress() (in module petl.util.timing)

look() (in module petl.util.vis) lookall() (in module petl.util.vis) lookup() (in module petl.util.lookups) lookupjoin() (in module petl.transform.joins) lookupone() (in module petl.util.lookups)

M

melt() (in module petl.transform.reshape) MemorySource (class in petl.io.sources) merge() (in module petl.transform.reductions)

mergeduplicates() (in module petl.transform.reductions) mergesort() (in module petl.transform.sorts) movefield() (in module petl.transform.basics)

N

namedtuples() (in module petl.util.base) nrows() (in module petl.util.counting)

nthword() (in module petl.util.misc) numparser() (in module petl.util.parsers)

O

outerjoin() (in module petl.transform.joins)

P

parsecounter() (in module petl.util.counting) parsecounts() (in module petl.util.counting) petl (module) petl.config (module) petl.io (module) petl.io.avro (module) petl.io.bcolz (module) petl.io.csv (module) petl.io.db (module) petl.io.gsheet (module) petl.io.html (module) petl.io.json (module) petl.io.numpy (module) petl.io.pandas (module) petl.io.pickle (module) petl.io.pytables (module) petl.io.register (module) petl.io.remote (module) petl.io.streams (module) petl.io.text (module) petl.io.whoosh (module) petl.io.xls (module) petl.io.xlsx (module)

petl.io.xml (module) petl.transform (module) petl.transform.basics (module) petl.transform.conversions (module) petl.transform.dedup (module) petl.transform.fills (module) petl.transform.headers (module) petl.transform.intervals (module) petl.transform.joins (module) petl.transform.maps (module) petl.transform.reductions (module) petl.transform.regex (module) petl.transform.reshape (module) petl.transform.selects (module) petl.transform.setops (module) petl.transform.sorts (module) petl.transform.unpacks (module) petl.transform.validation (module) petl.util (module) pivot() (in module petl.transform.reshape) PopenSource (class in petl.io.sources) prefixheader() (in module petl.transform.headers) progress() (in module petl.util.timing) pushheader() (in module petl.transform.headers)

R

randomtable() (in module petl.util.random) recast() (in module petl.transform.reshape) recordcomplement() (in module petl.transform.setops) recorddiff() (in module petl.transform.setops) recordlookup() (in module petl.util.lookups) recordlookupone() (in module petl.util.lookups) records() (in module petl.util.base) register_reader() (in module petl.io.sources) register_writer() (in module petl.io.sources) RemoteSource (class in petl.io.remotes) rename() (in module petl.transform.headers)

replace() (in module petl.transform.conversions) replaceall() (in module petl.transform.conversions) rightjoin() (in module petl.transform.joins) rowgroupby() (in module petl.util.base) rowgroupmap() (in module petl.transform.maps) rowlengths() (in module petl.util.counting) rowlenselect() (in module petl.transform.selects) rowmap() (in module petl.transform.maps) rowmapmany() (in module petl.transform.maps) rowreduce() (in module petl.transform.reductions) rowslice() (in module petl.transform.basics)

S

search() (in module petl.transform.regex) searchcomplement() (in module petl.transform.regex) searchtextindex() (in module petl.io.whoosh) searchtextindexpage() (in module petl.io.whoosh) see() (in module petl.util.vis) select() (in module petl.transform.selects) selectcontains() (in module petl.transform.selects) selecteq() (in module petl.transform.selects) selectfalse() (in module petl.transform.selects) selectge() (in module petl.transform.selects) selectgt() (in module petl.transform.selects) selectin() (in module petl.transform.selects) selectis() (in module petl.transform.selects) selectisinstance() (in module petl.transform.selects) selectisnot() (in module petl.transform.selects) selectle() (in module petl.transform.selects) selectlt() (in module petl.transform.selects) selectne() (in module petl.transform.selects) selectnone() (in module petl.transform.selects) selectnotin() (in module petl.transform.selects) selectnotnone() (in module petl.transform.selects) selectop() (in module petl.transform.selects)

selectrangeclosed() (in module petl.transform.selects) selectrangeopen() (in module petl.transform.selects) selectrangeopenleft() (in module petl.transform.selects) selectrangeopenright() (in module petl.transform.selects) selecttrue() (in module petl.transform.selects) selectusingcontext() (in module petl.transform.selects) setheader() (in module petl.transform.headers) skip() (in module petl.transform.headers) skipcomments() (in module petl.transform.basics) SMBSource (class in petl.io.remotes) sort() (in module petl.transform.sorts) sortheader() (in module petl.transform.headers) split() (in module petl.transform.regex) splitdown() (in module petl.transform.regex) stack() (in module petl.transform.basics) stats() (in module petl.util.statistics) StdinSource (class in petl.io.sources) StdoutSource (class in petl.io.sources) stringpatterncounter() (in module petl.util.counting) stringpatterns() (in module petl.util.counting) strjoin() (in module petl.util.misc) sub() (in module petl.transform.regex) suffixheader() (in module petl.transform.headers)

T

tail() (in module petl.transform.basics) teecsv() (in module petl.io.csv) teehtml() (in module petl.io.html) teepickle() (in module petl.io.pickle) teetext() (in module petl.io.text) teetsv() (in module petl.io.csv) timeparser() (in module petl.util.parsers) toarray() (in module petl.io.numpy) toavro() (in module petl.io.avro) tobcolz() (in module petl.io.bcolz) tocsv() (in module petl.io.csv) todataframe() (in module petl.io.pandas) todb() (in module petl.io.db) togsheet() (in module petl.io.gsheet) tohdf5() (in module petl.io.pytables) tohtml() (in module petl.io.html)

tojson() (in module petl.io.json) tojsonarrays() (in module petl.io.json) topickle() (in module petl.io.pickle) torecarray() (in module petl.io.numpy) totext() (in module petl.io.text) totextindex() (in module petl.io.whoosh) totsv() (in module petl.io.csv) toxls() (in module petl.io.xls) toxlsx() (in module petl.io.xlsx) toxml() (in module petl.io.xml) transpose() (in module petl.transform.reshape) tupleoflists() (in module petl.util.materialise) tupleoftuples() (in module petl.util.materialise) typecounter() (in module petl.util.counting) typecounts() (in module petl.util.counting) typeset() (in module petl.util.misc)

U

unflatten() (in module petl.transform.reshape) unique() (in module petl.transform.dedup) unjoin() (in module petl.transform.joins)

unpack() (in module petl.transform.unpacks) unpackdict() (in module petl.transform.unpacks) update() (in module petl.transform.conversions) URLSource (class in petl.io.sources)

V

validate() (in module petl.transform.validation) valuecount() (in module petl.util.counting) valuecounter() (in module petl.util.counting)

valuecounts() (in module petl.util.counting) values() (in module petl.util.base) valuestoarray() (in module petl.io.numpy)

Z

ZipSource (class in petl.io.sources)