read_csv: support for compressed .zip files

[raayu83]

Description

It seems read_csv does not yet support reading directly from .zip files.

It would be great if passing a zip file Path would try reading all files in the .zip into a df.
This is a pretty common usecase when dealing with reporting APIs.

Additionally, it would be great if there was a way to only read a single file in the zip. E.g. by passing a ZipFile Path, though I'd personally prefer an option to pass the filename directly without using ZipFile.