ENH: read_csv dialect parameter can take a string (GH8703)

I wasn't sure where to put the test, hopefully this is right.