summaryrefslogtreecommitdiff
path: root/tablib/formats/_df.py
blob: 0c7ebec714e65580e1a2f86ae535ac3d271de5cd (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
""" Tablib - DataFrame Support.
"""

import sys
from io import BytesIO

try:
    from pandas import DataFrame
except ImportError:
    DataFrame = None

import tablib

from tablib.compat import unicode

title = 'df'
extensions = ('df', )

def detect(stream):
    """Returns True if given stream is a DataFrame."""
    if DataFrame is None:
        return False
    try:
        DataFrame(stream)
        return True
    except ValueError:
        return False


def export_set(dset, index=None):
    """Returns DataFrame representation of DataBook."""
    if DataFrame is None:
        raise NotImplementedError(
            'DataFrame Format requires `pandas` to be installed.'
            ' Try `pip install tablib[pandas]`.')
    dataframe = DataFrame(dset.dict, columns=dset.headers)
    return dataframe


def import_set(dset, in_stream):
    """Returns dataset from DataFrame."""
    dset.wipe()
    dset.dict = in_stream.to_dict(orient='records')