DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-ipeds
education-data-source-ipeds
VerifiedIPEDS — primary federal postsecondary data (~5,800 Title IV institutions, administrative offices, and U.S. service academies, 5,829 in the 2024-25 collection; 1979-present in the mirror; IPEDS replaced its predecessor HEGIS in 1986, so the earliest mirror years predate IPEDS): enrollment, completions, graduation rates, finance, aid, admissions, HR. For college/university analysis. Grad rates = first-time full-time; finance needs GASB/FASB care.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 30.4 KB |
| references/completions-data.md | markdown | 24.8 KB |
| references/data-quality.md | markdown | 18.5 KB |
| references/enrollment-data.md | markdown | 12.8 KB |
| references/finance-data.md | markdown | 16.9 KB |
| references/financial-aid.md | markdown | 23.1 KB |
| references/graduation-rates.md | markdown | 23.8 KB |
| references/institution-identifiers.md | markdown | 17.1 KB |
| references/survey-components.md | markdown | 28.4 KB |
references/graduation-rates.md
View on GitHub# IPEDS Graduation Rates: Critical Limitations
**This is the most misunderstood aspect of IPEDS data.** Understanding these limitations is essential for any graduation rate analysis.
## Contents
- [The Core Problem](#the-core-problem)
- [Who Is Tracked](#who-is-tracked)
- [Who Is NOT Tracked](#who-is-not-tracked)
- [Impact by Institution Type](#impact-by-institution-type)
- [Time Windows](#time-windows)
- [Transfer-Out Rates](#transfer-out-rates)
- [Pell and Loan Cohorts](#pell-and-loan-cohorts)
- [Outcome Measures Alternative](#outcome-measures-alternative)
- [Calculating Rates](#calculating-rates)
- [Valid and Invalid Comparisons](#valid-and-invalid-comparisons)
## The Core Problem
IPEDS graduation rates track a **narrow subset of students** that does not represent the full undergraduate population at most institutions.
**Key Fact**: Full-time, first-time students — the only students in the GR cohort — "make up fewer than half of all college students, or even less in some sectors of institutions (e.g., community colleges)" (College Scorecard Technical Documentation, Oct 2026). Figures such as "<25% at many institutions" are illustrative — compute from IPEDS for your sample.
This is not a data quality issue—it's by design. The Student Right-to-Know Act (1990) established this cohort definition, and while it made sense for traditional 4-year residential colleges, it fails to capture the reality of modern higher education.
## Who Is Tracked
The IPEDS Graduation Rates (GR) cohort includes ONLY students who are:
| Criterion | Definition | Exclusion Impact |
|-----------|------------|------------------|
| **First-time** | Never previously enrolled at ANY postsecondary institution | Excludes transfers |
| **Full-time** | Enrolled full-time in their FIRST term | Excludes part-time starts |
| **Degree/certificate-seeking** | Enrolled in a program leading to an award | Excludes non-degree |
| **Fall entering** | Started in the fall term | Excludes spring/summer starts |
| **At this institution** | Tracked at entry institution | Transfers OUT are non-completers |
**ALL criteria must be met for a student to be in the cohort.**
## Who Is NOT Tracked
### Transfer Students
(Illustrative magnitude — unsourced: often put at ~40% of undergraduates nationally; compute from IPEDS for your sample.)
- Students who transfer IN from another institution are excluded
- Students who transfer OUT count as **non-completers**, even if they graduate elsewhere
- Community college transfers to 4-year schools: NOT in 4-year school's cohort
- "Swirling" students who attend multiple institutions: poorly captured
### Part-Time Students
(Illustrative magnitude — unsourced: often put at ~40% of undergraduates nationally; compute from IPEDS for your sample.)
- Students who begin part-time are excluded entirely
- Even if they later switch to full-time
- Disproportionately excludes:
- Working adults
- Parents
- Students at community colleges
- Students at for-profit institutions
### Spring/Summer Starts
- Students entering in spring or summer terms are excluded
- This is especially significant for:
- Community colleges (many have year-round enrollment)
- For-profit institutions (often have rolling starts)
- Some public 4-year institutions with mid-year programs
### Non-Degree Students
- Students not enrolled in a degree/certificate program excluded
- Includes many adult learners taking courses for job skills
## Impact by Institution Type
### Community Colleges
**IPEDS graduation rates are most misleading for community colleges.**
| Factor | Impact |
|--------|--------|
| Transfer mission | Students who transfer to 4-year school before graduating = non-completers |
| Part-time majority | Many CC students attend part-time (illustrative ~65% — unsourced; compute from IPEDS); excluded from cohort |
| Non-fall starts | Many CCs enroll year-round |
| Swirling students | Students attending multiple schools |
**Illustrative example** (hypothetical magnitudes — unsourced; compute from IPEDS for your sample): A community college might have a 15% IPEDS graduation rate, but:
- 30% of students transfer before completing (counted as failures)
- 65% started part-time (not in cohort at all)
- Actual success rate when including transfers could be 50%+
### For-Profit Institutions
| Factor | Impact |
|--------|--------|
| Program-based enrollment | Often rolling starts, not fall-based |
| Short-term programs | Certificate programs may have different dynamics |
| Part-time students | Significant population at some institutions |
### Highly Selective 4-Year Institutions
**IPEDS graduation rates are most appropriate for these institutions** because:
- Most students are first-time, full-time
- Most enter in fall
- Transfer rates are relatively low
- Cohort represents most of the student body
### Open-Access 4-Year Institutions
Less appropriate than selective institutions because:
- More transfer students
- More part-time students
- More non-traditional students
## Time Windows
### 150% Time (Standard Reported Rate)
| Institution Type | Program Length | 150% Window |
|-----------------|----------------|-------------|
| 4-year | 4 years | 6 years |
| 2-year | 2 years | 3 years |
| Less-than-2-year | Varies | 1.5x program length |
**150% time is the most commonly reported and used rate.**
### 100% Time ("On-Time" Graduation)
| Institution Type | 100% Window |
|-----------------|-------------|
| 4-year | 4 years |
| 2-year | 2 years |
Increasingly reported but penalizes students who:
- Take reduced course loads
- Work while enrolled
- Change majors
- Take leave of absence
### 200% Time (GR200 Survey)
| Institution Type | 200% Window |
|-----------------|-------------|
| 4-year | 8 years |
| 2-year | 4 years |
Captures additional completers but:
- Long lag time makes data less current
- Still excludes same populations
**How Many Additional Completers?**
(Illustrative magnitude — unsourced; compute from IPEDS for your sample.) Typically 2-5 percentage points more than 150% rate for 4-year institutions.
## Transfer-Out Rates
IPEDS collects transfer-out rates separately, but with major limitations:
### What Is Reported
- Students who transferred to another institution (if known)
- Counted separately from completers and non-completers
### Critical Limitations
| Limitation | Implication |
|------------|-------------|
| Only "known" transfers | Institutions may not know student transferred |
| No outcome tracking | Transfer doesn't mean student graduated elsewhere |
| Not subtracted from non-completers | Transfer + graduation could exceed 100% |
### How to Use
```python
# Basic transfer-adjusted rate (imperfect but better)
adjusted_success = graduation_rate + transfer_out_rate
# But this is NOT a true completion rate because:
# 1. Not all transfers complete elsewhere
# 2. Not all transfers are captured
# 3. Some students may be double-counted
```
```r
# Basic transfer-adjusted rate (imperfect but better)
adjusted_success <- graduation_rate + transfer_out_rate
# But this is NOT a true completion rate because:
# 1. Not all transfers complete elsewhere
# 2. Not all transfers are captured
# 3. Some students may be double-counted
```
### Transfer-Out Rate Patterns
(Illustrative magnitudes — unsourced; compute from IPEDS for your sample.)
| Institution Type | Typical Transfer-Out Rate |
|-----------------|---------------------------|
| Community colleges | 20-40% |
| Non-selective 4-year | 10-20% |
| Selective 4-year | 5-10% |
| Highly selective 4-year | 2-5% |
## Pell and Loan Cohorts
Beginning with the 2016-17 collection (Portal `year` 2015; 2010 cohort at 4-year institutions), IPEDS reports graduation rates disaggregated by:
### Pell Grant Recipients
Students who received a Pell Grant (recipient status as of entry/first year; confirm in the GR instructions for your year).
**Why It Matters**:
- Pell = low-income proxy (family income typically <$60K — illustrative, unsourced)
- Pell recipient graduation rates often 5-15 percentage points lower (illustrative magnitude — unsourced; compute from IPEDS for your sample)
- Shows equity gaps
### Subsidized Stafford Loan Recipients
Students who received a subsidized Stafford/Direct Subsidized Loan but did not receive a Pell Grant.
**Why It Matters**:
- Indicates financial need (not Pell level, but need-based)
- Broader income range than Pell
### Neither Pell nor Loan
Students who received neither Pell grants nor subsidized loans.
- Generally higher-income students
- Often have highest graduation rates
- Helps identify equity gaps
**Calculating Equity Gaps**:
```python
equity_gap = grad_rate_neither_pell_loan - grad_rate_pell
# Positive value = higher-income students graduate at higher rates
```
```r
equity_gap <- grad_rate_neither_pell_loan - grad_rate_pell
# Positive value = higher-income students graduate at higher rates
```
## Outcome Measures Alternative
The **Outcome Measures (OM)** survey addresses GR limitations by tracking:
### Four Cohorts
1. **First-time, full-time** (same as GR)
2. **First-time, part-time** (NEW)
3. **Non-first-time, full-time** (transfers - NEW)
4. **Non-first-time, part-time** (transfers, part-time - NEW)
Beginning with the 2017-18 collection, each cohort is further split by Pell Grant recipient status (eight cohorts; Portal `year` ≥ 2016).
### Status Points and Outcomes
Status is measured as of August 31 at 4, 6, and 8 years after entry (the 4-year point was added with the 2017-18 collection). At the 8-year point each cohort is reported as:
- Received award
- Did not receive award, still enrolled at reporting institution
- Did not receive award, subsequently enrolled at another institution
- Did not receive award, subsequent enrollment status unknown
Awards earned at other institutions are not reported (inference from the NCES category list: other-institution outcomes appear only as subsequent enrollment).
### Key Advantages
| GR Limitation | OM Solution |
|---------------|-------------|
| Excludes part-time | Includes PT cohort |
| Excludes transfers | Includes transfer cohort |
| Transfers-out = failure | Reports subsequent enrollment at another institution (not awards earned there) |
| 6-year max (4-year schools) | Status at 4, 6, and 8 years |
### Key Limitation
- First collected in 2015-16 (for 2007-08 cohort); the Portal `outcome-measures` file begins at `year`=2015 (2008 cohort), so the first (2007-cohort) collection is not in the Portal.
- Less historical data than GR
- More complex to analyze
- Less widely used in rankings/accountability
## Calculating Rates
### Basic Graduation Rate
```python
grad_rate_150 = (
completers_within_150_pct_time /
adjusted_cohort
) * 100
# Where adjusted_cohort = initial_cohort - exclusions
# Exclusions: died, disabled, military service, foreign service
```
```r
grad_rate_150 <- (
completers_within_150_pct_time /
adjusted_cohort
) * 100
# Where adjusted_cohort = initial_cohort - exclusions
# Exclusions: died, disabled, military service, foreign service
```
### By Demographic Group
```python
# By race/ethnicity
grad_rate_black = completers_black / cohort_black * 100
# By gender
grad_rate_female = completers_female / cohort_female * 100
# By Pell status
grad_rate_pell = completers_pell / cohort_pell * 100
```
```r
# By race/ethnicity
grad_rate_black <- completers_black / cohort_black * 100
# By gender
grad_rate_female <- completers_female / cohort_female * 100
# By Pell status
grad_rate_pell <- completers_pell / cohort_pell * 100
```
### Transfer-Adjusted (Informal)
```python
# NOT an official rate, but provides context
transfer_adjusted = grad_rate_150 + transfer_out_rate
# Better interpretation: "percentage who either graduated or transferred"
# This is NOT equal to "percentage who succeeded"
```
```r
# NOT an official rate, but provides context
transfer_adjusted <- grad_rate_150 + transfer_out_rate
# Better interpretation: "percentage who either graduated or transferred"
# This is NOT equal to "percentage who succeeded"
```
## Valid and Invalid Comparisons
### Valid Comparisons
| Comparison | Why Valid |
|------------|-----------|
| Same institution over time | Same population definition |
| Similar institutions (same sector, selectivity, Carnegie) | Similar student bodies |
| Within racial/ethnic groups | Controls for composition |
| Pell vs non-Pell within institution | Same institution, different income |
### Invalid or Problematic Comparisons
| Comparison | Why Problematic |
|------------|-----------------|
| Community college vs 4-year | CC grad rate excludes transfer successes |
| Open-access vs selective | Different student populations |
| Public vs for-profit | Different enrollment patterns |
| Cross-sector rankings | Comparing apples to oranges |
### Best Practices
1. **Always note the cohort definition** in any graduation rate analysis
2. **Compare within peer groups** (same Carnegie class, sector, selectivity)
3. **Report transfer-out rates** alongside graduation rates
4. **Use Outcome Measures** when available for complete picture
5. **Avoid using as sole quality metric** - it reflects student population as much as institutional quality
## Cohort Year vs Data Year
**Critical for understanding data timing:**
| Term | Meaning | Example |
|------|---------|---------|
| Cohort year (`cohort_year`) | Fall students entered | 2018 |
| Status date | 150% status measured (Aug 31) | Aug 31, 2024 (4-year, 6-yr window) |
| Portal `year` | Academic year ending at the status date | 2023 |
| IPEDS collection / release | Winter collection / provisional release | 2024-25 / Dec 2025 |
**Portal GR rows labeled `year`=2023 are the fall 2018 entering cohort** (4-year: `cohort_year` = `year` − 5; less-than-4-year: `year` − 2). Verified 2026-10-19: unitid 110635 `year`=2023 carries `cohort_year`=2018 and `completion_rate_150pct`=0.93, matching College Navigator's 6-year rate of 93% for students who began in fall 2018.
## Variable Reference
> Verify these variable names against the live codebook. Use `get_codebook_url()` from `fetch-patterns.md`.
> The Portal `grad-rates` dataset uses descriptive names (not NCES survey form names).
### Key GR Variables (Portal Names)
| Portal Variable | Description |
|-----------------|-------------|
| `unitid` | Institution identifier |
| `year` | Data year — NOT the entry year (4-year 150% GR: `cohort_year` = `year` − 5; see Cohort Year vs Data Year) |
| `fips` | State FIPS code |
| `cohort_year` | Year the cohort entered |
| `cohort_adj_150pct` | Adjusted cohort count (at 150% time) |
| `cohort_rev` | Revised cohort count |
| `completers_150pct` | Completers within 150% time |
| `completers_100pct` | Completers within 100% time |
| `completion_rate_150pct` | Graduation rate at 150% time |
| `transfers_out` | Students who transferred out |
| `still_enrolled` | Students still enrolled |
| `still_enrolled_long_program` | Still enrolled in longer program |
| `no_longer_enrolled` | No longer enrolled |
| `exclusions` | Cohort exclusions (death, disability, military) |
| `subcohort` | Subcohort type identifier |
| `race` | Race/ethnicity (integer codes: 1-9, 99) |
| `sex` | Sex (integer codes: 1=Male, 2=Female, 99=Total) |
| `institution_level` | Institution level |
#### Subcohort Codes (`subcohort`)
The `subcohort` variable identifies which student population is tracked:
| Code | Meaning (codebook label) | Notes |
|------|---------|-------|
| 1 | Degree/certificate nonbachelor's seeking subcohort of four-year institutions | Other-than-bachelor's seekers at 4-year institutions |
| 2 | Bachelor's or equivalent subcohort of four-year institutions | Standard cohort for 4-year graduation rate analysis (institution count unsourced; compute from your extract) |
| 99 | Total | Aggregate across subcohort types |
| -2 | Not applicable | Less-than-4-year institutions: observed on every 2-year row of a Portal `grad-rates` probe (Wyoming, `year`=2015, `institution_level`=2), 2026-10-19 |
> Labels follow the Portal codebook (`education-data-explorer/references/variable-dictionary-ipeds.md` § `ipeds/colleges_ipeds_grad-rates`). Code 1 is NOT the less-than-4-year cohort; select 2-year institutions by `institution_level`, not `subcohort == 1`.
For standard 4-year bachelor's graduation rate analysis, filter to `subcohort == 2`. Note that multiple rows per institution may exist within a subcohort due to `cohort_rev` variants. To get one row per institution, sort by `completion_rate_150pct` descending (nulls last) and deduplicate:
```python
gr_bach = (
df.filter(pl.col("subcohort") == 2)
.sort("completion_rate_150pct", descending=True, nulls_last=True)
.unique(subset=["unitid"], keep="first")
)
```
```r
library(dplyr)
gr_bach <- df |>
filter(subcohort == 2) |>
arrange(desc(completion_rate_150pct)) |>
distinct(unitid, .keep_all = TRUE)
```
#### NCES Raw File Names (for reference only)
The following variable names appear in NCES documentation and raw IPEDS data files but are NOT used in the Portal:
| NCES Name | Portal Equivalent |
|-----------|-------------------|
| `GRTYPE` | `subcohort` |
| `CHRTSTAT` | (encoded in row structure) |
| `GRTOTLT` | `completers_150pct` (filtered) |
| `GRRTTOT` | `completion_rate_150pct` |
| `TRTOTLT` | `transfers_out` |
### Outcome Measures Variables (Portal Names — Verified)
The outcome-measures dataset is available at path `ipeds/colleges_ipeds_outcome-measures` (2015-2021 on the 2026q3 vintage; year 2022 is absent). Consult the codebook for full coded value definitions:
```python
url = get_codebook_url("ipeds/codebook_colleges_ipeds_outcome-measures")
```
```r
# get_codebook_url() is a Python helper; in R, build the URL from the mirror root.
# Mirror failover: see `education-data-query/references/fetch-patterns.md` (R pattern)
mirror <- yaml::read_yaml("mirrors.yaml")$mirrors[[1]]
url <- paste0(mirror$root_url, "/", mirror$vintage$hf_revision, "/", "ipeds/codebook_colleges_ipeds_outcome-measures", ".xls")
```
#### All 38 Columns (Verified from Mirror)
**Identifiers and Dimensions:**
| Portal Column | Type | Description |
|---------------|------|-------------|
| `unitid` | Int64 | Institution identifier |
| `year` | Int64 | Data year |
| `fips` | Int64 | State FIPS code |
| `cohort_year` | Int64 | Year the cohort entered |
| `class_level` | Int64 | 1=First-time, 2=Non-first-time, 99=Total |
| `ftpt` | Int64 | 1=Full-time, 2=Part-time, 99=Total |
| `fed_aid_type` | Int64 | 1=Pell recipients, 4=Non-Pell/non-loan, 99=Total |
**Cohort Counts:**
| Portal Column | Type | Description |
|---------------|------|-------------|
| `cohort_adj` | Int64 | Adjusted cohort (4-year window; -2 = not applicable) |
| `cohort_adj_6yr` | Int64 | Adjusted cohort (6-year window) |
| `cohort_adj_8yr` | Int64 | Adjusted cohort (8-year window) |
| `cohort_rev` | Int64 | Revised cohort (4-year window; -2 = not applicable) |
| `cohort_rev_6yr` | Int64 | Revised cohort (6-year window) |
| `exclusions` | Int64 | Exclusions from cohort (4-year; -2 = not applicable) |
| `exclusions_6yr` | Int64 | Exclusions from cohort (6-year) |
| `exclusions_add_8yr` | Int64 | Additional exclusions at 8-year point |
**Award Outcomes (by time window and award type):**
| Portal Column | Type | Description |
|---------------|------|-------------|
| `completers_4yr` | Int64 | Total completers within 4 years |
| `completers_6yr` | Int64 | Total completers within 6 years |
| `completers_8yr` | Int64 | Total completers within 8 years |
| `award_cert_4yr` | Int64 | Certificate awards within 4 years |
| `award_cert_6yr` | Int64 | Certificate awards within 6 years |
| `award_cert_8yr` | Int64 | Certificate awards within 8 years |
| `award_assoc_4yr` | Int64 | Associate degree awards within 4 years |
| `award_assoc_6yr` | Int64 | Associate degree awards within 6 years |
| `award_assoc_8yr` | Int64 | Associate degree awards within 8 years |
| `award_bach_4yr` | Int64 | Bachelor's degree awards within 4 years |
| `award_bach_6yr` | Int64 | Bachelor's degree awards within 6 years |
| `award_bach_8yr` | Int64 | Bachelor's degree awards within 8 years |
**Completion Rates:**
| Portal Column | Type | Description |
|---------------|------|-------------|
| `completion_rate_4yr` | Float64 | Completion rate at 4 years |
| `completion_rate_6yr` | Float64 | Completion rate at 6 years |
| `completion_rate_8yr` | Float64 | Completion rate at 8 years |
**Other 8-Year Outcomes:**
| Portal Column | Type | Description |
|---------------|------|-------------|
| `transfer_8yr` | Int64 | Number of adjusted cohort who enrolled subsequently at another institution at 8 years (codebook label) |
| `transfer_rate_8yr` | Float64 | Percent of adjusted cohort enrolled subsequently at another institution at 8 years (codebook label) |
| `still_enroll_8yr` | Int64 | Still enrolled at 8 years |
| `still_enroll_rate_8yr` | Float64 | Still-enrolled rate at 8 years |
| `still_enroll_transfer_rate_8yr` | Float64 | Still enrolled or transferred rate at 8 years |
| `no_award_8yr` | Int64 | No award received at 8 years |
| `unknown_8yr` | Int64 | Unknown status at 8 years |
| `unknown_rate_8yr` | Float64 | Unknown rate at 8 years |
**Special value:** `-2` means "not applicable" (e.g., 4-year cohort fields for 2-year institutions).
#### NCES to Portal Mapping (for reference)
| NCES Name | Portal Equivalent |
|-----------|-------------------|
| `omachrt` | `completers_8yr` (total awards at this institution) |
| `omawdoth` | No direct equivalent (awards at other institutions not separately tracked; see `transfer_8yr`) |
| `omstleng` | `still_enroll_8yr` |
| `omengoth` | No direct equivalent (incorporated into `still_enroll_transfer_rate_8yr`) |
| `omnoleng` | `no_award_8yr` |
#### Querying Outcome Measures (Example)
```python
import polars as pl
# Mirror root + pinned revision (keep in sync with education-data-query
# references/mirrors.yaml: HF root_url + vintage.hf_revision). "vintage" = a dated
# Portal snapshot; "revision" = the HF git ref pinning byte-exact bytes.
MIRROR = "https://huggingface.co/datasets/brhkim/education_data_portal_mirror_2026q3/resolve"
REVISION = "0ad00ce0e232c96b0642459e4e7326607a8d26aa" # immutable commit SHA of the v2 upload
url = f"{MIRROR}/{REVISION}/ipeds/colleges_ipeds_outcome-measures.parquet"
df = pl.read_parquet(url)
# 8-year completion rates by enrollment intensity for first-time students
# NOTE: outcome-measures content on this vintage ends at 2021 (covers 2015-2021);
# there is no 2022 in this file, so filter the latest available year, 2021.
om = (
df.filter(
(pl.col("year") == 2021)
& (pl.col("class_level") == 1) # First-time
& (pl.col("fed_aid_type") == 99) # All aid types
& (pl.col("ftpt").is_in([1, 2])) # FT and PT separately
)
.select("unitid", "ftpt", "completion_rate_8yr", "transfer_rate_8yr")
)
```
```r
library(arrow)
library(dplyr)
# Mirror root + pinned revision (keep in sync with education-data-query
# references/mirrors.yaml: HF root_url + vintage.hf_revision). "vintage" = a dated
# Portal snapshot; "revision" = the HF git ref pinning byte-exact bytes.
MIRROR <- "https://huggingface.co/datasets/brhkim/education_data_portal_mirror_2026q3/resolve"
REVISION <- "0ad00ce0e232c96b0642459e4e7326607a8d26aa" # immutable commit SHA of the v2 upload
url <- paste0(MIRROR, "/", REVISION, "/ipeds/colleges_ipeds_outcome-measures.parquet")
# NOTE: illustrative only — mirror parquet files are Polars-written and may
# declare string_view columns, so a plain read can fail under R arrow
# ("cannot handle Array of type <utf8_view>"). Real fetch scripts must use the
# view-safe parquet read from `education-data-query/references/fetch-patterns.md`.
df <- read_parquet(url)
# 8-year completion rates by enrollment intensity for first-time students
# NOTE: outcome-measures content on this vintage ends at 2021 (covers 2015-2021);
# there is no 2022 in this file, so filter the latest available year, 2021.
om <- df |>
filter(
year == 2021,
class_level == 1,
fed_aid_type == 99,
ftpt %in% c(1, 2)
) |>
select(unitid, ftpt, completion_rate_8yr, transfer_rate_8yr)
```
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |