ENH: read_csv tz option

[hasandiwan]

Feature Type

• [x] Adding new functionality to pandas

• [ ] Changing existing functionality in pandas

• [ ] Removing existing functionality in pandas

Problem Description

I use pd.read_csv to grab a series of timestamp'd links interactively from a remote website.

Feature Description

I would like it to convert the columns specified by parse_dates to the timezone specified by wherever the /etc/localtime link points to by default in a non-deprecated manner:

[frame.loc[:,c].dt.tz_convert('/'.join([os.getenv('TZ', os.path.realpath('/etc/localtime').split('/')[-2:])][0])) for c in frame.select_dtypes('datetime64[ns, UTC]')]`

I'd like to propose this functionality as the tz parameter to read_csv. I suspect the implementation is not python, and can't find it in my git checkout of pandas.

Alternative Solutions

Covered above

Additional Context

[datapythonista]

I don't think we'll implement this. read_csv has too way many parameters already, and this can be done after the CSV is read, if I'm not missing anything. But let's see what others think.

[mroeschke]

Agreed, closing