How do you use AI Agents for EDA/Data Analysis and getting it ready for ML model training? [D]

Like in manual workflow I would study the given data by using various functions like pd.info and all column wise, remove null, outliers, etc transforming dataset such that the model gives best accuracy/result. This and like overall workflow how can the ai agent do it autonomously? I already have opencode+vscode setup and i don't know how this can go. I have claude and opencode go so need your advice and steps please. I also want it to train the model for me or at least do all the setups for