Data cleaning in excel First, I downloaded data from the Open Data Portal of the City of Los Angeles. See my previous post describing how to do this using the SODA API.

Next, I did some data cleaning operations in EXCEL. I converted the Dates field into serial number. To extract year, month and day, I used the following EXCEL formula:

 = TIMEVALUE(LEFT(J2,LEN(J2)-2) & “:” & RIGHT(J2,2))
After re-formatting the TIME field to a proper time format, I merged the date and time fields with this formula:

 = C1 + D1

For this to work, C1 must be a date formatted, and D1 must be time formatted I then selected CHILD NEGLECT cases and followed the following tutorial to make this map in QGIS 3.6.
Moderation Mediation Moderated Mediation Lavaan R code
Avatar
Gia Elise Barboza-Salerno
Assistant Professor in the School of Criminal Justice and Public Administration

My research interests include applied spatial policy and analysis, child welfare and criminal justice system reform, victimization by bullying, domestic abuse.