| name | file-data-extraction |
| description | Techniques for parsing TSV/JSON files for financial reporting data (13F). |
File Data Extraction
When dealing with 13F financial data, the primary data formats encountered are TSV (Tab Separated Values) and JSON.
Parsing TSV
TSV files (like COVERPAGE.tsv and INFOTABLE.tsv) should be treated as structured datasets. Use pandas in Python to quickly aggregate, filter, and compare data.
Example snippet:
import pandas as pd
df = pd.read_csv('COVERPAGE.tsv', sep='\t')
fund_data = df[df['name'].str.contains('RENAISSANCE TECHNOLOGIES', case=False)]
Parsing JSON
Metadata files often use JSON. Use the standard json library or pandas.read_json for consistency with TSV processing.