Skip to main content
Version: 1.15.2

PandasFilesystemDatasource

Signature

class great_expectations.datasource.fluent.PandasFilesystemDatasource(
 *,
 type: Literal['pandas_filesystem'] = 'pandas_filesystem',
 name: str,
 id: Optional[uuid.UUID] = None,
 assets: List[great_expectations.datasource.fluent.data_asset.path.file_asset.FileDataAsset] = [],
 base_directory: pathlib.Path,
 data_context_root_directory: Optional[pathlib.Path] = None
)

Pandas based Datasource for filesystem based data assets.

Methods

add_csv_asset

Signature

add_csv_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945b929c0> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945b92a80> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945b92bd0> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945b92cc0> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945b92ff0> = None,
 sep: typing.Optional[str] = None,
 delimiter: typing.Optional[str] = None,
 header: Union[int,
 Sequence[int],
 None,
 Literal['infer']] = 'infer',
 names: Union[Sequence[str],
 None] = None,
 index_col: Union[IndexLabel,
 Literal[False],
 None] = None,
 usecols: typing.Optional[typing.Union[int,
 str,
 typing.Sequence[int]]] = None,
 dtype: typing.Optional[dict] = None,
 engine: Union[CSVEngine,
 None] = None,
 true_values: typing.Optional[typing.List] = None,
 false_values: typing.Optional[typing.List] = None,
 skipinitialspace: bool = False,
 skiprows: typing.Optional[typing.Union[typing.Sequence[int],
 int]] = None,
 skipfooter: int = 0,
 nrows: typing.Optional[int] = None,
 na_values: Union[str,
 Iterable[str],
 None] = None,
 keep_default_na: bool = True,
 na_filter: bool = True,
 skip_blank_lines: bool = True,
 parse_dates: Union[bool,
 Sequence[str],
 None] = None,
 date_format: typing.Optional[str] = None,
 dayfirst: bool = False,
 cache_dates: bool = True,
 iterator: bool = False,
 chunksize: typing.Optional[int] = None,
 compression: CompressionOptions = 'infer',
 thousands: typing.Optional[str] = None,
 decimal: str = '.',
 lineterminator: typing.Optional[str] = None,
 quotechar: str = '"',
 quoting: int = 0,
 doublequote: bool = True,
 escapechar: typing.Optional[str] = None,
 comment: typing.Optional[str] = None,
 encoding: typing.Optional[str] = None,
 encoding_errors: typing.Optional[str] = 'strict',
 dialect: typing.Optional[str] = None,
 on_bad_lines: str = 'error',
 low_memory: bool = True,
 memory_map: bool = False,
 storage_options: Union[StorageOptions,
 None] = None,
 dtype_backend: DtypeBackend = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a csv asset to the datasource.

add_excel_asset

Signature

add_excel_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945a48230> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945a48770> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945a49250> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945a48ad0> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945a48b90> = None,
 sheet_name: typing.Optional[typing.Union[str,
 int,
 typing.List[typing.Union[int,
 str]]]] = 0,
 header: Union[int,
 Sequence[int],
 None] = 0,
 index_col: Union[int,
 str,
 Sequence[int],
 None] = None,
 usecols: typing.Optional[typing.Union[int,
 str,
 typing.Sequence[int]]] = None,
 dtype: typing.Optional[dict] = None,
 true_values: Union[Iterable[str],
 None] = None,
 false_values: Union[Iterable[str],
 None] = None,
 skiprows: typing.Optional[typing.Union[typing.Sequence[int],
 int]] = None,
 nrows: typing.Optional[int] = None,
 na_values: typing.Any = None,
 keep_default_na: bool = True,
 na_filter: bool = True,
 verbose: bool = False,
 parse_dates: typing.Union[typing.List,
 typing.Dict,
 bool] = False,
 date_format: typing.Optional[str] = None,
 thousands: typing.Optional[str] = None,
 decimal: str = '.',
 comment: typing.Optional[str] = None,
 skipfooter: int = 0,
 storage_options: Union[StorageOptions,
 None] = None,
 dtype_backend: DtypeBackend = None,
 engine_kwargs: typing.Optional[typing.Dict] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add an excel asset to the datasource.

add_feather_asset

Signature

add_feather_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945a49f10> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945a4a030> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945a4a180> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945a4a330> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945a4a3f0> = None,
 columns: Union[Sequence[str],
 None] = None,
 use_threads: bool = True,
 storage_options: Union[StorageOptions,
 None] = None,
 dtype_backend: DtypeBackend = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a feather asset to the datasource.

add_fwf_asset

Signature

add_fwf_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945a4ab40> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945a4ac00> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945a4ad50> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945a4af00> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945a4afc0> = None,
 colspecs: Union[Sequence[Tuple[int,
 int]],
 str,
 None] = 'infer',
 widths: Union[Sequence[int],
 None] = None,
 infer_nrows: int = 100,
 iterator: bool = False,
 chunksize: typing.Optional[int] = None,
 kwargs: typing.Optional[dict] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a fwf asset to the datasource.

add_hdf_asset

Signature

add_hdf_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945a4b830> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945a4b8f0> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945a4ba40> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945a4bbf0> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945a4bcb0> = None,
 key: typing.Any = None,
 mode: str = 'r',
 errors: str = 'strict',
 where: typing.Optional[typing.Union[str,
 typing.List]] = None,
 start: typing.Optional[int] = None,
 stop: typing.Optional[int] = None,
 columns: typing.Optional[typing.List[str]] = None,
 iterator: bool = False,
 chunksize: typing.Optional[int] = None,
 kwargs: typing.Optional[dict] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a hdf asset to the datasource.

add_html_asset

Signature

add_html_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945ab44d0> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945ab4590> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945ab46e0> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945ab4890> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945ab4950> = None,
 match: Union[str,
 Pattern] = '.+',
 header: Union[int,
 Sequence[int],
 None] = None,
 index_col: Union[int,
 Sequence[int],
 None] = None,
 skiprows: typing.Optional[typing.Union[typing.Sequence[int],
 int]] = None,
 attrs: typing.Optional[typing.Dict[str,
 str]] = None,
 parse_dates: bool = False,
 thousands: typing.Optional[str] = ',
',
 encoding: typing.Optional[str] = None,
 decimal: str = '.',
 converters: typing.Optional[typing.Dict] = None,
 na_values: Union[Iterable[object],
 None] = None,
 keep_default_na: bool = True,
 displayed_only: bool = True,
 dtype_backend: DtypeBackend = None,
 storage_options: StorageOptions = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a html asset to the datasource.

add_iceberg_asset

Signature

add_iceberg_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945ab5580> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945ab5640> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945ab5790> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945ab5940> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945ab5a00> = None,
 catalog_name: str | None = None,
 catalog_properties: dict[str,
 typing.Any] | None = None,
 columns: list[str] | None = None,
 row_filter: str | None = None,
 case_sensitive: bool = True,
 snapshot_id: int | None = None,
 limit: int | None = None,
 scan_properties: dict[str,
 typing.Any] | None = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add an iceberg asset to the datasource.

add_json_asset

Signature

add_json_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945ab61e0> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945ab62a0> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945ab63f0> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945ab65a0> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945ab6660> = None,
 orient: typing.Optional[str] = None,
 typ: Literal['frame',
 'series'] = 'frame',
 dtype: typing.Optional[dict] = None,
 convert_axes: typing.Optional[bool] = None,
 convert_dates: typing.Union[bool,
 typing.List[str]] = True,
 keep_default_dates: bool = True,
 precise_float: bool = False,
 date_unit: typing.Optional[str] = None,
 encoding: typing.Optional[str] = None,
 encoding_errors: typing.Optional[str] = 'strict',
 lines: bool = False,
 chunksize: typing.Optional[int] = None,
 compression: CompressionOptions = 'infer',
 nrows: typing.Optional[int] = None,
 storage_options: Union[StorageOptions,
 None] = None,
 dtype_backend: DtypeBackend = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a json asset to the datasource.

add_orc_asset

Signature

add_orc_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945ab71d0> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945ab7290> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945ab73e0> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945ab7590> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945ab7650> = None,
 columns: typing.Optional[typing.List[str]] = None,
 dtype_backend: DtypeBackend = None,
 kwargs: typing.Optional[dict] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add an orc asset to the datasource.

add_parquet_asset

Signature

add_parquet_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945ab7da0> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945ab7e60> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945ab7fb0> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945ae81a0> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945ae8260> = None,
 engine: str = 'auto',
 columns: typing.Optional[typing.List[str]] = None,
 storage_options: Union[StorageOptions,
 None] = None,
 dtype_backend: DtypeBackend = None,
 to_pandas_kwargs: typing.Optional[typing.Dict] = None,
 kwargs: typing.Optional[dict] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a parquet asset to the datasource.

add_pickle_asset

Signature

add_pickle_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945ae8a10> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945ae8ad0> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945ae8c20> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945ae8dd0> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945ae8e90> = None,
 compression: CompressionOptions = 'infer',
 storage_options: Union[StorageOptions,
 None] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a pickle asset to the datasource.

add_sas_asset

Signature

add_sas_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945ae9580> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945ae9640> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945ae9790> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945ae9940> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945ae9a00> = None,
 format: typing.Optional[str] = None,
 index: typing.Optional[str] = None,
 encoding: typing.Optional[str] = None,
 chunksize: typing.Optional[int] = None,
 iterator: bool = False,
 compression: CompressionOptions = 'infer',
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a sas asset to the datasource.

add_spss_asset

Signature

add_spss_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945aea1b0> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945aea270> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945aea3c0> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945aea570> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945aea630> = None,
 usecols: typing.Optional[typing.Union[int,
 str,
 typing.Sequence[int]]] = None,
 convert_categoricals: bool = True,
 dtype_backend: DtypeBackend = None,
 kwargs: typing.Optional[dict] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a spss asset to the datasource.

add_stata_asset

Signature

add_stata_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945aeae40> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945aeaf00> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945aeb050> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945aeb200> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945aeb2c0> = None,
 convert_dates: bool = True,
 convert_categoricals: bool = True,
 index_col: typing.Optional[str] = None,
 convert_missing: bool = False,
 preserve_dtypes: bool = True,
 columns: Union[Sequence[str],
 None] = None,
 order_categoricals: bool = True,
 chunksize: typing.Optional[int] = None,
 iterator: bool = False,
 compression: CompressionOptions = 'infer',
 storage_options: Union[StorageOptions,
 None] = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a stata asset to the datasource.

add_xml_asset

Signature

add_xml_asset(
 name: str,
 *,
 id: <pydantic.v1.fields.DeferredType object at 0x7fb945aebbc0> = None,
 order_by: <pydantic.v1.fields.DeferredType object at 0x7fb945aebc80> = None,
 batch_metadata: <pydantic.v1.fields.DeferredType object at 0x7fb945aebdd0> = None,
 batch_definitions: <pydantic.v1.fields.DeferredType object at 0x7fb945aebf80> = None,
 connect_options: <pydantic.v1.fields.DeferredType object at 0x7fb945b10080> = None,
 xpath: str = './*',
 namespaces: typing.Optional[typing.Dict[str,
 str]] = None,
 elems_only: bool = False,
 attrs_only: bool = False,
 names: Union[Sequence[str],
 None] = None,
 dtype: typing.Optional[dict] = None,
 encoding: typing.Optional[str] = 'utf-8',
 stylesheet: Union[FilePath,
 None] = None,
 iterparse: typing.Optional[typing.Dict[str,
 typing.List[str]]] = None,
 compression: CompressionOptions = 'infer',
 storage_options: Union[StorageOptions,
 None] = None,
 dtype_backend: DtypeBackend = None,
 **extra_data: typing.Any
) → pydantic.BaseModel

Add a xml asset to the datasource.

delete_asset

Signature

delete_asset(
 name: str
) → None

Removes the DataAsset referred to by asset_name from internal list of available DataAsset objects.

Parameters

NameDescription

name

name of DataAsset to be deleted.

get_asset

Signature

get_asset(
 name: str
) → great_expectations.datasource.fluent.interfaces._DataAssetT

Returns the DataAsset referred to by asset_name

Parameters

NameDescription

name

name of DataAsset sought.

Returns

TypeDescription

great_expectations.datasource.fluent.interfaces._DataAssetT

if named "DataAsset" object exists; otherwise, exception is raised.