o
;Di
@ s` d dl mZmZmZ d dlZd dlmZ d ddZee_ee_d ddZ G d d
d
eZ
dS )
)divisionprint_functionabsolute_importN)TableFc C sX ddl }t| }zt|}W n ty d}Y nw |du r |}|jj||||||dS )a
Load data from the given `table` into a
`pandas `_ DataFrame. E.g.::
>>> import petl as etl
>>> table = [('foo', 'bar', 'baz'),
... ('apples', 1, 2.5),
... ('oranges', 3, 4.4),
... ('pears', 7, .1)]
>>> df = etl.todataframe(table)
>>> df
foo bar baz
0 apples 1 2.5
1 oranges 3 4.4
2 pears 7 0.1
r N)indexexcludecolumns coerce_floatnrows)pandasiternext
StopIteration DataFrame from_records) tabler r r r r
pditheader r G/var/www/Datamplify/venv/lib/python3.10/site-packages/petl/io/pandas.py todataframe s r c C s t | |dS )a
Extract a table from a `pandas `_ DataFrame.
E.g.::
>>> import petl as etl
>>> import pandas as pd
>>> records = [('apples', 1, 2.5), ('oranges', 3, 4.4), ('pears', 7, 0.1)]
>>> df = pd.DataFrame.from_records(records, columns=('foo', 'bar', 'baz'))
>>> table = etl.fromdataframe(df)
>>> table
+-----------+-----+-----+
| foo | bar | baz |
+===========+=====+=====+
| 'apples' | 1 | 2.5 |
+-----------+-----+-----+
| 'oranges' | 3 | 4.4 |
+-----------+-----+-----+
| 'pears' | 7 | 0.1 |
+-----------+-----+-----+
)
include_index)
DataFrameView)dfr r r r
fromdataframe/ s r c @ s e Zd ZdddZdd ZdS )r Fc C s< t |drt |drt|jsJ d| || _|| _d S )Nr iterrowsz1bad argument, expected pandas.DataFrame, found %r)hasattrinspectismethodr r r )selfr r r r r __init__K s
zDataFrameView.__init__c c sr | j r!dt| jj V | j D ] \}}|ft| V qd S t| jjV | j D ] \}}t|V q-d S )N)r )r tupler r r )r irow_r r r __iter__S s zDataFrameView.__iter__NF)__name__
__module__ __qualname__r! r& r r r r r I s
r )NNNFNr' )
__future__r r r r petl.util.baser r todfr r r r r r s