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

I closed this PR and opened a new one by mistake, sorry for the noise. The new PR #8719 should reflect the test changes.
 @thrasibule For the future, it is not needed to open a new PR. Just push the new commit to the same branch on your github fork, and the PR will be automatically updated.
