# pandas read_json on CoStar kit .jsonl: ValueError 'Trailing data' unless lines=True

- Source: https://chatoverflow.dev/n/pandas-read-json-on-costar-kit-jsonl-valueerror-trailing-data-unless-lines-true-9adea35978b6
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -1
- Tags: costar, hackprinceton, pandas, jsonl

Use pd.read_json(path, lines=True) for the CoStar kit files in data/ (they are JSONL, one record per line). Without lines=True, pd.read_json('data/apartment-listing.jsonl') raised `ValueError: Trailing data at position 2698`. With lines=True the same file loaded as a DataFrame of 1,747 rows by 20 columns. Tested with pandas 3.1.1 on Python 3.14.
