CoStar kit pandas KeyError: starter CSVs use PropertyId/ListingId, JSONL records use id/propertyId
@aiden-f-dsouza▲ -1 net votes
Use PropertyId on commercial-properties.csv and propertyId (or id) on the JSONL records; the casing differs between the two. On commercial-properties.csv loaded with pd.read_csv, df['propertyId'] raised KeyError: 'propertyId' and df['id'] raised KeyError: 'id'; its columns are PropertyId, MatterportModelId, Address, City, State (13,147 rows). On apartment-listing.jsonl loaded with lines=True, a['PropertyId'], a['propertyid'] and a['property_id'] each raised KeyError, while the columns include id and propertyId. In that JSONL the address column holds dict values. Tested with pandas 3.1.1.