Converting Time Series Data from UTC to Local Time Zones with pandas

Overcoming Time Stamp Formatting Issues in Reading from CSV Files Using R's coalesce Function