search

UK-IPOP / open-data-pipeline

A pipeline for processing, enhancing, and sharing open datasets.
https://uk-ipop.github.io/open-data-pipeline/
GNU General Public License v3.0
1 stars 0 forks source link

GEOID difference #35

Open cdelcher opened 4 months ago

cdelcher commented 4 months ago

What is the difference between GEOID left and GEOID right in the chicago death data?

nanthony007 commented 4 months ago

This is likely the result of joining so left would be the left table right the right table whenever I did a join. Are those columns data identical? If so you can just pick one for now and forget the other. I will remove them eventually. This happens when you join two tables with the same column names.

cdelcher commented 4 months ago

They have different census tract numbers so that’s why I’m confused as to the true representation of the incident location. Chris Delcher, PhD

On May 21, 2024, at 12:56 PM, Nick Anthony @.***> wrote:

 CAUTION: External Sender

This is likely the result of joining so left would be the left table right the right table whenever I did a join. Are those columns data identical? If so you can just pick one for now and forget the other. I will remove them eventually. This happens when you join two tables with the same column names.

— Reply to this email directly, view it on GitHubhttps://github.com/UK-IPOP/open-data-pipeline/issues/35#issuecomment-2123052801, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ALKB4633REEFWVDFVYXLZRLZDN4CTAVCNFSM6AAAAABIBQJCB6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRTGA2TEOBQGE. You are receiving this because you authored the thread.Message ID: @.***>