Document datasets so others can understand and reproduce an analysis. Create variable definitions, source records, sample filtering tables, and merge documentation, or assemble a codebook describing how the data was constructed.
Document datasets, variables, sources, and merge keys for replication
Run score Not tested
See how to installReview the instructions the agent will receive before you install.
Help document datasets systematically for replication packages, co-author handoffs, and future reference.
When documenting a dataset, capture:
firm_year_panel.parquet)| Source | Access | Raw File | Notes |
|---|---|---|---|
| WRDS Compustat | Subscription | raw/compustat_funda.csv | Annual fundamentals |
| Revelio Labs | Licensed | raw/revelio_positions.parquet | Via BU server |
| Hand-collected | Manual | raw/manual_coding.xlsx | See coding protocol |
| Variable | Type | Description | Source | Notes |
|---|---|---|---|---|
gvkey | str | Compustat firm identifier | Compustat | Primary key |
fyear | int | Fiscal year | Compustat | |
at | float | Total assets ($ millions) | Compustat | Winsorized 1/99 |
treated | int | =1 if treated firm | Constructed | See section 4 |
For constructed/derived variables, document:
Variable: treated
Definition: =1 if firm received first PE investment in year t
Construction:
1. Merge PitchBook deals to Compustat on EIN
2. Keep first deal per firm
3. Flag year of first investment
Script: 2a_construct_treatment.py, lines 45-78
Document all filters applied:
| Filter | Observations Dropped | Remaining |
|---|---|---|
| Raw data | - | 150,000 |
| Drop financials (SIC 6000-6999) | 25,000 | 125,000 |
| Require non-missing assets | 5,000 | 120,000 |
| Require 2+ years in panel | 10,000 | 110,000 |
| Dataset A | Dataset B | Key(s) | Match Rate | Notes |
|---|---|---|---|---|
| Compustat | CRSP | gvkey | 95% | Via CCM link table |
| Compustat | PitchBook | EIN | 72% | Manual cleaning needed |
| Revelio | Compustat | company_name | 68% | Fuzzy match, see script |
================================================================================
CODEBOOK: firm_year_panel.dta
Generated: 2026-01-15
================================================================================
IDENTIFICATION
gvkey Compustat permanent firm identifier
fyear Fiscal year
OUTCOME VARIABLES
roa Return on assets = ni/at (winsorized 1/99)
investment Capex/lagged assets = capx/L.at
TREATMENT VARIABLES
post =1 for years after treatment
treated =1 for firms ever treated
treat_post Interaction: treated × post (DiD coefficient)
CONTROLS
size Log total assets = ln(at)
leverage Book leverage = (dltt+dlc)/at
mtb Market-to-book = (prcc_f×csho)/ceq
FIXED EFFECTS
ff48 Fama-French 48 industry classification
state State of incorporation
================================================================================
Before finalizing a dataset, verify:
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Turn a broad research idea into clear, testable questions. Compare familiar and less conventional approaches, structure the selected question around its population and methods, and assess variables, feasibility, and potential theoretical contributions.
Helps build a research framework by comparing theories, mapping relationships between variables, and deriving testable hypotheses. Explores less conventional options, examines weaknesses and competing explanations, and produces diagrams with anticipated reviewer objections.
Clarify the philosophical assumptions behind a research project and check whether they fit the proposed methods. Get a reasoned research stance, draft proposal wording, and guidance for explaining how the researcher's background and values shape the study.
Plan and draft academic papers through specialized agent roles covering literature, arguments, citations, and review. Get chapter guidance, revision roadmaps, Traditional Chinese and English abstracts, and documents formatted as LaTeX, DOCX, PDF, or Markdown.
Turn a detailed outline into a philosophy or interdisciplinary manuscript. Draft chapters with repeated quality reviews, check terminology and arguments across sections, and prepare the manuscript, evaluation reports, abstract, and metadata for submission.
Simulate academic peer review through five reviewer roles tailored to the paper's field. Receive separate critiques, an editorial decision, and a prioritized revision roadmap, or check whether a revised manuscript addresses earlier comments.