Optimized Feature Generation for Tabular Data via LLMs with Decision Tree Reasoning

In tabular prediction tasks, tree-based models combined with automated feature engineering methods often outperform deep learning approaches that rely on learned representations. While these feature engineering techniques are effective, they typically depend on a pre-defined search space and primarily use validation scores for feature selection, thereby missing valuable insights from previous experiments. To address these limitations, we propose a novel tabular learning framework that utilizes large language models (LLMs), termed Optimizing Column feature generator with decision Tree reasoning (OCTree). Our key idea is to leverage the reasoning capabilities of LLMs to identify effective feature generation rules without manually specifying the search space and provide language-based reasoning information highlighting past experiments as feedback for iterative rule improvements. We use decision trees to convey this reasoning information, as they can be easily represented in natural language, effectively providing knowledge from prior experiments (i.e., the impact of the generated features on performance) to the LLMs. Our empirical results demonstrate that OCTree consistently enhances the performance of various prediction models across diverse benchmarks, outperforming competing automated feature engineering methods. Code is available at https://github.com/jaehyun513/OCTree.

Paper

References (49)

Scroll for more · 37 remaining

Similar papers

Peer review

Reviewer 8DXj4/10 · confidence 4/52024-07-04

Summary

The paper introduces OCTree, a framework that uses LLMs to generate and refine feature generation rules for tabular data. By incorporating decision tree reasoning, OCTree iteratively improves feature generation using feedback from past experiments. The framework enhances the performance of some prediction models, including decision trees and neural networks, and demonstrates improvements on real-world datasets. OCTree works with datasets with or without language descriptions and outperforms existing feature engineering methods, showing flexibility in feature generation for prediction tasks.

Strengths

The paper combines LLMs with decision tree reasoning to generate features for tabular data, offering a novel approach to feature generation. The paper demonstrates improvements through several experiments, and its flexible framework shows potential benefits in enhancing model performance. The paper is well-structured and clearly written.

Weaknesses

1. The framework is costly and time-consuming due to the need for training new models for validation during each iteration, and it involves some manual operations, preventing full automation. 2. Lack of comparisons of training times makes it difficult to assess the efficiency relative to other approaches. 3. The experiments are limited to datasets with a maximum of 54 features, lacking evidence of effectiveness on high-dimensional data (e.g., datasets with hundreds of features). 4. Datasets are sampled to sizes smaller than 50,000 instances, raising concerns about effectiveness and scalability on larger datasets.

Questions

1. Are there other works that use LLMs for feature generation? If so, how does this approach differ from them? 2. What is the time cost associated with OCTree? How much slower is it compared to directly training XGBoost? Does the time cost increase significantly with the size of the dataset and the feature dimensionality?

Rating

4

Confidence

4

Soundness

2

Presentation

3

Contribution

2

Limitations

N/A

Reviewer 245r3/10 · confidence 3/52024-07-10

Summary

The authors propose an automatic feature engineering method called OCTree. The OCTree algorithm uses LLMs to generate new features. The feature is then used in the training of the black box, and the new validation score is stored. The algorithm uses a decision tree to learn rules that show the reasoning behind selecting these new features and incorporate this in an iterative process. NOTE: If the authors address the issues I have raised in limitations and answer my questions, I will improve my score.

Strengths

The paper's research question, automatic feature engineering, is an important area of machine learning research that has not gained enough attention.

Weaknesses

It is very difficult for me to follow the notation and understand what the algorithm is doing. This gets harder as the authors have not released the code for the experiments. The authors keep iterating that the main limitation of another feature engineering is that they require setting the manual search space without showing how their approach is solving this limitation. The experiments do not include CAAFE, the most relevant algorithm to OCTree. The authors claim that the reason behind this is that CAAFE relies on a language-based context of the dataset, making it inapplicable to the datasets they have used. But I am not yet convinced. None of the decision-tree reasoning and how it is improving OCTree is explained in the paper.

Questions

Why have the authors excluded CAAFE? I looked at the tutorials, and they seem very easy to use. Why do the authors say that CAAFE is orthogonal to their approach? I do not think that is the case. I understand that your approach is CAAFE + a decision tree process embedded. Can you elaborate on the difference between your approach and CAAFE with a concrete example? Your notations are so confusing. In Line 131, what does D + r mean? D is a dataset, and r is a rule; they cannot be summed up. Can authors present evidence on how the inclusion of rules learned by decision trees is increasing the efficiency of their algorithm?

Rating

3

Confidence

3

Soundness

2

Presentation

1

Contribution

1

Limitations

The main competitive algorithm in this work, CAAFE, is excluded from the study. Therefore, we do not have a good baseline for how this approach can improve the problem. The authors have not addressed the study's main concern: the risk of memorization. LLMs are possibly trained on the open datasets they are using. This could be that the LLM is, for example, summarizing what most Kaggle blogs and Medium posts on these datasets have done.

Reviewer Pmbp6/10 · confidence 5/52024-07-12

Summary

This paper proposes a new tabular learning framework called OCTree (Optimizing Column Feature Generator with Decision Tree Reasoning). The framework leverages the reasoning capabilities of large language models (LLMs) to automatically generate new column features based on feedback from decision trees. Experimental results demonstrate that this framework consistently outperforms existing automatic feature engineering methods across various tabular data prediction tasks. The OCTree framework effectively utilizes the reasoning capabilities of LLMs and feedback from decision trees to automatically generate new column features, significantly enhancing the performance of tabular data prediction tasks. This framework demonstrates the great potential of LLMs in automatic feature engineering for tabular data.

Strengths

S1: A new framework for automatic feature generation that leverages LLMs' language understanding and reasoning capabilities, using feedback from decision trees. S2: All experiments on various real-world datasets show significant performance improvements in different prediction models, including gradient-boosted decision trees and deep neural networks. S3: The method works for both datasets with and without language descriptions and shows good transferability of generated features across different types of models.

Weaknesses

w1: I thoroughly enjoyed reading this work. The authors present a unique perspective on the optimization of tabular data tasks. For example, in the abstract, the authors highlight the shortcomings of existing work, such as "they often rely solely on validation scores to select good features, neglecting valuable feedback from past experiments that could inform the planning of future experiments." This indeed reflects the current issues faced by Automated Feature Transformation, where high-performing features may not necessarily be meaningful features. However, conversely, it seems that the goal of Feature Engineering is to improve the performance of downstream machine learning tasks, which is a very direct objective. Isn't it contrary to the original intent of feature engineering if validation scores are not used as an evaluation metric? w2: The writing of the entire paper is relatively easy to read, although some concepts were not discussed in depth. For instance, the authors only claim that validation scores are a flawed feedback mechanism but do not explore some of the newer methods in the main text, such as the latest approaches utilizing reinforcement learning [1-2] or generative artificial intelligence [3-4]. These methods employ the performance of models like decision trees and other machine learning models as scores to learn strategies. w3: In Figure 1, Fever, Fatigue, Breathing, etc., are used through processes like Tabular Data Understanding and rule generation to combine boolean forms (Fever, Fatigue) or one-hot forms of Breathing to create a new feature, Smoke. This is quite intuitive; however, if the rules generated in step 1 are inaccurate, the generated column might also be inaccurate. Moreover, can the concept of whether one smokes or not be automatically and adaptively formed during the generation of decision trees or the training of neural networks, rather than requiring such an inaccurate combination? If not, do the authors have experiments or specific mathematical proofs to validate this claim or to show that neural networks, for instance, would converge more difficultly without these generated key features? w4: In the Column name generation section of the Methodology (section 3.2), how do the authors ensure that the generated column names are valid? w5: In Table 2, it seems that some datasets with non-linguistic descriptions did not improve or only showed general improvement. What are the specific reasons for this? Although this work seems overly intuitive at times, I remain excited about the application of large language models in this field. I hope the authors can address the above questions. [1] Traceable group-wise self-optimizing feature transformation learning: A dual optimization perspective, TKDD [2] Group-wise Reinforcement Feature Generation for Optimal and Explainable Representation Space Reconstruction, KDD [3] Reinforcement-Enhanced Autoregressive Feature Transformation: Gradient-steered Search in Continuous Space for Postfix Expressions, NeurIPS [4] DIFER: Differentiable Automated Feature Engineering, ICAML

Questions

see weakness

Rating

6

Confidence

5

Soundness

2

Presentation

3

Contribution

3

Limitations

see weakness

Reviewer 6JM86/10 · confidence 4/52024-07-13

Summary

The authors introduce a novel feature engineering technique that leverages LLMs for language-based reasoning and considers the outcomes of past experiments as feedback for iterative rule improvements.

Strengths

- the authors introduce a novel feature engineering technique that leverages LLMs so that past experience can be considered when proposing novel features. - the paper is well-structured, the results are clearly presented, and multiple LLMs are assessed

Weaknesses

- the authors did not compare their method against other techniques for automated feature generation - the authors provide no details on whether several rounds of LLM prompting were executed, how do results vary across multiple executions and whether they had issues with LLM hallucinations

Questions

We consider the paper interesting and relevant. Nevertheless, we would like to point to the following improvement opportunities: GENERAL COMMENTS (1) - The authors compare their model against models on which such feature generation was not applied, showing promising results. Nevertheless, we miss a comparison against similar methods that generate features either with heuristics or LLMs, as explained in the Related Work section. In particular, we would encourage the authors to include some comparison against the following work: Hollmann, Noah, Samuel Müller, and Frank Hutter. "Large language models for automated data science: Introducing caafe for context-aware automated feature engineering." Advances in Neural Information Processing Systems 36 (2024). (2) - Did the authors execute several rounds of feature generation using the same prompt and input? Did they observe any variability regarding the results obtained? (3) - How are results different when considering different LLMs? Are there certain patterns regarding the features generated/not generated? Furthermore, the authors mention that "incorporating code datasets alongside dialogue datasets may further enhance the performance of the rule generator LLM". How were such prompt results better from regular LLMs and different from those generated by the LLM proposed by the authors (e.g., in Table 3)? (4) - Did the authors face LLM hallucinations? We would appreciate a brief description on how did they handle such cases and some quantification, to understand how frequent such problem is across different LLMs they tried. FIGURES (6) - Figure 3: (i) can be made monochromatic, (ii) are datasets balanced? How is the cut threshold determined to measure Accuracy? Could this be replaced with a threshold-independent metric? TABLES (7) - Table 7: bold the best results

Rating

6

Confidence

4

Soundness

3

Presentation

3

Contribution

3

Limitations

The authors acknowledge some limitations of their work. Nevertheless, we consider some additional weaknesses (see weaknesses section) should be addressed and eventually acknowledged.

Reviewer Pmbp2024-08-10

I appreciate the authors' effort in addressing my questions in their response. As reflected in my scores,my overall assessment is positive, and I maintain my current scores.

Authorsrebuttal2024-08-11

Thank you very much for the response

Dear reviewer Pmbp, Thank you very much for letting us know! We are happy to hear that our rebuttal addressed your questions well.\ Also we thank you for your prompt response.\ If you have any further questions or suggestions, please do not hesitate to let us know. Thank you very much,\ Authors

Reviewer 245r2024-08-11

I thank the authors for answering my concerns. I appreciate it. Unfortunately, I am not convinced after their answers. Some more feedback is below: > While several reviewers have noted that the paper is generally well-structured and written Absolutely. That's the point of peer review. However, I would like to say that writing does not necessarily mean that the notations are accurate. It can be seen that the "story" is well written. > This requirement limits CAAFE's applicability in cases where language descriptions are not explicitly provided, such as when feature names and values are obfuscated to protect confidentiality, as is common in financial and medical datasets. Sure, but then you must also compare CAAFE to your approach in cases where it is possible. Or is your approach ONLY applicable to those cases? In that case, I would say your solution is very niche. >We have already conducted an ablation study, detailed in Table 5, to assess the effects of providing decision tree reasoning as feedback to the rule generator LLM. I appreciate it, but what I mean is that we need to see the decision tree rules and how the tree relates to the process. >Even if the LLM has memorized information from open datasets, our approach does not rely on the specific data; instead, it generates and introduces entirely new columns to the dataset. Yeah, but you cannot really say that those features do not come from a tutorial on feature engineering on Kaggle in 2015, right? That is what I meant.

Authorsrebuttal2024-08-12

Thank you for the additional feedback (1/2)

**[F1] Absolutely. That's the point of peer review. However, I would like to say that writing does not necessarily mean that the notations are accurate. It can be seen that the "story" is well written.** We appreciate the constructive feedback and agree that clarity in notation is crucial. As we noted in our earlier response, we recognize that certain notations (e.g., $D \oplus r$) could be made clearer. We will carefully review and refine these notations in the final draft to ensure ease of understanding. --- **[F2] Sure, but then you must also compare CAAFE to your approach in cases where it is possible. Or is your approach ONLY applicable to those cases? In that case, I would say your solution is very niche.** We would like to clarify that our method is applicable to both cases where language descriptions are clearly provided and where they are not (see Tables 1 and 2 in our manuscript). We fully agree that comparing our approach with CAAFE is important. Therefore, as per your suggestion, we have already compared CAAFE to our approach in the previous rebuttal using all datasets with contextual information from the experiments summarized in Table 1 of our manuscript. To summarize the results, Table 1 of the attached PDF shows that our method consistently outperforms CAAFE. For a more detailed discussion, we kindly refer you to the **global response** and the **attached PDF**. We appreciate your suggestion and will incorporate these comparative results in the final draft. --- **[F3] I appreciate it, but what I mean is that we need to see the decision tree rules and how the tree relates to the process.** Thank you for your question and the opportunity to provide further clarification. First of all, we would like to clarify that decision tree reasoning refers to the language description of a decision tree that is constructed from the entire dataset, including any newly generated features. This reasoning is then used to guide the LLM in generating more effective feature generation rules. For instance, consider the following example: - Original columns: Fever, Breathing - Introduced column: Smoking status - Task: Predicting whether a patient has a disease A decision tree derived from this data might produce reasoning such as: ``` if ‘Has difficulty breathing’: if ‘Has fever’: ‘Subject has a disease’ else: ‘No disease’ … ``` This decision tree reasoning is provided to the LLM as feedback to refine its feature generation process. Here, we provide a prompt that is used to guide LLM to find good feature generation rules (see Appendix A.3). ``` I have some rules to predict {Objective} with attributes listed below. - {Column #1 Name} (Numerical value of {Column #1 Min} ~ {Column #1 Max}): {Column #1 Feature Description} - {Column #2 Name} (Boolean): {Column #2 Feature Description} - {Column #3 Name} (Categorical value of {Value #1}, {Value #2}, {Value #3}): {Column #3 Feature Description} ... We also have corresponding decision trees (CART) to predict {Objective} from the attributes listed above along with predicted {New Column Name}. The rules are arranged in ascending order based on their scores evaluated with XGBoost classifier, where higher scores indicate better quality. Rule to predict {Objective}: {Rule #1} Decision tree (CART): {Decision Tree #1} Score evaluated with XGBoost classifier: {Score #1} Rule to predict {Objective}: {Rule #2} Decision tree (CART): {Decision Tree #2} Score evaluated with XGBoost classifier: {Score #2} ... Give me a new rule to predict {Objective} that is different from the old ones (but should use the listed attributes above) and has a score as high as possible. Improved rule: ``` We appreciate the question and will provide more examples and explanations in the final draft.

Authorsrebuttal2024-08-12

Thank you for the additional feedback (2/2)

**[F4] Yeah, but you cannot really say that those features do not come from a tutorial on feature engineering on Kaggle in 2015, right? That is what I meant.** Thank you for your insightful comments. We understand your concern that LLMs may have memorized feature engineering techniques, such as those from the tutorials on Kaggle. Indeed, our method leverages LLM’s ability to introduce engineering rules from existing features. However, while LLMs may be familiar with established techniques, this does not guarantee that they can suggest effective feature engineering rules for every dataset. For example, without contextual information about a column, an LLM may struggle to identify which features are most relevant and, therefore, may not provide useful rules. Our method addresses this limitation by proposing an optimization process to find good feature generation rules by designing novel and effective feedback mechanisms. Specifically, in the early optimization stages, the LLM explores a wide range of potential rules, which may be based on common engineering techniques learned, as you pointed out. As the process continues, the LLM refines the solution space around previously discovered solutions, making only minor adjustments during the later stages. In short, our method goes beyond simply utilizing the LLM’s existing knowledge of feature engineering techniques by actively guiding it toward discovering the most effective rules for the specific dataset. We appreciate your feedback and will incorporate this discussion into the final draft.

Reviewer 6JM82024-08-12

We appreciate the authors' effort in answering our questions and the other reviewers' questions. We have no further questions and have decided to update our scores and slightly increase the final score.

Authorsrebuttal2024-08-13

Thank you very much for the response

Dear reviewer 6JM8, Thank you very much for letting us know! We are happy to hear that our rebuttal addressed your questions well.\ If you have any further questions or suggestions, please do not hesitate to let us know. Thank you very much,\ Authors

Reviewer 8DXj2024-08-13

I appreciate the author's efforts in addressing the questions and concerns. However, there are still some critical issues that remain unresolved. 1. For [W1, 2], although this paper focuses on the method's effectiveness, the improvement over the baseline in many datasets is not substantial (for example, in Table 2, where the comparison with XGBoost shows that in 19 datasets, the relative error rate reduction is less than 4% in 11 datasets). Therefore, I believe that a training time comparison is necessary. 2. For [W4], the main issue is not whether the method performs well on one or two datasets with more than 50,000 instances, but rather that the paper's experimental section should avoid sampling datasets down to fewer than 50,000 instances, as this is likely to cause the baselines to underperform. 3. For [Q1], since there are related comparative methods, a comparison between this method and those methods should be included in all evaluation parts of the paper, e.g., Table 2.

Authorsrebuttal2024-08-13

Thank you for the additional feedback

Dear Reviewer 8DXj, Thank you for the additional feedback. Here, we would like to further address your concerns individually. --- **For [W1, 2], although this paper focuses on the method's effectiveness, the improvement over the baseline in many datasets is not substantial (for example, in Table 2, where the comparison with XGBoost shows that in 19 datasets, the relative error rate reduction is less than 4% in 11 datasets). Therefore, I believe that a training time comparison is necessary.** Thank you for your feedback. We understand the importance of evaluating training time. The run time of our method depends on the number of additional features generated and the number of optimization steps used to refine each feature. As you noted, these factors can be substantial depending on dataset size and model type. Nevertheless, we would like to highlight that our method demonstrates consistent improvement in performance across (i) datasets and (ii) baseline model types. As shown in Table 4 of our manuscript, our method outperforms competing automatic feature engineering methods, including AutoFeat and OpenFE. In particular, OpenFE fails to introduce useful features for multilayer perceptron (MLP) in 9 of the 22 classification datasets used in Tables 1 and 2, which contrasts with our method's more robust performance. In response to your comment, we will assess potential speed-ups through approaches such as feature transfer and reducing training data during feature generation that we highlighted in our previous response. We will include these evaluations and additional quantitative results on training time in the final revision. --- **For [W4], the main issue is not whether the method performs well on one or two datasets with more than 50,000 instances, but rather that the paper's experimental section should avoid sampling datasets down to fewer than 50,000 instances, as this is likely to cause the baselines to underperform.** Thank you for highlighting this concern. We sampled datasets down to fewer than 50,000 instances to align with the experimental setup used in [1] (see Appendix A.2.2), which provides a comprehensive benchmarking study of tree-based and deep learning methods on tabular data. This alignment facilitates a clearer comparison of our results with those from previous works. We also want to clarify that once a dataset is sampled, the same sampled dataset is used for both the baselines and our method. Thus, while sampling may impact baseline performance, as you pointed out, our feature generation method is subject to the same conditions. Additionally, it's relevant to note the experimental setup of the previous automatic feature engineering method, CAAFE [2], which only focuses on small datasets with up to 2,000 samples. In contrast, our method has been evaluated on datasets with significantly larger feature dimensions and sample sizes, as detailed in the additional experiments provided in our previous response. We hope these results address your original concern and we will ensure that these results are clearly incorporated into the final revision to comprehensively address your concerns. [1] Grinsztajn et al., Why do tree-based models still outperform deep learning on tabular data? NeurIPS 2022.\ [2] Hollman et al., LLMs for Semi-Automated Data Science: Introducing CAAFE for Context-Aware Automated Feature Engineering, NeurIPS 2023. --- **For [Q1], since there are related comparative methods, a comparison between this method and those methods should be included in all evaluation parts of the paper, e.g., Table 2.** Thank you for your feedback. We would like to clarify that we have compared our approach to CAAFE on **all** datasets where CAAFE is applicable, as detailed in our **global response** and the **attached PDF**. Specifically, we performed a comparative evaluation using all datasets that include contextual information, as shown in Table 1 of our manuscript. Since CAAFE requires language-based contexts, which are not available for all datasets (e.g., those used in Table 2), our comparison focused on datasets where CAAFE can be effectively applied. This highlights the broader applicability of our method compared to CAAFE. We hope this explanation clarifies our approach and the scope of our comparisons.

Program Chairsdecision2024-09-25

Decision

Accept (poster)

© 2026 NYSGPT2525 LLC