I encountered similar issue when running it on Spyder, for some reason i keep getting the same issue(InnerException Could not import pandas. Ensure a compatible version is installed by running: pip install azureml-dataprep[pandas]). I think it may be a spyder version. I tried the same code using VS code by activating the azureml env in VS code using conda activate env_name. It worked like a charm