Loading a csv file in Pandas
The capital_onebike.csv file covers the October, November and December rides of the Capital Bikeshare bike W20529.
Here are the first two columns:
| Start date | End date | ... |
|---|---|---|
| 2017-10-01 15:23:25 | 2017-10-01 15:26:26 | ... |
| 2017-10-01 15:42:57 | 2017-10-01 17:49:59 | ... |
This exercise is part of the course
Working with Dates and Times in Python
Exercise instructions
- Import Pandas.
- Complete the call to
read_csv()so that it correctly parses the date columnsStart dateandEnd date.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import pandas
import ____ as pd
# Load CSV into the rides variable
rides = pd.read_csv('capital-onebike.csv',
parse_dates = ____)
# Print the initial (0th) row
print(rides.iloc[0])