首页Home / 项目全集Selected work

项目全集Selected work

8 个项目,按「含金量 40% + 完成度 30% + 岗位匹配度 30%」的加权分排列。评分口径写在表下,每一项的数字都能在对应仓库的结果文件里查到;排序靠后的项目同样列出——筛选与排序本身就是分析工作的一部分。 Eight projects, ordered by a weighted score (substance 40% + completeness 30% + role fit 30%). The rubric sits below the table, every figure traces to a results file in its repo, and the lower-ranked projects are listed too — screening and ranking are part of the analytical work.

01排序Ranking

三维评分与排序结果Three-dimension scoring and final order

表 1Table 1 · 项目三维评分与加权排序(评分口径见下方表注) Three-dimension scoring and weighted ranking of all eight projects (rubric in the table note below)
# 项目Project 性质Type 含金量Substance 完成度Complete 匹配度Role fit 加权Weighted 仓库Repo
1 企业破产预警「白盒」模型White-box bankruptcy warning modelHigh-dim screening · SCAD 竞赛 · 统计建模大赛Competition 4.05.05.0 4.60 GitHub
2 广深家用智能健康设备市场调查Home smart-health devices market surveySampling · segmentation · SEM 竞赛(省一)+ 省级大创Competition + innovation project 4.54.84.5 4.59 委托项目,暂不公开Client work — private
3 GCor-SIS 超高维稳健特征筛选论文项目GCor-SIS robust screeningpaperModel-free screening · survival 科研 · SCI 审稿中Research · under review 5.04.53.5 4.40 审稿中,暂不公开Withheld
4 北京住房价格特征价格模型Beijing housing hedonic modelRegression diagnostics 课程论文Course paper 3.55.04.5 4.25 GitHub
5 AI 采纳与生产率因果推断(DML)AI adoption & productivity (DML)Causal inference · CATE 自主研究Independent research 4.04.54.0 4.15 GitHub
6 电商用户行为漏斗分析与转化建模电商项目E-commerce funnel analysise-commerceSQL · funnel · effect size 自主复现 + 深挖Reproduction + extension 2.03.05.0 3.20 GitHub
7 影评情感分析与四模型对比Sentiment analysis: four-model comparisonNLP · model comparison 课程论文Course paper 2.53.52.5 2.80 GitHub
8 THUCNews 中文新闻分类(LSTM vs 朴素贝叶斯)THUCNews classification (LSTM vs NB)Deep learning · baseline audit 课程论文Course paper 2.04.02.0 2.60 GitHub

评分口径Scoring rubric · 本人自评(1–5 分),非外部认证。含金量 = 稀缺性 × 难度 × 背书(5 分:SCI 投稿 / 国家级奖项 / 方法创新 + 导师背书;4 分:省级一等奖 / 自主提出研究问题;3 分:省级三等奖 / 优秀课程作业;2 分:练习复现类,无外部背书)。完成度 = 可交付 × 可复现 × 闭环(5 分:论文 + 代码 + 结果全落盘,数字可逐项核验)。岗位匹配度 = 对数据科学 / 数据分析岗的直接对口程度(5 分:SQL + 业务指标 + 归因 + 实验)。加权 = 含金量 × 0.4 + 完成度 × 0.3 + 匹配度 × 0.3。 All scores are my own self-assessment (1–5), not external accreditation. Substance = scarcity × difficulty × endorsement (5: SCI submission / national award / methodological novelty with supervisor backing; 4: provincial 1st prize / self-posed research question; 3: provincial 3rd prize / strong coursework; 2: reproduction with no external endorsement). Completeness = deliverable × reproducibility × closure (5: paper + code + every result persisted and checkable). Role fit = directness of match to a data science / analytics role (5: SQL + business metrics + attribution + experimentation). Weighted = substance × 0.4 + completeness × 0.3 + role fit × 0.3.

含金量最高的是第 3 名The highest-substance project ranks third

GCor-SIS 的含金量是全项目最高的 5.0,但它是纯科研:没有业务语境,也没有指标体系,对数据分析岗的匹配度只有 3.5。企业破产预警排在前面,是因为它同时踩住三条线——学术上有省级奖项背书,工程上有 20 张可核验的结果表与 Rcpp 并行优化,业务上有代价敏感决策与利润测算。 GCor-SIS scores the highest substance (5.0), but it is pure research: no business context, no metric system, and only 3.5 on role fit. The bankruptcy model ranks first because it hits all three lines at once — a provincial award for substance, 20 checkable result tables plus Rcpp parallelism for engineering, and cost-sensitive decisions with profit projections for business.

第 2 名与第 1 名相差 0.01 分No. 2 trails No. 1 by 0.01

市场调查有三个别的项目没有的东西:企业委托(不是自选题目)、一手数据(841 + 476 分钟访谈、747 + 444 份问卷、4,000 条评论,全部自采)、以及完整闭环(抽样设计 → 数据分析 → 人群细分 → SEM 决策路径 → 分市场策略 → 路演答辩 → 大创结项)。这条链路上每一环都有产出,它也是最适合讲成完整案例的一个。 The market survey has three things the others lack: a client commission (not a self-chosen topic), first-hand data (841 + 476 minutes of interviews, 747 + 444 questionnaires, 4,000 reviews — all self-collected), and a complete loop (sampling design → analysis → segmentation → SEM decision path → market-specific strategy → pitch → project completion). Every link in that chain produced an artefact, which makes it the easiest project to tell as a full case study.

第 6 名的岗位匹配度是唯一满分:SQL 取数、指标体系、漏斗归因、转化建模,正是数据分析岗的日常。它排位靠后,原因是公开项目复现、完成度还在 3.0——这是目前性价比最高的一块补强,补齐后可直接进入前四。 No. 6 holds the only perfect role-fit score: SQL querying, metric definitions, funnel attribution and conversion modelling are exactly an analyst's day job. It sits low because it reproduces a public project and its completeness is still 3.0 — the cheapest gap to close right now, and closing it moves the project into the top four.

02按岗位By role

同一批项目,投不同岗位时排序不同The same projects, re-ordered by target role

如果招的不是数据岗,或者想看的是另一个侧面,下表说明我会怎么裁剪重点。 If you are hiring for something other than a data role, or want a different angle, this table shows how I would re-cut the emphasis.

表 2Table 2 · 按目标岗位裁剪的项目优先级 Project priority by target role
目标岗位Target role 建议排序Priority order 说明What it shows
数据分析 / 商业分析Data / business analytics 市场调查 → 电商漏斗 → 破产预警 → 房产回归Market survey → funnel → bankruptcy → housing 强调「业务问题 → 口径 → 结论 → 建议」的闭环;破产预警用来补技术深度,GCor-SIS 压缩成一行方法学背书。The business-question → definition → conclusion → recommendation loop; the bankruptcy model adds technical depth and GCor-SIS shrinks to a one-line methodological credential.
数据科学 / 算法工程Data science / ML engineering 破产预警 → GCor-SIS → DML → 市场调查Bankruptcy → GCor-SIS → DML → market survey 强调高维、稀疏、不平衡、可复现;市场调查用来证明业务侧也能承接。High-dimensionality, sparsity, imbalance and reproducibility; the market survey shows the business side is covered too.
AI 产品运营 / 增长AI product ops / growth 市场调查 → 电商漏斗 → 破产预警Market survey → funnel → bankruptcy 市场调查是唯一具备「用户洞察 → 可执行策略」完整链条的项目,最对口;方法论细节全部淡化。The market survey is the only project with a full insight-to-action chain; methodological detail is dialled right down.
研究岗 / 升学申请Research / graduate applications GCor-SIS → DML → 破产预警 → 房产回归GCor-SIS → DML → bankruptcy → housing 强调 SCI 投稿、引理证明、从零自学 R 实现算法、蒙特卡洛设计与估计量手写实现。SCI submission, lemma proofs, a self-taught R implementation, Monte Carlo design and hand-written estimators.

03全部项目All projects

8 个项目,每个都能指到结果文件Eight projects, each traceable to its results

01统计建模大赛Competition

企业破产预警「白盒」模型White-box corporate bankruptcy warning model

2026-06 · 广东省三等奖 · 第一完成人3rd Prize, Guangdong · lead author

94 个财务指标 → 显式 31,616 维交互空间 → 稳健筛选 → 代价敏感 SCAD,在保住逐条可解释性的前提下逼近机器学习精度。 94 financial ratios → an explicit 31,616-dim interaction space → robust screening → cost-sensitive SCAD: near machine-learning accuracy while every feature stays interpretable.

  • 测试集 AUC 0.9380;LightGBM 基线 0.9404(91 个特征)Test AUC 0.9380 vs 0.9404 for a 91-feature LightGBM baseline
  • 16 个非零特征中 15 个是交互项;漏报 / 误杀成本比 30.5 : 115 of 16 surviving features are interactions; miss / false-alarm cost ratio 30.5 : 1
02市场调查 · 省一Market research

广深两地家用智能健康设备市场调查Home smart-health devices in Guangzhou & Shenzhen

2025-04 · 省级一等奖 · 核心成员(数据模块)1st Prize, Guangdong · core member (data)

企业委托的一手数据调研:不等概率抽样、双问卷发放、加权 K-Means 人群细分、SEM 决策路径,落到分市场策略建议。 A client-commissioned survey on first-hand data: unequal-probability sampling, two questionnaire waves, weighted K-Means segmentation, an SEM decision path — down to market-specific recommendations.

  • 21 个街道 · 有效问卷 747 + 444 份 · 访谈 841 + 476 分钟21 subdistricts · 747 + 444 valid questionnaires · 841 + 476 interview minutes
  • 三类人群 13.19% / 56.35% / 30.46%;SEM 解释方差 68.7%,α = 0.983Three segments 13.19% / 56.35% / 30.46%; SEM explained 68.7%, α = 0.983
委托项目,底稿涉密Client work — private
03论文项目 · SCI 审稿中Paper · under review

GCor-SIS:超高维生存数据的稳健特征筛选GCor-SIS: robust screening for ultrahigh-dimensional survival data

2026-05 · 第二作者 · 中国人民大学全国高校本科生统计论坛报告Second author · presented at Renmin University

参与提出基于格罗滕迪克相关的无模型筛选方法,引入数据拆分反射控制 FDR,并推广到生存数据。负责部分引理证明、R 从零实现、蒙特卡洛模拟与论文主笔。 A model-free screener built on Grothendieck's correlation with a data-splitting reflection for FDR control, extended to survival data. I proved part of the key lemmas, implemented it in R from scratch, ran the Monte Carlo study and wrote the paper.

  • 强筛选一致性的证明无需次指数尾部条件;FDR ≤ α + o(1)Consistency proved without sub-exponential tail conditions; FDR ≤ α + o(1)
  • NKI295 真实数据 C-index 0.7603(对比方法中最高)On NKI295, C-index 0.7603 — highest among competitors
论文审稿中,代码暂不公开Code withheld pending review
04课程论文Course paper

北京住房价格:特征价格模型与多元回归实证Beijing housing prices: a hedonic model

现代回归分析 · 独立完成Modern Regression Analysis · sole author

带时间—区域双向固定效应的半对数特征价格模型,量化两个会被朴素统计系统性误读的效应,并完成 VIF、异方差、强影响点全流程诊断。 A semi-log hedonic model with two-way fixed effects, quantifying two effects that naive statistics systematically misread, with full VIF, heteroscedasticity and influence diagnostics.

  • 318,160 条成交记录 · 64 个特征 · 近地铁溢价 27.6% → 5.8%318,160 transactions · 64 features · subway premium 27.6% → 5.8%
  • R² 0.8185;更精确的多项式模型因条件数 1.11 × 1012 被否R² 0.8185; a more accurate polynomial model rejected at a condition number of 1.11 × 1012
05自主研究Independent

AI 采纳与生产率:双重机器学习因果推断AI adoption & productivity: double/debiased ML

工作论文 · 独立完成(含 LaTeX 论文与代码)Working paper · sole author (LaTeX + code)

15 万家企业微观数据上,手写 Neyman 正交评分与交叉拟合,估计 AI 采纳对劳动生产率的因果效应并做异质性分析。主要结论是一次不显著的零效应。 On 150,000 firms, a hand-written Neyman-orthogonal score with cross-fitting estimates the causal effect of AI adoption on productivity, plus heterogeneity analysis. The headline result is an insignificant null.

  • ATE = +0.6%(p = 0.342);LASSO / RF / XGBoost 三法一致ATE = +0.6% (p = 0.342); consistent across LASSO / RF / XGBoost
  • CATE 标准差 0.044(≈ ATE 的 8 倍);46.1% 企业 CATE > 0.01CATE sd 0.044 (≈ 8× the ATE); 46.1% of firms have CATE > 0.01
06电商项目 · 对口度满分E-commerce · best role fit

电商用户行为漏斗分析与转化建模E-commerce funnel analysis and conversion modelling

公开项目批判式复现与深挖 · 独立完成Critical reproduction and extension · sole author

MySQL 建库取数、漏斗拆解、效应量检验与转化建模,并指出最亮眼的那个指标存在循环论证,不能作为运营抓手。 MySQL ingestion and querying, funnel decomposition, effect-size testing and conversion modelling — then flagging that the most striking indicator is circular and cannot be used as a lever.

  • 10 万条会话 → 清洗后 97,274;最大流失环节转化率 12.63%(流失 41,870 次)100k sessions → 97,274; the bottleneck step converts at 12.63% (41,870 lost)
  • 卡方 + BH 校正 + Cramér's V;仅活跃度 V = 0.2657 有实质关联;AUC 0.6939Chi-square + BH + Cramér's V; only engagement (V = 0.2657) carries real association; AUC 0.6939
07课程论文Course paper

影评情感分析与四模型对比Film-review sentiment analysis: four models compared

大数据分析 · 独立完成Big-data analysis · sole author

2,400 条豆瓣短评上对比朴素贝叶斯、逻辑回归、SVM、LSTM 四个模型,并核查 SnowNLP 词典法与自训练模型的标签口径冲突——结论的价值在于数据质量核查。 Four models (naive Bayes, logistic regression, SVM, LSTM) compared on 2,400 Douban reviews, plus an audit of the label mismatch between SnowNLP's lexicon method and the trained models — its value lies in data-quality vigilance.

  • 四模型 5 折交叉验证 acc 0.6325–0.7587(训练集 0.9569–0.9803,过拟合明显)5-fold CV accuracy 0.6325–0.7587 (training 0.9569–0.9803 — clear overfitting)
  • SnowNLP 把 61.95% 的差评误判为正;「一般」与「差评」标签重合 Jaccard = 1.000SnowNLP mislabels 61.95% of negative reviews; the “average” and “negative” labels overlap with Jaccard = 1.000
08课程论文Course paper

THUCNews 中文新闻分类:LSTM vs 朴素贝叶斯THUCNews classification: LSTM vs naive Bayes

自然语言处理 · 独立完成NLP · sole author

20 万条新闻、10 个类别上的深度模型与传统基线对照。真正的发现不是 LSTM 更准,而是基线的分词修正后差距从 59 个百分点缩到 2.1 个百分点——基线没调好时的对比会严重高估深度学习带来的收益。 A deep model against a classical baseline on 200,000 news articles across 10 classes. The real finding is not that LSTM wins, but that fixing the baseline's tokenisation shrank the gap from 59 to 2.1 percentage points — an untuned baseline badly overstates the benefit of deep learning.

  • LSTM 测试 acc 0.8868;朴素贝叶斯 0.2967 → 分词修正后 0.8658LSTM test acc 0.8868; naive Bayes 0.2967 → 0.8658 after fixing tokenisation
  • 差距从 59 pp 修正为 2.10 ppGap corrected from 59 pp to 2.10 pp

04技能矩阵Skill matrix

技能 → 证据项目 → 实际用到的深度Skill → evidence project → depth actually used

表 3Table 3 · 按项目反推的技能矩阵,可用于核验简历「技能」栏的每一行 A skill matrix reverse-engineered from the projects, so every line of a CV can be checked
技能Skill 证据项目Evidence 实际用到的深度Depth actually used
R GCor-SIS、破产预警、市场调查GCor-SIS, bankruptcy, market survey 能写 Rcpp C++ 扩展、20 核并行、控制内存峰值Rcpp C++ extensions, 20-core parallelism, memory-peak control
Python 房产回归、DML、电商漏斗、NLP 项目、市场调查Housing, DML, funnel, NLP, market survey pandas / numpy 数据管线、statsmodels 计量诊断、scikit-learn、PyTorchpandas / numpy pipelines, statsmodels diagnostics, scikit-learn, PyTorch
SQL 电商漏斗(24 条查询)、计算机二级 MySQLFunnel (24 queries), Level-2 MySQL certificate MySQL 8.0 显式 DDL、窗口函数算占比;CTE / 留存取数在补MySQL 8.0 explicit DDL, window functions for shares; CTE / retention querying in progress
LaTeX DML 论文、房产回归论文、THUCNews 论文DML, housing and THUCNews papers 公式推导、三线表、代码附录、XeLaTeX 两遍编译Derivations, booktabs tables, code appendices, two-pass XeLaTeX builds
SPSS / AMOS 市场调查Market survey 问卷信效度全套(Cronbach's α、KMO、Bartlett)+ SEM 建模 + 简单斜率图Full reliability/validity battery (α, KMO, Bartlett) + SEM + simple-slope plots
统计方法Statistical methods 全部项目All projects 特征筛选(SIS / SCAD)、惩罚回归、生存分析、因果推断(DML / 因果森林)、回归诊断、抽样设计、列联表与效应量、聚类Screening (SIS / SCAD), penalized regression, survival analysis, causal inference (DML / causal forests), regression diagnostics, sampling design, contingency tables and effect size, clustering
工程实践Engineering practice 破产预警、房产回归、DML、THUCNewsBankruptcy, housing, DML, THUCNews 脚本编号化 + 自包含、随机种子固定、结果落盘 CSV、代码与结论分离、Git / GitHubNumbered self-contained scripts, fixed seeds, results exported to CSV, code separated from conclusions, Git / GitHub

诚实的空白Honest gaps · 还没有实际用过的:Docker / 服务部署、API 调用与 RAG / Agent 工作流、A/B 实验设计、SQL 留存与漏斗自连接取数。这些没有写进技能栏,正在补。 Not yet used in practice: Docker / deployment, API calls and RAG / agent workflows, A/B experiment design, retention and self-join funnel SQL. None of these appear in my skills section; they are being built.

05下一步Next

想看看代码,或者聊聊某个项目?Want to read the code, or talk through a project?

每个公开仓库的 README 都写了方法、复现步骤与已知局限;如果关心的是某个具体环节,告诉我,我可以把对应脚本和结果表的位置发给你。 Every public repo's README documents the method, reproduction steps and known limitations. If a specific step interests you, tell me and I will point you to the exact script and result table.