Dataframe: P0:compa - Compustat Annual#
Compustat Annual#
This dataset contains annual financial statement data from Compustat.
DataFrame Glimpse#
Rows: 58709
Columns: 48
$ gvkey <str> '369350'
$ datadate <datetime[ns]> 2024-12-31 00:00:00
$ fyear <i64> 2024
$ csho <f64> null
$ at <f64> 5715.961
$ pstkl <f64> 0.0
$ txditc <f64> 308.523
$ pstkrv <f64> 0.0
$ seq <f64> 2876.098
$ pstk <f64> 0.0
$ ppegt <f64> 5678.69
$ invt <f64> 952.488
$ lt <f64> 2816.05
$ sich <i64> 2024
$ ib <f64> 599.446
$ oancf <f64> 1152.303
$ act <f64> 1686.524
$ dlc <f64> 88.002
$ che <f64> 72.472
$ lct <f64> 2100.649
$ dvc <f64> 0.0
$ epspi <f64> 0.98
$ epspx <f64> 0.98
$ ajex <f64> 1.0
$ sale <f64> 8227.629
$ ao <f64> 137.697
$ prcc_f <f64> null
$ ps <f64> 0.0
$ be <f64> 3184.621
$ act_ch <f64> 14.135999999999967
$ dlc_ch <f64> 7.311999999999998
$ che_ch <f64> 14.993999999999993
$ lct_ch <f64> -61.40700000000015
$ acc <f64> 67.86100000000013
$ at_l1 <f64> 5828.486
$ at_avg <f64> 5772.2235
$ ag <f64> -0.019306042769940523
$ ppegt_diff <f64> -68.0010000000002
$ ao_diff <f64> -32.52600000000001
$ sale_l1 <f64> 8420.521
$ sale_l3 <f64> null
$ sale_l5 <f64> null
$ sg_1y <f64> -0.022907371170976187
$ sg_3y <f64> null
$ sg_5y <f64> null
$ adj_csho <f64> null
$ adj_csho_l1 <f64> null
$ nsi <f64> null
Dataframe Manifest#
Dataframe Name |
Compustat Annual |
|---|---|
Dataframe ID |
|
Data Sources |
WRDS |
Data Providers |
Compustat |
Links to Providers |
|
Topic Tags |
Fundamentals, Accounting |
Type of Data Access |
S,u,b,s,c,r,i,p,t,i,o,n |
How is data pulled? |
WRDS API via Python |
Data available up to (min) |
2025-12-31 00:00:00 |
Data available up to (max) |
2025-12-31 00:00:00 |
Dataframe Path |
/Users/yandong/Documents/GitHub/p02_van_binsbergen_han_lopez-lira_2022/_data/compa.parquet |
Linked Charts:
Pipeline Manifest#
Pipeline Name |
Man vs. Machine Learning |
|---|---|
Pipeline ID |
|
Lead Pipeline Developer |
Dong Yan, Yilong Lin |
Contributors |
Dong Yan, Yilong Lin |
Git Repo URL |
|
Pipeline Web Page |
|
Date of Last Code Update |
2026-02-06 15:21:11 |
OS Compatibility |
|
Linked Dataframes |