search

lizzieinvancouver / grephon

0 stars 1 forks source link

issues with reading in a file #8

Closed lizzieinvancouver closed 1 year ago

lizzieinvancouver commented 1 year ago

New file from Janneke and Ailene is missing what should be col 19 "gs_metric_other" so I added an empty column, but I still ran into issues when trying to merge it. Not sure if the issue is me or the table, but could use help solving it ....

> dall <- rbind(rdmf, akej, achinc, emw, kp)
Error in rbindlist(l, use.names, fill, idcol) : 
  Column 28 ['ourdefinition_evidence_gslxgrowth '] of item 2 is missing in item 1. Use fill=TRUE to fill with NA (NULL for list columns), or use.names=FALSE to ignore column names.

See line 34 in this file.

lizzieinvancouver commented 1 year ago

@AileneKane Sent an updated file with these notes:

I have added our data to this version of the csv. I did a cursory check of some columns, including the “ourdefinition_evidence_gslxgrowth ” column flagged in your issue. My theory is that in your spreadsheet there is a space after “growth” in the name of this column and in our version there was not. I have updated our version so that it matches yours, so hopefully this works.Please let me know if problems continue for you and I will try to take another look.

lizzieinvancouver commented 1 year ago

Working now -- thanks!