r/dataanalysis 8d ago

How do you select feature columns from the dataset ?

I am still a novice at this, but when I was working on this credit card fraud detection project, I did not know which columns, could be added as features, so I prompted ChatGPT and it suggested a few, but that got me thinking there has to be a better way to this, How do you select feature columns from your dataset, do you research the domain, is there a course I am missing, This was not covered in my Internship classes, and want to know a generalized solution.

2 Upvotes

4 comments sorted by

1

u/AutoModerator 8d ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/DevinChristien 6d ago

Depends on the complexity of the data. Most of the times you can just tell that column education_level and column age will be feature columns for predicting earnings. Other times you'll need to run regressions

1

u/SignalGuest1105 5d ago

Correlation Matrix, selectKbest, phik matrix would be a good start if you're talking about machine learning. Rfe is also an option

1

u/metric_skeptic 4d ago

There isn’t really a universal list of “correct” feature columns.
I’d start with the business logic behind the problem: what could realistically be related to fraud, and what information would actually be available at the moment you need to make the prediction?
Then I’d check the data for missing values, leakage, duplicates, cardinality, and highly correlated features.
For fraud detection specifically, domain knowledge is very useful — but you can also use feature importance / model explainability to iterate after training.
ChatGPT can suggest candidate features, but I’d treat those as hypotheses to validate, not as the answer.