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) module petl petl.config petl.io petl.io.avro petl.io.bcolz petl.io.csv petl.io.db petl.io.gsheet petl.io.html petl.io.json petl.io.numpy petl.io.pandas petl.io.pickle petl.io.pytables petl.io.register petl.io.remote petl.io.streams petl.io.text petl.io.whoosh petl.io.xls petl.io.xlsx petl.io.xml petl.transform petl.transform.basics petl.transform.conversions petl.transform.dedup petl.transform.fills petl.transform.headers petl.transform.intervals petl.transform.joins petl.transform.maps petl.transform.reductions petl.transform.regex petl.transform.reshape petl.transform.selects petl.transform.setops petl.transform.sorts petl.transform.unpacks petl.transform.validation petl.util

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)