Highlight
It was supposed to only be some improvements and bug fixes over 0.1.5, but ended up getting much better --- Data Formulator now supports working with multiple tables! 🔥🔥🔥
When you add multiple tables to Data Formulator, you can select which base tables Data Formulator will use to derive the data (in the chart builder). This means Data Formulator can flexibly decide how to join or combine multiple tables together to create a visualization or answer your question.
In this demo below, we have a datasets of UK wheats production.
- To visualize wheats production by UK monarch, we can load a second table (here I ask GPT-4o to generate the table out of nowhere since it has knowledge about history :)).
- Then, we can drag a field from the second table to indicate that we want Data Formulator to leverage both tables to generate the chart, and it does.
- In the second demo, we can manually tell Data Formulator needs to consider both tables to answer "average wheat production per monarch", and it will also join the two tables for create the answer.
https://github.com/user-attachments/assets/b0d64bfa-13b0-4a79-8325-f42b90017842
<img width="1917" alt="image" src="https://github.com/user-attachments/assets/bb651ee3-82d1-47af-aef3-5d45d1c38150" />
Besides this feature, we have improved and fixed various UI and model selection issues from the community, thanks everyone for your suggestions! Let us know what you would like to see in Data Formulator next. :)
What's Changed
* Add and manipulate multiple table (dev) by noless3011 in https://github.com/microsoft/data-formulator/pull/89
* Dev: multi-table support & fixes by Chenglong-MS in https://github.com/microsoft/data-formulator/pull/99
* Bump vega from 5.23.0 to 5.26.0 by dependabot in https://github.com/microsoft/data-formulator/pull/95
New Contributors
* noless3011 made their first contribution in https://github.com/microsoft/data-formulator/pull/89
**Full Changelog**: https://github.com/microsoft/data-formulator/compare/0.1.5.1...0.1.6