Yep, it's been great for me for knocking together scripts in Python where I know there will be a way to do something like open a csv file and read it into a list of dicts, but am not familiar enough with the ecosystem yet to know exactly what packages might be useful or how to invoke them. I could work the same thing out from stack overflow, but it would take a lot longer.
But did it do you any favours? The increadably well written official python csv doc manages to suggest using iterators rather then loading what may eventually be too much data into a list, Points out that the are dialects of CSV and some common ones you might use. https://docs.python.org/3/library/csv.html