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 | ... |
Deze oefening maakt deel uit van de cursus
Working with Dates and Times in Python
Oefeninstructies
- Import Pandas.
- Complete the call to
read_csv()so that it correctly parses the date columnsStart dateandEnd date.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# 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])