dwreeves

#delimit cr
version 13.1
clear all
set more off
/*******************************************************************************
* Import Directory of Excel Files into Stata
* 
* Author: Daniel Reeves
* https://github.com/dwreeves
* 

dwreeves

Sub UpdateDir()
    ''' Create list of files in spreadsheet named "list." '''

    If ThisWorkbook.Path = "" Then
        MsgBox "Please save this file first"
        Stop
    End If

    
    '--------------------------------------------------------------------------

dwreeves

import delimited "Transportation_Network_Providers_-_Trips.csv", delimiter(comma) varnames(1) stripquote(yes) asdouble 

drop pickupcentroidlocation dropoffcentroidlocation //redundant

/* var : Share Trip Authorized */
replace sharedtripauthorized = "0" if sharedtripauthorized=="false"
replace sharedtripauthorized = "1" if sharedtripauthorized=="true"
destring sharedtripauthorized, replace
label def lbl_truefalse 0 "false" 1 "true"
label values sharedtripauthorized lbl_truefalse

dwreeves

puzzle1 = [
	[4,1,3],
	[2,8,0],
	[7,6,5]
]
cant_be_solved = [
	[1,2,3],
	[4,5,6],
	[0,8,7]
]

dwreeves

dwreeves

Code for Boston - Safe Drinking Water Project

Daniel Reeves - process notes and recommendations

Summary of recommendations

• Separate out processed and raw data in the data/ folder.
• Include README.md files within each folder containing data files; also utilize the Issues tab in GitHub more often.
• Utilizes branches in the GitHub workflow, and keep the master branch's data folder "clean," so to speak.

dwreeves

dwreeves

"""
Definitions of various constants. Adjust based on project structure and needs.
"""

import os

# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# Files and Directories
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

dwreeves

Data Format: 
  dateTimeDelimiter: " "
  decimalSeparator: "."
  dataDelimiter: ","
  dateFormat: MM/dd/yy
  timeFormat: HH:mm:ss
  gmtOffset: -5
  daylightSavings: true

Logger Info: 

dwreeves

Data Format: 
  dateTimeDelimiter: " "
  decimalSeparator: "."
  dataDelimiter: ","
  dateFormat: MM/dd/yy
  timeFormat: HH:mm:ss
  gmtOffset: -5
  daylightSavings: false

Logger Info: