API Reference

• patito.DataFrame
  • DataFrame
  • Methods
    • cast
      • DataFrame.cast()
    • derive
      • DataFrame.derive()
    • drop
      • DataFrame.drop()
    • fill_null
      • DataFrame.fill_null()
    • get
      • DataFrame.get()
    • read_csv
      • DataFrame.read_csv()
    • set_model
      • DataFrame.set_model()
    • validate
      • DataFrame.validate()
• patito.Model
  • Model
  • Class properties
    • DataFrame
      • Model.DataFrame()
    • LazyFrame
      • Model.LazyFrame()
    • columns
      • Model.columns
    • defaults
      • Model.defaults
    • dtypes
      • Model.dtypes
    • non_nullable_columns
      • Model.non_nullable_columns
    • nullable_columns
      • Model.nullable_columns
    • sql_types
      • Model.sql_types
    • unique_columns
      • Model.unique_columns
    • valid_dtypes
      • Model.valid_dtypes
    • valid_sql_types
      • Model.valid_sql_types
  • Class methods
    • drop
      • Model.drop()
    • example
      • Model.example()
    • example_value
      • Model.example_value()
    • examples
      • Model.examples()
    • from_row
      • Model.from_row()
    • join
      • Model.join()
    • pandas_examples
      • Model.pandas_examples()
    • prefix
      • Model.prefix()
    • rename
      • Model.rename()
    • select
      • Model.select()
    • suffix
      • Model.suffix()
    • validate
      • Model.validate()
    • with_fields
      • Model.with_fields()
• patito.Field
  • Field

DuckDB Functionality

• patito.Database
  • Database.__init__()
  • Methods
    • create_enum_types
      • Database.create_enum_types()
    • create_table
      • Database.create_table()
    • create_view
      • Database.create_view()
    • default
      • Database.default()
    • empty_relation
      • Database.empty_relation()
    • execute
      • Database.execute()
    • from_connection
      • Database.from_connection()
    • query
      • Database.query()
    • table
      • Database.table()
    • to_relation
      • Database.to_relation()
    • __contains__
      • Database.__contains__()
• patito.Relation
  • Relation.__init__()
  • Properties
    • alias
    • columns
      • Relation.columns
    • model
    • types
      • Relation.types
  • Methods
    • add_prefix
      • Relation.add_prefix()
    • add_suffix
      • Relation.add_suffix()
    • aggregate
      • Relation.aggregate()
    • all
      • Relation.all()
    • case
      • Relation.case()
    • cast
      • Relation.cast()
    • coalesce
      • Relation.coalesce()
    • count
      • Relation.count()
    • create_table
      • Relation.create_table()
    • create_view
      • Relation.create_view()
    • distinct
      • Relation.distinct()
    • drop
      • Relation.drop()
    • except_
      • Relation.except_()
    • execute
      • Relation.execute()
    • filter
      • Relation.filter()
    • get
      • Relation.get()
    • inner_join
      • Relation.inner_join()
    • insert_into
      • Relation.insert_into()
    • intersect
      • Relation.intersect()
    • join
      • Relation.join()
    • left_join
      • Relation.left_join()
    • limit
      • Relation.limit()
    • order
      • Relation.order()
    • select
      • Relation.select()
    • rename
      • Relation.rename()
    • set_alias
      • Relation.set_alias()
    • set_model
      • Relation.set_model()
    • to_df
      • Relation.to_df()
    • to_pandas
      • Relation.to_pandas()
    • to_series
      • Relation.to_series()
    • union
      • Relation.union()
    • with_columns
      • Relation.with_columns()
    • with_missing_defaultable_columns
      • Relation.with_missing_defaultable_columns()
    • with_missing_nullable_columns
      • Relation.with_missing_nullable_columns()
    • __add__
      • Relation.__add__()
    • __getitem__
      • Relation.__getitem__()
    • __iter__
      • Relation.__iter__()
    • __len__
      • Relation.__len__()
    • __str__
      • Relation.__str__()