One Paragraph of project description goes here
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
| package main | |
| import ( | |
| "encoding/json" | |
| "fmt" | |
| ) | |
| func dumpMap(space string, m map[string]interface{}) { | |
| for k, v := range m { | |
| if mv, ok := v.(map[string]interface{}); ok { |
| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
| # When you're sure of the format, it's much quicker to explicitly convert your dates than use `parse_dates` | |
| # Makes sense; was just surprised by the time difference. | |
| import pandas as pd | |
| from datetime import datetime | |
| to_datetime = lambda d: datetime.strptime(d, '%m/%d/%Y %H:%M') | |
| %time trips = pd.read_csv('data/divvy/Divvy_Trips_2013.csv', parse_dates=['starttime', 'stoptime']) | |
| # CPU times: user 1min 29s, sys: 331 ms, total: 1min 29s | |
| # Wall time: 1min 30s |