v1.13.1 - 2024-05-16

This release fixes the ModuleNotFoundError error that was causing the 1.13.0 release to fail.

v1.13.0 - 2024-05-15

This release adds a utility function called get_random_subset that helps users get a subset of their multi-table data so that modeling can be done quicker. Given a dictionary of table names mapped to DataFrames, metadata, a main table and a desired number of rows to use for the main table, it will subsample the data in a way that maintains referential integrity.

This release also adds two new local file handlers: the CSVHandler and the ExcelHandler. This enables users to easily load from and save synthetic data to these files types. These handlers return data and metadata in the multi-table format, so we also added the function get_table_metadata to get a SingleTableMetadata object from a MultiTableMetadata object.

Finally, this release fixes some bugs that prevented synthesizers from working with data that had numerical column names.

New Features

• Add get_random_subset poc utility function - Issue #1877 by @R-Palazzo
• Add usage logging - Issue #1903 by @pvk-developer
• Move function drop_unknown_references from poc to be directly under utils - Issue #1947 by @R-Palazzo
• Add CSVHandler - Issue #1949 by @pvk-developer
• Add ExcelHandler - Issue #1950 by @pvk-developer
• Add get_table_metadata function - Issue #1951 by @R-Palazzo
• Save usage log file as a csv - Issue #1974 by @frances-h
• Split out metadata creation from data import in the local files handlers - Issue #1975 by @pvk-developer
• Improve error message when trying to sample before fitting (single table) - Issue #1978 by @R-Palazzo

Bugs Fixed

• Metadata detection crashes when the column names are integers (AttributeError: 'int' object has no attribute 'lower') - Issue #1933 by @lajohn4747
• Synthesizers crash when column names are integers (TypeError: unsupported operand) - Issue #1935 by @lajohn4747
• Switch parameter order in drop_unknown_references - Issue #1944 by @R-Palazzo
• Unexpected NaN values in sequence_index when dataframe isn't reset - Issue #1973 by @fealho
• Fix pandas DtypeWarning in download_demo - Issue #1980 by @fealho

Maintenance

• Only run unit and integration tests on oldest and latest python versions for macos - Issue #1948 by @frances-h

Internal

• Update code to remove FutureWarning related to 'enforce_uniqueness' parameter - Issue #1995 by @pvk-developer

v1.12.1 - 2024-04-19

This release makes a number of changes to how id columns are generated. By default, id columns with a regex will now have their values scrambled in the output. Id columns without a regex that are numeric will be created randomly. If they're not numeric, they will have a random suffix.

Additionally, improvements were made to the visibility of the get_loss_values_plot.

New Features

• Create unique id for each synthesizer - Issue #1902 by @pvk-developer
• Generator Discriminator Loss Chart Color Change - Issue #1916 by @lajohn4747
• If using regex to generate values, scramble them - Issue #1921 by @amontanez24
• When generating ids without a regex, create them randomly - Issue #1922 by @frances-h

Maintenance

• Cleanup automated PR workflows - Issue #1926 by @R-Palazzo

Internal

• Add add-on modules to sys.modules - Issue #1924 by @amontanez24

v1.12.0 - 2024-04-16

This release adds support for Python 3.12! It also adds a number of feature improvements. It adds a simplify_schema utility function to the sdv.utils.poc module which simplifies multi-table schemas so they can be run using HMASynthesizer. Multi-table data dictionaries can now be saved directly to CSVs using the sdv.datasets.local.save_csvs utility function. Additionally, generator-discriminator loss values can now be plotted directly from CTGAN using the get_loss_values_plot method. This release also adds error messages when trying to load an SDV synthesizer on an older version of the SDV, or when trying to re-fit a synthesizer from an older version of the SDV.

This release also fixes a number of bugs. Metadata auto-detection now validates that all primary keys are unique, and the metadata correctly validates sdtypes in a column relationship. Bugs in the HMASynthesizer that would cause the diagnostic score to not be equal to 1.0 for cardinality and data validity were fixed. Finally, errors in constraints now correctly raise a ConstraintsNotMetError instead of an InvalidData error.

New Features

• sdv helper function for generating generator-discriminator loss charts - Issue #1828 by @lajohn4747
• Add utility function to simplify multi-table schemas - Issue #1832 by @R-Palazzo
• Show an error if I accidentally load an SDV synthesizer on an older version of SDV - Issue #1837 by @pvk-developer
• Show an error when attempting to re-train a synthesizer that was created on a previous SDV version - Issue #1838 by @pvk-developer
• Add warning when user tries to train a model using datetime values without a datetime_format set - Issue #1847 by @pvk-developer
• Add a function to save my multi-table data as CSVs - Issue #1849 by @R-Palazzo
• Deprecate SingleTablePreset (including FastML Preset) - Issue #1855 by @lajohn4747
• Missing error message if the user forgets to add a sequence_key when using PARSynthesizer - Issue #1883 by @frances-h

Internal

• Add dependency checker - Issue #1818 by @frances-h

Bugs Fixed

• Metadata isn't validating sdtypes in a column relationship (public SDV only) - Issue #1781 by @R-Palazzo
• Contextual Anonymization transformers shouldn't be used for primary keys - Issue #1807 by @fealho
• HMASynthesizer diagnostic score is not 1.0 when using 'truncnorm' distribution - Issue #1831 by @frances-h
• InvalidDataError: The provided data does not match the metadata (although it matches) - Issue #1833 by @pvk-developer
• HMA likelihood match should respect cardinality - Issue #1834 by @fealho
• When inappropriately applying ScalarRange constraint, InvalidDataError is being returned instead of ConstraintsNotMetError - Issue #1842 by @pvk-developer
• When inappropriately applying a CustomConstraint, an InvalidDataError is being returned instead of ConstraintsNotMetError - Issue #1856 by @pvk-developer
• Error in Setting IDGenerator for Primary Key columns - Issue #1862 by @lajohn4747
• Metadata auto-detection should ensure primary keys are unique (special sdtypes are not exempt from this rule!) - Issue #1871 by @R-Palazzo

Maintenance

• Support Python 3.12 - Issue #1704 by @fealho
• Add dependency checker - Issue #1818 by @frances-h
• Add bandit workflow - Issue #1881 by @amontanez24

v1.11.0 - 2024-03-21

This release adds the poc utility submodule to help users more easily create a proof-of-concept with multi-table datasets. The poc submodule includes the drop_unknown_references utility function to automatically drop unknown references in a multi-table dataset. Additionally, multiple columns in the metadata can now be updated at once using the update_columns and update_columns_metadata methods. The SDV now also warns users when a synthesizer is loaded that was fitted on a different version of the SDV.

New Features

• Make the get_parameters function consistent between synthesizers - Issue #1756 by @fealho
• Reinstate get_table_parameters for the multi-table synthesizers - Issue #1757 by @fealho
• Validate condition and provide user-friendly messages for NaN/missing values (currently unsupported) - Issue #1758 by @fealho
• Improved error message if a column is already present in a relationship - Issue #1770 by @R-Palazzo
• Better error messaging for nullable foreign keys - Issue #1780 by @fealho
• Add a utility to drop unknown references (and enforce referential integrity) - Issue #1792 by @R-Palazzo
• Add update_columns and update_columns_metadata methods to metadata - Issue #1804 by @R-Palazzo
• Add get_column_names method to metadata - Issue #1805 by @frances-h
• Show original error message when plugin fails to load - Issue #1816 by @rwedge
• Show warning when loading a synthesizer on a previously-saved SDV version - Issue #1836 by @pvk-developer
• Add verbosity to drop_unknown_references - Issue #1845 by @R-Palazzo
• Create a poc module for utilities that help with proof-of-concept - Issue #1846 by @pvk-developer

Internal

• Cleanup utils module: Make internal functions private - Issue #1793 by @R-Palazzo
• Transition from using setup.py to pyroject.toml to specify project metadata - Issue #1801 by @R-Palazzo
• Remove bumpversion and use bump-my-version - Issue #1802 by @R-Palazzo

Maintenance

• Transition from using setup.py to pyroject.toml to specify project metadata - Issue #1801 by @R-Palazzo
• Remove bumpversion and use bump-my-version - Issue #1802 by @R-Palazzo
• Add support for RDT 1.10.0 - Issue #1850 by @amontanez24

Bugs Fixed

• INFO logs mention table name as None for single table data - Issue #1814 by @lajohn4747
• Fix drop_unknown_references for null foreign keys - Issue #1820 by @R-Palazzo

v1.10.0 - 2024-02-15

This release adds multiple improvements to handling premium transformers and column relationships, including using premium transformers even if the PII flag is set to true. Additionally, the SDV now warns users to save the metadata after auto-detection has been used. Semantic sdtype detection has also been improved to tokenize column names to prevent unexpected substring matches.

This release also fixes a few warning bugs and fixes an issue that would cause metadata.to_dict to fail for metadata loaded from older versions of the SDV. A few synthesizer bugs were also resolved. The quality of the sequence_index for the PARSynthesizer has been improved, and an issue that would cause CTGANSynthesizer, TVAESynthesizer, and CopulaGANSynthesizer to crash if all columns were to be generated from scratch has been fixed.

Bugs Fixed

• HMASynthesizer sometimes creates null values (out-of-bounds parameters synthesized) - Issue #1691 by @fealho
• Unable to conditionally sample some rows when using a ScalarRange constraint - Issue #1737 by @fealho
• Metadata.to_dict fails on metadata instances pre 1.9.0 - Issue #1739 by @amontanez24
• Metadata auto-detection should not assign a primary key if there are NaN values in it - Issue #1740 by @R-Palazzo
• '' object has no attribute '_model' - Issue #1741 by @fealho
• Column relationship warning should be raised during synthesizer initialization only - Issue #1750 by @R-Palazzo
• Improve quality of sequence_index: Move the start dates into the context model - Issue #1760 by @frances-h
• Add-ons warning is raised twice for multi table synthesizers. - Issue #1768 by @R-Palazzo

New Features

• Metadata auto-detection should tokenize words before determining PII - Issue #1725 by @fealho
• Provide a friendlier error if data is stored as dtype 'category' (CTGAN, TVAE) - Issue #1735 by @frances-h
• Allow the ability to easily remove primary keys - Issue #1742 by @frances-h
• Constraint should not be set on columns inside a gps relationship - Issue #1748 by @R-Palazzo
• Set the default transformer for GPS column relationship - Issue #1749 by @R-Palazzo
• Add a version module to align with SDV Enterprise - Issue #1761 by @R-Palazzo
• Warn users to save their metadata file after auto-detecting/updating it - Issue #1762 by @R-Palazzo
• Set the GPSNoiser as default transformer for GPS column relationship - Issue #1767 by @R-Palazzo
• Update transformer assignment logic for handling pii - Issue #1775 by @R-Palazzo

v1.9.0 - 2024-01-11

This release makes a number of improvements. It introduces a new concept to the metadata known as column relationships! Column relationships can be used to define when certain groups of columns in a table should be treated as a special concept (eg. address). You can add a column relationship by using the new add_column_relationship method. The metadata detection was also improved by allowing semantic sdtypes (eg. 'email', 'phone_number') to be detected as primary keys.

This release also patches some bugs. An issue messing up the likelihood matching in the HMASynthesizer was resolved. The CTGANSynthesizer no longer fails when using the FixedCombinations constraint. The Inequality constraint was also patched to handle datetimes better.

Deprecations

• The set_address_columns method is deprecated in favor of add_column_relationship.

New Features

• Improve error messages for composite keys - Issue #1684 by @frances-h
• Add column relationship validation to single table metadata - Issue #1698 by @frances-h
• Add add_column_relationship method to single table metadata - Issue #1699 by @frances-h
• Make synthesizers work with column_relationships - Issue #1700 by @R-Palazzo
• Metadata auto-detection should find primary keys of semantic sdtypes - Issue #1724 by @fealho

Bugs Fixed

• InvalidDataError for Inequality constraint (even though data is valid) - Issue #1692 by @fealho
• BaseIndependentSampler crashes because it tries to cast id columns - Issue #1712 by @pvk-developer
• KeyError in CTGANSynthesizer when applying FixedCombinations constraint - Issue #1717 by @pvk-developer
• Fix _get_likelihoods not generating likelihood values - Issue #1720 by @frances-h

v1.8.0 - 2023-12-05

This release adds support for the new Diagnostic Report from SDMetrics. This report calculates scores for three basic but important properties of your data: data validity, data structure and in the multi table case, relationship validity. Data validity checks that the columns of your data are valid (eg. correct range or values). Data structure makes sure the synthetic data has the correct columns. Relationship validity checks to make sure key references are correct and the cardinality is within ranges seen in the real data.

Additionally, a few bugs were fixed and functionality was improved around synthesizers. It is now possible to access the loss values for the TVAESynthesizer and CTGANSynthesizer by using the get_loss_values method. The get_parameters method is now more detailed and returns all the parameters used to make a synthesizer. The metadata is now capable of detecting some common pii sdtypes. Finally, a bug that made every parent row generated by the HMASynthesizer have at least one child row was patched. This should improve cardinality.

Maintenance

• Address SettingWithCopyWarning (HMASynthesizer) - Issue #1557 by @pvk-developer
• Bump SDMetrics version - Issue #1702 by @amontanez24

New Features

• Allow me to access loss values for GAN-based synthesizers - Issue #1671 by @frances-h
• Create a unified get_parameters method for all multi-table synthesizers - Issue #1674 by @frances-h
• Set credentials key as variables - Issue #1680 by @R-Palazzo
• Identifying PII Sdtypes in Metadata - Issue #1683 by @R-Palazzo
• Make SDV compatible with the latest SDMetrics - Issue #1687 by @fealho
• SingleTablePreset uses FrequencyEncoder - Issue #1695 by @fealho

Bugs Fixed

• HMASynthesizer creates too much synthetic data (always creates a child for every parent row) - Issue #1673 by @frances-h

v1.7.0 - 2023-11-16

This release adds an alert to the CTGANSynthesizer during preprocessing. The alert informs the user if the fitting of the synthesizer is likely to be slow on their schema. Additionally, it is now possible to enforce that sampled datetime values stay within the range of the fitted data!

This release also makes internal changes to support address data in SDV Enterprise.

New Features

• Add set_address_columns method - Issue #1593 by @R-Palazzo
• Update_transformers should raise error on address columns - Issue #1594 by @R-Palazzo
• add_constraints should raise error on address columns - Issue #1595 by @R-Palazzo
• Print alert if CTGANSynthesizer is likely to be slow - Issue #1658 by @fealho
• Set enforce_min_max_values to True for datetime transformers - Issue #1676 by @R-Palazzo

Bugs Fixed

• Unable to visualize metadata (Error: bad label format and CalledProcessError) - Issue #1625 by @fealho
• Can't set address columns after fitting - Issue #1661 by @R-Palazzo

v1.6.0 - 2023-11-07

This release improves user messaging in multiple ways. The most notable is that users will now see an alert if the HMASynthesizer is likely to be slow for their data's schema. Additionally, the logger messaging for constraints and the error messaging when setting distributions on non-parametric models was made more detailed.

The visualization plots in the sdv.evaluation sub-package all got a new parameter called plot_type, allowing the users to specify the plot type to use if the one being inferred is not useful. The sdv.datasets.local.load_csvs method now has a parameter called read_csv_parameters, that allow users to specify how the csvs should be read during loading. The same change was also made to the sdv.metadata.multi_table.detect_table_from_csv, sdv.metadata.multi_table.detect_from_csvs and sdv.metadata.single_table.detect_from_csv methods.

Multiple bugs were resolved including one that caused new categories to be created during the sample step of CTGANSynthesizer.

New Features

• Improve debug messages when a constraint falls back to reject sampling approach - Issue #1478 by @amontanez24
• Constraints should work with timezone-aware datetime columns - Issue #1576 by @fealho
• Better error message when trying to get distributions from non-parametric models - PR #1633 by @frances-h
• Add options to read CSV files - Issue #1644 by @lajohn4747
• Print alert if HMASynthesizer is likely to be slow - Issue #1646 by @lajohn4747
• Make SDV compatible with SDMetrics 0.12.1 - Issue #1650 by @pvk-developer
• Make function to estimate number of columns CTGAN produces - Issue #1657 by @fealho

Bugs Fixed

• In get_available_demos, the num_tables column should be an int - Issue #1420 by @lajohn4747
• AttributeError when using specific locale strings (es_AR, fr_BE) - Issue #1439 by @lajohn4747
• Confusing error when passing in an empty dataframe (with constraints) - Issue #1455 by @lajohn4747
• HMASynthesizer: Better error message for learned distributions (misleading fit error) - Issue #1579 by @fealho
• Fix tests in SDV after update in RDT 1.7.1 - Issue #1638 by @lajohn4747
• CTGAN sometimes creates new categories (int data) - Issue #1647 by @pvk-developer
• CTGAN sometimes creates new categories (object data) - Issue #1648 by @pvk-developer
• Better error message if I provide an incompatible sdtype/locale combo - Issue #1653 by @pvk-developer