DataChain
The DataChain
class creates a data chain, which is a sequence of data manipulation
steps such as reading data from storages, running AI or LLM models or calling external
services API to validate or enrich data. See DataChain
for examples of how to create a chain.
Column
Bases: ColumnClause
Source code in datachain/query/schema.py
glob
DataChain
DataChain(
query: DatasetQuery,
settings: Settings,
signal_schema: SignalSchema,
setup: Optional[dict] = None,
_sys: bool = False,
)
DataChain - a data structure for batch data processing and evaluation.
It represents a sequence of data manipulation steps such as reading data from storages, running AI or LLM models or calling external services API to validate or enrich data.
Data in DataChain is presented as Python classes with arbitrary set of fields,
including nested classes. The data classes have to inherit from DataModel
class.
The supported set of field types include: majority of the type supported by the
underlyind library Pydantic
.
See Also
DataChain.from_storage("s3://my-bucket/my-dir/")
- reading unstructured
data files from storages such as S3, gs or Azure ADLS.
DataChain.save("name")
- saving to a dataset.
DataChain.from_dataset("name")
- reading from a dataset.
DataChain.from_values(fib=[1, 2, 3, 5, 8])
- generating from values.
DataChain.from_pandas(pd.DataFrame(...))
- generating from pandas.
DataChain.from_json("file.json")
- generating from json.
DataChain.from_csv("file.csv")
- generating from csv.
DataChain.from_parquet("file.parquet")
- generating from parquet.
Example
import os
from mistralai.client import MistralClient
from mistralai.models.chat_completion import ChatMessage
from datachain.dc import DataChain, Column
PROMPT = (
"Was this bot dialog successful? "
"Describe the 'result' as 'Yes' or 'No' in a short JSON"
)
model = "mistral-large-latest"
api_key = os.environ["MISTRAL_API_KEY"]
chain = (
DataChain.from_storage("gs://datachain-demo/chatbot-KiT/")
.limit(5)
.settings(cache=True, parallel=5)
.map(
mistral_response=lambda file: MistralClient(api_key=api_key)
.chat(
model=model,
response_format={"type": "json_object"},
messages=[
ChatMessage(role="user", content=f"{PROMPT}: {file.read()}")
],
)
.choices[0]
.message.content,
)
.save()
)
try:
print(chain.select("mistral_response").results())
except Exception as e:
print(f"do you have the right Mistral API key? {e}")
Source code in datachain/lib/dc.py
_effective_signals_schema
property
Effective schema used for user-facing API like collect, to_pandas, etc.
__or__
agg
agg(
func: Optional[Callable] = None,
partition_by: Optional[PartitionByType] = None,
params: Union[None, str, Sequence[str]] = None,
output: OutputType = None,
**signal_map
) -> Self
Aggregate rows using partition_by
statement and apply a function to the
groups of aggregated rows. The function needs to return new objects for each
group of the new rows. It returns a chain itself with new signals.
Input-output relationship: N:M
This method bears similarity to gen()
and map()
, employing a comparable set
of parameters, yet differs in two crucial aspects:
1. The partition_by
parameter: This specifies the column name or a list of
column names that determine the grouping criteria for aggregation.
2. Group-based UDF function input: Instead of individual rows, the function
receives a list all rows within each group defined by partition_by
.
Examples:
chain = chain.agg(
total=lambda category, amount: [sum(amount)],
output=float,
partition_by="category",
)
chain.save("new_dataset")
An alternative syntax, when you need to specify a more complex function:
# It automatically resolves which columns to pass to the function
# by looking at the function signature.
def agg_sum(
file: list[File], amount: list[float]
) -> Iterator[tuple[File, float]]:
yield file[0], sum(amount)
chain = chain.agg(
agg_sum,
output={"file": File, "total": float},
# Alternative syntax is to use `C` (short for Column) to specify
# a column name or a nested column, e.g. C("file.path").
partition_by=C("category"),
)
chain.save("new_dataset")
Source code in datachain/lib/dc.py
apply
Apply any function to the chain.
Useful for reusing in a chain of operations.
Example
Source code in datachain/lib/dc.py
avg
avg(fr: DataType)
batch_map
batch_map(
func: Optional[Callable] = None,
params: Union[None, str, Sequence[str]] = None,
output: OutputType = None,
batch: int = 1000,
**signal_map
) -> Self
This is a batch version of map()
.
Input-output relationship: N:N
It accepts the same parameters plus an additional parameter:
batch : Size of each batch passed to `func`. Defaults to 1000.
Example
Source code in datachain/lib/dc.py
c
Returns Column instance attached to the current chain.
chunk
Split a chain into smaller chunks for e.g. parallelization.
Example
Note
Bear in mind that index
is 0-indexed but total
isn't.
Use 0/3, 1/3 and 2/3, not 1/3, 2/3 and 3/3.
Source code in datachain/lib/dc.py
clone
collect
Yields rows of values, optionally limited to the specified columns.
Parameters:
-
*cols
(str
, default:()
) –Limit to the specified columns. By default, all columns are selected.
Yields:
-
DataType
–Yields a single item if a column is selected.
-
tuple[DataType, ...]
–Yields a tuple of items if multiple columns are selected.
Example
Iterating over all rows:
Iterating over all rows with selected columns:
Iterating over a single column:
Source code in datachain/lib/dc.py
collect_flatten
Yields flattened rows of values as a tuple.
Parameters:
-
row_factory
–A callable to convert row to a custom format. It should accept two arguments: a list of column names and a tuple of row values.
Source code in datachain/lib/dc.py
column
Returns Column instance with a type if name is found in current schema, otherwise raises an exception.
Source code in datachain/lib/dc.py
compare
compare(
other: DataChain,
on: Union[str, Sequence[str]],
right_on: Optional[Union[str, Sequence[str]]] = None,
compare: Optional[Union[str, Sequence[str]]] = None,
right_compare: Optional[
Union[str, Sequence[str]]
] = None,
added: bool = True,
deleted: bool = True,
modified: bool = True,
same: bool = False,
status_col: Optional[str] = None,
) -> DataChain
Comparing two chains by identifying rows that are added, deleted, modified
or same. Result is the new chain that has additional column with possible
values: A
, D
, M
, U
representing added, deleted, modified and same
rows respectively. Note that if only one "status" is asked, by setting proper
flags, this additional column is not created as it would have only one value
for all rows. Beside additional diff column, new chain has schema of the chain
on which method was called.
Parameters:
-
other
(DataChain
) –Chain to calculate diff from.
-
on
(Union[str, Sequence[str]]
) –Column or list of columns to match on. If both chains have the same columns then this column is enough for the match. Otherwise,
right_on
parameter has to specify the columns for the other chain. This value is used to find corresponding row in other dataset. If not found there, row is considered as added (or removed if vice versa), and if found then row can be either modified or same. -
right_on
(Optional[Union[str, Sequence[str]]]
, default:None
) –Optional column or list of columns for the
other
to match. -
compare
(Optional[Union[str, Sequence[str]]]
, default:None
) –Column or list of columns to compare on. If both chains have the same columns then this column is enough for the compare. Otherwise,
right_compare
parameter has to specify the columns for the other chain. This value is used to see if row is modified or same. If not set, all columns will be used for comparison -
right_compare
(Optional[Union[str, Sequence[str]]]
, default:None
) –Optional column or list of columns for the
other
to compare to. -
added
(bool
, default:True
) –Whether to return added rows in resulting chain.
-
deleted
(bool
, default:True
) –Whether to return deleted rows in resulting chain.
-
modified
(bool
, default:True
) –Whether to return modified rows in resulting chain.
-
same
(bool
, default:False
) –Whether to return unchanged rows in resulting chain.
-
status_col
(str
, default:None
) –Name of the new column that is created in resulting chain representing diff status.
Example
Source code in datachain/lib/dc.py
1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 |
|
count
count() -> int
datasets
classmethod
datasets(
session: Optional[Session] = None,
settings: Optional[dict] = None,
in_memory: bool = False,
object_name: str = "dataset",
include_listing: bool = False,
) -> DataChain
Generate chain with list of registered datasets.
Example
Source code in datachain/lib/dc.py
diff
diff(
other: DataChain,
on: str = "file",
right_on: Optional[str] = None,
added: bool = True,
modified: bool = True,
deleted: bool = False,
same: bool = False,
status_col: Optional[str] = None,
) -> DataChain
Similar to .compare()
, which is more generic method to calculate difference
between two chains. Unlike .compare()
, this method works only on those chains
that have File
object, or it's derivatives, in it. File source
and path
are used for matching, and file version
and etag
for comparing, while in
.compare()
user needs to provide arbitrary columns for matching and comparing.
Parameters:
-
other
(DataChain
) –Chain to calculate diff from.
-
on
(str
, default:'file'
) –File signal to match on. If both chains have the same file signal then this column is enough for the match. Otherwise,
right_on
parameter has to specify the file signal for the other chain. This value is used to find corresponding row in other dataset. If not found there, row is considered as added (or removed if vice versa), and if found then row can be either modified or same. -
right_on
(Optional[str]
, default:None
) –Optional file signal for the
other
to match. -
added
(bool
, default:True
) –Whether to return added rows in resulting chain.
-
deleted
(bool
, default:False
) –Whether to return deleted rows in resulting chain.
-
modified
(bool
, default:True
) –Whether to return modified rows in resulting chain.
-
same
(bool
, default:False
) –Whether to return unchanged rows in resulting chain.
-
status_col
(str
, default:None
) –Optional name of the new column that is created in resulting chain representing diff status.
Example
Source code in datachain/lib/dc.py
1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 |
|
distinct
Removes duplicate rows based on uniqueness of some input column(s) i.e if rows are found with the same value of input column(s), only one row is left in the result set.
Source code in datachain/lib/dc.py
exec
explode
explode(
col: str,
model_name: Optional[str] = None,
object_name: Optional[str] = None,
schema_sample_size: int = 1,
) -> DataChain
Explodes a column containing JSON objects (dict or str DataChain type) into individual columns based on the schema of the JSON. Schema is inferred from the first row of the column.
Parameters:
-
col
(str
) –the name of the column containing JSON to be exploded.
-
model_name
(Optional[str]
, default:None
) –optional generated model name. By default generates the name automatically.
-
object_name
(Optional[str]
, default:None
) –optional generated object column name. By default generates the name automatically.
-
schema_sample_size
(int
, default:1
) –the number of rows to use for inferring the schema of the JSON (in case some fields are optional and it's not enough to analyze a single row).
Returns:
-
DataChain
(DataChain
) –A new DataChain instance with the new set of columns.
Source code in datachain/lib/dc.py
filter
filter(*args: Any) -> Self
Filter the chain according to conditions.
Example
Basic usage with built-in operators
Using glob to match patterns
Using datachain.func
Combining filters with "or"
Combining filters with "and"
Source code in datachain/lib/dc.py
from_csv
classmethod
from_csv(
path,
delimiter: Optional[str] = None,
header: bool = True,
output: OutputType = None,
object_name: str = "",
model_name: str = "",
source: bool = True,
nrows=None,
session: Optional[Session] = None,
settings: Optional[dict] = None,
column_types: Optional[
dict[str, Union[str, DataType]]
] = None,
parse_options: Optional[
dict[str, Union[str, Union[bool, Callable]]]
] = None,
**kwargs
) -> DataChain
Generate chain from csv files.
Parameters:
-
path
–Storage URI with directory. URI must start with storage prefix such as
s3://
,gs://
,az://
or "file:///". -
delimiter
–Character for delimiting columns. Takes precedence if also specified in
parse_options
. Defaults to ",". -
header
–Whether the files include a header row.
-
output
–Dictionary or feature class defining column names and their corresponding types. List of column names is also accepted, in which case types will be inferred.
-
object_name
–Created object column name.
-
model_name
–Generated model name.
-
source
–Whether to include info about the source file.
-
nrows
–Optional row limit.
-
session
–Session to use for the chain.
-
settings
–Settings to use for the chain.
-
column_types
–Dictionary of column names and their corresponding types. It is passed to CSV reader and for each column specified type auto inference is disabled.
-
parse_options
(Optional[dict[str, Union[str, Union[bool, Callable]]]]
, default:None
) –Tells the parser how to process lines. See https://arrow.apache.org/docs/python/generated/pyarrow.csv.ParseOptions.html
Example
Reading a csv file:
Reading csv files from a directory as a combined dataset:
Source code in datachain/lib/dc.py
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 |
|
from_dataset
classmethod
from_dataset(
name: str,
version: Optional[int] = None,
session: Optional[Session] = None,
settings: Optional[dict] = None,
fallback_to_studio: bool = True,
) -> Self
Get data from a saved Dataset. It returns the chain itself. If dataset or version is not found locally, it will try to pull it from Studio.
Parameters:
-
name
–dataset name
-
version
–dataset version
-
session
–Session to use for the chain.
-
settings
–Settings to use for the chain.
-
fallback_to_studio
–Try to pull dataset from Studio if not found locally. Default is True.
Example
Source code in datachain/lib/dc.py
from_hf
classmethod
from_hf(
dataset: Union[str, HFDatasetType],
*args,
session: Optional[Session] = None,
settings: Optional[dict] = None,
object_name: str = "",
model_name: str = "",
**kwargs
) -> DataChain
Generate chain from huggingface hub dataset.
Parameters:
-
dataset
–Path or name of the dataset to read from Hugging Face Hub, or an instance of
datasets.Dataset
-like object. -
session
–Session to use for the chain.
-
settings
–Settings to use for the chain.
-
object_name
–Generated object column name.
-
model_name
–Generated model name.
-
kwargs
–Parameters to pass to datasets.load_dataset.
Example
Load from Hugging Face Hub:
Generate chain from loaded dataset:
Source code in datachain/lib/dc.py
from_json
classmethod
from_json(
path,
type: FileType = "text",
spec: Optional[DataType] = None,
schema_from: Optional[str] = "auto",
jmespath: Optional[str] = None,
object_name: Optional[str] = "",
model_name: Optional[str] = None,
format: Optional[str] = "json",
nrows=None,
**kwargs
) -> DataChain
Get data from JSON. It returns the chain itself.
Parameters:
-
path
–storage URI with directory. URI must start with storage prefix such as
s3://
,gs://
,az://
or "file:///" -
type
–read file as "binary", "text", or "image" data. Default is "text".
-
spec
–optional Data Model
-
schema_from
–path to sample to infer spec (if schema not provided)
-
object_name
–generated object column name
-
model_name
–optional generated model name
-
format
(Optional[str]
, default:'json'
) –"json", "jsonl"
-
jmespath
–optional JMESPATH expression to reduce JSON
-
nrows
–optional row limit for jsonl and JSON arrays
Example
infer JSON schema from data, reduce using JMESPATH
infer JSON schema from a particular path
Source code in datachain/lib/dc.py
from_pandas
classmethod
from_pandas(
df: DataFrame,
name: str = "",
session: Optional[Session] = None,
settings: Optional[dict] = None,
in_memory: bool = False,
object_name: str = "",
) -> DataChain
Generate chain from pandas data-frame.
Source code in datachain/lib/dc.py
from_parquet
classmethod
from_parquet(
path,
partitioning: Any = "hive",
output: Optional[dict[str, DataType]] = None,
object_name: str = "",
model_name: str = "",
source: bool = True,
session: Optional[Session] = None,
settings: Optional[dict] = None,
**kwargs
) -> DataChain
Generate chain from parquet files.
Parameters:
-
path
–Storage URI with directory. URI must start with storage prefix such as
s3://
,gs://
,az://
or "file:///". -
partitioning
–Any pyarrow partitioning schema.
-
output
–Dictionary defining column names and their corresponding types.
-
object_name
–Created object column name.
-
model_name
–Generated model name.
-
source
–Whether to include info about the source file.
-
session
–Session to use for the chain.
-
settings
–Settings to use for the chain.
Example
Reading a single file:
Reading a partitioned dataset from a directory:
Source code in datachain/lib/dc.py
from_records
classmethod
from_records(
to_insert: Optional[Union[dict, list[dict]]],
session: Optional[Session] = None,
settings: Optional[dict] = None,
in_memory: bool = False,
schema: Optional[dict[str, DataType]] = None,
) -> Self
Create a DataChain from the provided records. This method can be used for programmatically generating a chain in contrast of reading data from storages or other sources.
Parameters:
-
to_insert
–records (or a single record) to insert. Each record is a dictionary of signals and theirs values.
-
schema
–describes chain signals and their corresponding types
Source code in datachain/lib/dc.py
2379 2380 2381 2382 2383 2384 2385 2386 2387 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 |
|
from_storage
classmethod
from_storage(
uri,
*,
type: FileType = "binary",
session: Optional[Session] = None,
settings: Optional[dict] = None,
in_memory: bool = False,
recursive: Optional[bool] = True,
object_name: str = "file",
update: bool = False,
anon: bool = False,
client_config: Optional[dict] = None
) -> Self
Get data from a storage as a list of file with all file attributes. It returns the chain itself as usual.
Parameters:
-
uri
–storage URI with directory. URI must start with storage prefix such as
s3://
,gs://
,az://
or "file:///" -
type
–read file as "binary", "text", or "image" data. Default is "binary".
-
recursive
–search recursively for the given path.
-
object_name
–Created object column name.
-
update
–force storage reindexing. Default is False.
-
anon
–If True, we will treat cloud bucket as public one
-
client_config
–Optional client configuration for the storage client.
Example
Simple call from s3
With AWS S3-compatible storage
chain = DataChain.from_storage(
"s3://my-bucket/my-dir",
client_config = {"aws_endpoint_url": "<minio-endpoint-url>"}
)
Pass existing session
Source code in datachain/lib/dc.py
401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 |
|
from_values
classmethod
from_values(
ds_name: str = "",
session: Optional[Session] = None,
settings: Optional[dict] = None,
in_memory: bool = False,
output: OutputType = None,
object_name: str = "",
**fr_map
) -> Self
Generate chain from list of values.
Source code in datachain/lib/dc.py
gen
gen(
func: Optional[Union[Callable, Generator]] = None,
params: Union[None, str, Sequence[str]] = None,
output: OutputType = None,
**signal_map
) -> Self
Apply a function to each row to create new rows (with potentially new signals). The function needs to return a new objects for each of the new rows. It returns a chain itself with new signals.
Input-output relationship: 1:N
This method is similar to map()
, uses the same list of parameters, but with
one key differences: It produces a sequence of rows for each input row (like
extracting multiple file records from a single tar file or bounding boxes from a
single image file).
Example
Source code in datachain/lib/dc.py
group_by
group_by(
*,
partition_by: Optional[
Union[str, Func, Sequence[Union[str, Func]]]
] = None,
**kwargs: Func
) -> Self
Group rows by specified set of signals and return new signals with aggregated values.
The supported functions
count(), sum(), avg(), min(), max(), any_value(), collect(), concat()
Source code in datachain/lib/dc.py
1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 |
|
limit
limit(n: int) -> Self
Return the first n
rows of the chain.
If the chain is unordered, which rows are returned is undefined.
If the chain has less than n
rows, the whole chain is returned.
Parameters:
-
n
(int
) –Number of rows to return.
Source code in datachain/lib/dc.py
listings
classmethod
listings(
session: Optional[Session] = None,
in_memory: bool = False,
object_name: str = "listing",
**kwargs
) -> DataChain
Generate chain with list of cached listings. Listing is a special kind of dataset which has directory listing data of some underlying storage (e.g S3 bucket).
Source code in datachain/lib/dc.py
map
map(
func: Optional[Callable] = None,
params: Union[None, str, Sequence[str]] = None,
output: OutputType = None,
**signal_map
) -> Self
Apply a function to each row to create new signals. The function should return a new object for each row. It returns a chain itself with new signals.
Input-output relationship: 1:1
Parameters:
-
func
–Function applied to each row.
-
params
–List of column names used as input for the function. Default is taken from function signature.
-
output
–Dictionary defining new signals and their corresponding types. Default type is taken from function signature. Default can be also taken from kwargs - **signal_map (see below). If signal name is defined using signal_map (see below) only a single type value can be used.
-
**signal_map
–kwargs can be used to define
func
together with it's return signal name in format ofmap(my_sign=my_func)
. This helps define signal names and function in a nicer way.
Example
Using signal_map and single type in output:
Using func and output as a map:
Source code in datachain/lib/dc.py
max
max(fr: DataType)
merge
merge(
right_ds: DataChain,
on: Union[MergeColType, Sequence[MergeColType]],
right_on: Optional[
Union[MergeColType, Sequence[MergeColType]]
] = None,
inner=False,
full=False,
rname="right_",
) -> Self
Merge two chains based on the specified criteria.
Parameters:
-
right_ds
(DataChain
) –Chain to join with.
-
on
(Union[MergeColType, Sequence[MergeColType]]
) –Predicate ("column.name", C("column.name"), or Func) or list of Predicates to join on. If both chains have the same predicates then this predicate is enough for the join. Otherwise,
right_on
parameter has to specify the predicates for the other chain. -
right_on
(Optional[Union[MergeColType, Sequence[MergeColType]]]
, default:None
) –Optional predicate or list of Predicates for the
right_ds
to join. -
inner
(bool
, default:False
) –Whether to run inner join or outer join.
-
full
(bool
, default:False
) –Whether to run full outer join.
-
rname
(str
, default:'right_'
) –Name prefix for conflicting signal names.
Examples:
imgs.merge(captions,
on=func.path.file_stem(imgs.c("file.path")),
right_on=func.path.file_stem(captions.c("file.path"))
)
Source code in datachain/lib/dc.py
1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 |
|
min
min(fr: DataType)
mutate
Create new signals based on existing signals.
This method cannot modify existing columns. If you need to modify an
existing column, use a different name for the new column and then use
select()
to choose which columns to keep.
This method is vectorized and more efficient compared to map(), and it does not extract or download any data from the internal database. However, it can only utilize predefined built-in functions and their combinations.
The supported functions
Numerical: +, -, *, /, rand(), avg(), count(), func(), greatest(), least(), max(), min(), sum() String: length(), split(), replace(), regexp_replace() Filename: name(), parent(), file_stem(), file_ext() Array: length(), sip_hash_64(), euclidean_distance(), cosine_distance() Window: row_number(), rank(), dense_rank(), first()
Example:
dc.mutate(
area=Column("image.height") * Column("image.width"),
extension=file_ext(Column("file.name")),
dist=cosine_distance(embedding_text, embedding_image)
)
Window function example:
window = func.window(partition_by="file.parent", order_by="file.size")
dc.mutate(
row_number=func.row_number().over(window),
)
This method can be also used to rename signals. If the Column("name") provided as value for the new signal - the old column will be dropped. Otherwise a new column is created.
Example:
Source code in datachain/lib/dc.py
1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 |
|
offset
offset(offset: int) -> Self
Return the results starting with the offset row.
If the chain is unordered, which rows are skipped in undefined.
If the chain has less than offset
rows, the result is an empty chain.
Parameters:
-
offset
(int
) –Number of rows to skip.
Source code in datachain/lib/dc.py
order_by
order_by(*args, descending: bool = False) -> Self
Orders by specified set of columns.
Parameters:
-
descending
(bool
, default:False
) –Whether to sort in descending order or not.
Note
Order is not guaranteed when steps are added after an order_by
statement.
I.e. when using from_dataset
an order_by
statement should be used if
the order of the records in the chain is important.
Using order_by
directly before limit
, collect
and collect_flatten
will give expected results.
See https://github.com/iterative/datachain/issues/477 for further details.
Source code in datachain/lib/dc.py
parse_tabular
parse_tabular(
output: OutputType = None,
object_name: str = "",
model_name: str = "",
source: bool = True,
nrows: Optional[int] = None,
**kwargs
) -> Self
Generate chain from list of tabular files.
Parameters:
-
output
–Dictionary or feature class defining column names and their corresponding types. List of column names is also accepted, in which case types will be inferred.
-
object_name
–Generated object column name.
-
model_name
–Generated model name.
-
source
–Whether to include info about the source file.
-
nrows
–Optional row limit.
-
kwargs
–Parameters to pass to pyarrow.dataset.dataset.
Example
Reading a json lines file:
Reading a filtered list of files as a dataset:
Source code in datachain/lib/dc.py
1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 |
|
print_schema
reset_settings
reset_settings(settings: Optional[Settings] = None) -> Self
sample
Return a random sample from the chain.
Parameters:
-
n
(int
) –Number of samples to draw.
NOTE: Samples are not deterministic, and streamed/paginated queries or multiple workers will draw samples with replacement.
Source code in datachain/lib/dc.py
save
Save to a Dataset. It returns the chain itself.
Parameters:
-
name
–dataset name. Empty name saves to a temporary dataset that will be removed after process ends. Temp dataset are useful for optimization.
-
version
–version of a dataset. Default - the last version that exist.
Source code in datachain/lib/dc.py
select
Select only a specified set of signals.
Source code in datachain/lib/dc.py
select_except
select_except(*args: str) -> Self
Select all the signals expect the specified signals.
Source code in datachain/lib/dc.py
settings
settings(
cache=None,
parallel=None,
workers=None,
min_task_size=None,
prefetch: Optional[int] = None,
sys: Optional[bool] = None,
) -> Self
Change settings for chain.
This function changes specified settings without changing not specified ones. It returns chain, so, it can be chained later with next operation.
Parameters:
-
cache
–data caching (default=False)
-
parallel
–number of thread for processors. True is a special value to enable all available CPUs (default=1)
-
workers
–number of distributed workers. Only for Studio mode. (default=1)
-
min_task_size
–minimum number of tasks (default=1)
-
prefetch
(Optional[int]
, default:None
) –number of workers to use for downloading files in advance. This is enabled by default and uses 2 workers. To disable prefetching, set it to 0.
Example
Source code in datachain/lib/dc.py
setup
Setup variables to pass to UDF functions.
Use before running map/gen/agg/batch_map to save an object and pass it as an argument to the UDF.
Example
import anthropic
from anthropic.types import Message
(
DataChain.from_storage(DATA, type="text")
.settings(parallel=4, cache=True)
.setup(client=lambda: anthropic.Anthropic(api_key=API_KEY))
.map(
claude=lambda client, file: client.messages.create(
model=MODEL,
system=PROMPT,
messages=[{"role": "user", "content": file.get_value()}],
),
output=Message,
)
)
Source code in datachain/lib/dc.py
show
show(
limit: int = 20,
flatten=False,
transpose=False,
truncate=True,
) -> None
Show a preview of the chain results.
Parameters:
-
limit
–How many rows to show.
-
flatten
–Whether to use a multiindex or flatten column names.
-
transpose
–Whether to transpose rows and columns.
-
truncate
–Whether or not to truncate the contents of columns.
Source code in datachain/lib/dc.py
shuffle
subtract
subtract(
other: DataChain,
on: Optional[Union[str, Sequence[str]]] = None,
right_on: Optional[Union[str, Sequence[str]]] = None,
) -> Self
Remove rows that appear in another chain.
Parameters:
-
other
(DataChain
) –chain whose rows will be removed from
self
-
on
(Optional[Union[str, Sequence[str]]]
, default:None
) –columns to consider for determining row equality in
self
. If unspecified, defaults to all common columns betweenself
andother
. -
right_on
(Optional[Union[str, Sequence[str]]]
, default:None
) –columns to consider for determining row equality in
other
. If unspecified, defaults to the same values ason
.
Source code in datachain/lib/dc.py
1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 |
|
sum
sum(fr: DataType)
to_columnar_data_with_names
to_columnar_data_with_names(
chunk_size: int = DEFAULT_PARQUET_CHUNK_SIZE,
) -> tuple[list[str], Iterator[list[list[Any]]]]
Returns column names and the results as an iterator that provides chunks, with each chunk containing a list of columns, where each column contains a list of the row values for that column in that chunk. Useful for columnar data formats, such as parquet or other OLAP databases.
Source code in datachain/lib/dc.py
to_csv
to_csv(
path: Union[str, PathLike[str]],
delimiter: str = ",",
fs_kwargs: Optional[dict[str, Any]] = None,
**kwargs
) -> None
Save chain to a csv (comma-separated values) file.
Parameters:
-
path
–Path to save the file. This supports local paths as well as remote paths, such as s3:// or hf:// with fsspec.
-
delimiter
–Delimiter to use for the resulting file.
-
fs_kwargs
–Optional kwargs to pass to the fsspec filesystem, used only for write, for fsspec-type URLs, such as s3:// or hf:// when provided as the destination path.
Source code in datachain/lib/dc.py
to_json
to_json(
path: Union[str, PathLike[str]],
fs_kwargs: Optional[dict[str, Any]] = None,
include_outer_list: bool = True,
) -> None
Save chain to a JSON file.
Parameters:
-
path
–Path to save the file. This supports local paths as well as remote paths, such as s3:// or hf:// with fsspec.
-
fs_kwargs
–Optional kwargs to pass to the fsspec filesystem, used only for write, for fsspec-type URLs, such as s3:// or hf:// when provided as the destination path.
-
include_outer_list
–Sets whether to include an outer list for all rows. Setting this to True makes the file valid JSON, while False instead writes in the JSON lines format.
Source code in datachain/lib/dc.py
to_jsonl
Save chain to a JSON lines file.
Parameters:
-
path
–Path to save the file. This supports local paths as well as remote paths, such as s3:// or hf:// with fsspec.
-
fs_kwargs
–Optional kwargs to pass to the fsspec filesystem, used only for write, for fsspec-type URLs, such as s3:// or hf:// when provided as the destination path.
Source code in datachain/lib/dc.py
to_pandas
to_pandas(flatten=False) -> DataFrame
Return a pandas DataFrame from the chain.
Parameters:
-
flatten
–Whether to use a multiindex or flatten column names.
Source code in datachain/lib/dc.py
to_parquet
to_parquet(
path: Union[str, PathLike[str], BinaryIO],
partition_cols: Optional[Sequence[str]] = None,
chunk_size: int = DEFAULT_PARQUET_CHUNK_SIZE,
fs_kwargs: Optional[dict[str, Any]] = None,
**kwargs
) -> None
Save chain to parquet file with SignalSchema metadata.
Parameters:
-
path
–Path or a file-like binary object to save the file. This supports local paths as well as remote paths, such as s3:// or hf:// with fsspec.
-
partition_cols
–Column names by which to partition the dataset.
-
chunk_size
–The chunk size of results to read and convert to columnar data, to avoid running out of memory.
-
fs_kwargs
–Optional kwargs to pass to the fsspec filesystem, used only for write, for fsspec-type URLs, such as s3:// or hf:// when provided as the destination path.
Source code in datachain/lib/dc.py
2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 |
|
to_pytorch
to_pytorch(
transform=None,
tokenizer=None,
tokenizer_kwargs=None,
num_samples=0,
remove_prefetched: bool = False,
)
Convert to pytorch dataset format.
Parameters:
-
transform
(Transform
, default:None
) –Torchvision transforms to apply to the dataset.
-
tokenizer
(Callable
, default:None
) –Tokenizer to use to tokenize text values.
-
tokenizer_kwargs
(dict
, default:None
) –Additional kwargs to pass when calling tokenizer.
-
num_samples
(int
, default:0
) –Number of random samples to draw for each epoch. This argument is ignored if
num_samples=0
(the default). -
remove_prefetched
(bool
, default:False
) –Whether to remove prefetched files after reading.
Example
Source code in datachain/lib/dc.py
to_records
Convert every row to a dictionary.
to_storage
to_storage(
output: str,
signal: str = "file",
placement: ExportPlacement = "fullpath",
use_cache: bool = True,
link_type: Literal["copy", "symlink"] = "copy",
) -> None
Export files from a specified signal to a directory.
Parameters:
-
output
(str
) –Path to the target directory for exporting files.
-
signal
(str
, default:'file'
) –Name of the signal to export files from.
-
placement
(ExportPlacement
, default:'fullpath'
) –The method to use for naming exported files. The possible values are: "filename", "etag", "fullpath", and "checksum".
-
use_cache
(bool
, default:True
) –If
True
, cache the files before exporting. -
link_type
(Literal['copy', 'symlink']
, default:'copy'
) –Method to use for exporting files. Falls back to
'copy'
if symlinking fails.
Example
Cross cloud transfer
Source code in datachain/lib/dc.py
union
Return the set union of the two datasets.
Parameters:
-
other
(Self
) –chain whose rows will be added to
self
.
DataChainError
Session
Session(
name="",
catalog: Optional[Catalog] = None,
client_config: Optional[dict] = None,
in_memory: bool = False,
)
Session is a context that keeps track of temporary DataChain datasets for a proper cleanup. By default, a global session is created.
Temporary or ephemeral datasets are the ones created without specified name. They are useful for optimization purposes and should be automatically removed.
Temp dataset has specific name format
"session_
The
Temp dataset examples
session_myname_624b41_48e8b4 session_4b962d_2a5dff
Parameters:
name (str): The name of the session. Only latters and numbers are supported. It can be empty. catalog (Catalog): Catalog object.
Source code in datachain/query/session.py
get
classmethod
get(
session: Optional[Session] = None,
catalog: Optional[Catalog] = None,
client_config: Optional[dict] = None,
in_memory: bool = False,
) -> Session
Creates a Session() object from a catalog.
Parameters:
-
session
(Session
, default:None
) –Optional Session(). If not provided a new session will be created. It's needed mostly for simple API purposes.
-
catalog
(Catalog
, default:None
) –Optional catalog. By default, a new catalog is created.