I have this API key which allows me to import the CSV file it holds. I can do this on sheets/excel, but I want to do it in pandas so that I can manipulate it. The methods I tried didn't work. It should be simple I think. Any ideas?
https://redash.***********.com/api/queries/zz/results.csv?api_key=****************************