activeloopai / activeloopai/deeplake

[FEATURE] single-CSV auto ingestion

Open
#1,377 1 comment 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
C++
Stars
9.2k
Forks
722
PR merge metrics
No merged PRs in 30d

Description

## 🚨🚨 Feature Request

Related to #1156 (this issue is a building block to it)

## Description

build the implementation of the API:
```python
ds = ... # create dataset

"""
columns/structure of the file found at: "path/to/file.csv"

--------------------
col1, col2, col3
"text", 1, 5
"another_text", 1, 5.5
"""

ds.ingest("path/to/file.csv")

assert ds.col1.data() == ["text", "another_text"]
assert ds.col2.numpy(as_list=True) == [1, 1]
assert ds.col3.numpy(as_list=True) == [1, 5.5]

assert len(ds) == 2 # num rows
```

#1156 is the feature to support a directory of CSV files, but a single CSV file is sufficient for now.

## Solution
you can probably use pandas to read the CSV file and then create one tensor per column. set the dtype for each column as the dtype found in pandas for that column. the htype can only be determined for text for now. in the future, we would want to infer htypes but now it isn't required.

i would create a **new subdirectory + file** under [here](https://github.com/activeloopai/Hub/tree/main/hub/auto) called "structured/csv.py" and implement your code there, and following the same code structure as the unstructured classes found [here](https://github.com/activeloopai/Hub/tree/main/hub/auto/unstructured).

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.