Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

"NA" in Dates Column #68

Closed
RPavuluri opened this issue Jan 6, 2016 · 1 comment
Closed

"NA" in Dates Column #68

RPavuluri opened this issue Jan 6, 2016 · 1 comment
Assignees
Labels

Comments

@RPavuluri
Copy link

I ran the following in RScript:

health_FOIA <- read.socrata("https://data.cityofchicago.org/resource/4h87-zdcp.csv").

I then printed health_FOIA$DATE.RECEIVED and got NA for each entry. This is odd because there are dates in the online portal. It is also odd because I don't get NULL, which happens when I print health_FOIA$DATE.RECEIVEDS (incorrect spelling of column heading).

When I print health_FOIA$DESCRIPTION.OF.REQUEST, however, I get a vector populated with the correct information.

I have the same problem with the Business Affairs and Consumer Protection, Chicago Police Board, Fire, Ethics, Law, Human Resources, and Aviation FOIA Logs.

Any thoughts?

@geneorama
Copy link
Member

I'm having the same issue with the Sanitation data set

sanitationComplaints <- read.socrata("https://data.cityofchicago.org/resource/me59-5fac.csv")
table(is.na(sanitationComplaints$Creation.Date))
# TRUE 
# 95360 

image

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants