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
설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.
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:
아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.
로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.
아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.
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.
한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.