xtl/python----
6
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
python----/北川/赛选新增学生.ipynb
T
admin aac9f5934d feat: 添加多个功能模块和工具脚本 
- 新增websocket客户端和服务端实现
- 添加图片压缩工具和快速压缩脚本
- 实现学生信息处理相关API
- 添加MQTT客户端和消息处理功能
- 更新.gitignore忽略更多文件类型
- 添加数据库操作工具和示例
- 实现多个测试脚本和工具类
2026-04-13 14:47:50 +08:00

631 lines
22 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "dd7947a8",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "b6ac03f8",
"metadata": {},
"outputs": [],
"source": [
"df = pd.read_excel(\"./在校生综合信息查询20251020.xls\")"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "7339d4d0",
"metadata": {},
"outputs": [],
"source": [
"df =df.astype(str)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "baa3220b",
"metadata": {},
"outputs": [],
"source": [
"df1= pd.read_excel(\"./在校生综合信息查询.xlsx\")\n"
]
},
{
"cell_type": "code",
"execution_count": 17,
"id": "baa0e866",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>身份证件号</th>\n",
" <th>姓名</th>\n",
" <th>性别</th>\n",
" <th>出生日期</th>\n",
" <th>民族</th>\n",
" <th>籍贯</th>\n",
" <th>户口性质</th>\n",
" <th>学生类别</th>\n",
" <th>入学年月</th>\n",
" <th>学校名称</th>\n",
" <th>...</th>\n",
" <th>电子信箱</th>\n",
" <th>英文姓名</th>\n",
" <th>姓名拼音</th>\n",
" <th>省</th>\n",
" <th>市</th>\n",
" <th>县</th>\n",
" <th>学习形式</th>\n",
" <th>专业简称</th>\n",
" <th>在校生状态</th>\n",
" <th>健康状况</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>510726200805055219</td>\n",
" <td>韩震</td>\n",
" <td>男</td>\n",
" <td>20080505</td>\n",
" <td>羌族</td>\n",
" <td>四川省绵阳市北川羌族自治县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202309</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>HanZhen</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>数字媒体技术应用（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>510704200802282127</td>\n",
" <td>胥倩文</td>\n",
" <td>女</td>\n",
" <td>20080228</td>\n",
" <td>汉族</td>\n",
" <td>四川省绵阳市游仙区</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202309</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>XuQingWen</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>数字媒体技术应用（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>513332200405011637</td>\n",
" <td>四郎</td>\n",
" <td>男</td>\n",
" <td>20040501</td>\n",
" <td>藏族</td>\n",
" <td>四川省甘孜藏族自治州石渠县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202309</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>SiLang</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>数字媒体技术应用（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>513327200706166519</td>\n",
" <td>东红丹巴达吉</td>\n",
" <td>男</td>\n",
" <td>20070616</td>\n",
" <td>藏族</td>\n",
" <td>四川省甘孜藏族自治州炉霍县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202309</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>DongHongDanBaDaJi</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>数字媒体技术应用（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>513333200805241614</td>\n",
" <td>尼谢交</td>\n",
" <td>男</td>\n",
" <td>20080524</td>\n",
" <td>藏族</td>\n",
" <td>四川省甘孜藏族自治州色达县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202309</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>NiXieJiao</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>数字媒体技术应用（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2977</th>\n",
" <td>510726201003181410</td>\n",
" <td>杨马浩</td>\n",
" <td>男</td>\n",
" <td>20100318</td>\n",
" <td>羌族</td>\n",
" <td>四川省绵阳市北川羌族自治县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202509</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>YangMaHao</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>智能设备运行与维护（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2978</th>\n",
" <td>510724201007141616</td>\n",
" <td>杨逸晨</td>\n",
" <td>男</td>\n",
" <td>20100714</td>\n",
" <td>汉族</td>\n",
" <td>四川省绵阳市安县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202509</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>YangYiChen</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>智能设备运行与维护（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2979</th>\n",
" <td>510724201005172056</td>\n",
" <td>张文博</td>\n",
" <td>男</td>\n",
" <td>20100517</td>\n",
" <td>汉族</td>\n",
" <td>四川省绵阳市安县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202509</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>ZhangWenBo</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>智能设备运行与维护（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2980</th>\n",
" <td>50022820100822337X</td>\n",
" <td>张玺毓</td>\n",
" <td>男</td>\n",
" <td>20100822</td>\n",
" <td>汉族</td>\n",
" <td>重庆市梁平县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202509</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>ZhangXiYu</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>智能设备运行与维护（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2981</th>\n",
" <td>510724201007140816</td>\n",
" <td>张宇鹏</td>\n",
" <td>男</td>\n",
" <td>20100714</td>\n",
" <td>羌族</td>\n",
" <td>四川省绵阳市安县</td>\n",
" <td>农业户口</td>\n",
" <td>职业高中学生</td>\n",
" <td>202509</td>\n",
" <td>北川羌族自治县“七一”职业中学</td>\n",
" <td>...</td>\n",
" <td>nan</td>\n",
" <td>nan</td>\n",
" <td>ZhangYuPeng</td>\n",
" <td>四川省</td>\n",
" <td>绵阳市</td>\n",
" <td>北川羌族自治县</td>\n",
" <td>全日制</td>\n",
" <td>智能设备运行与维护（2021）</td>\n",
" <td>正常在校</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>2982 rows × 42 columns</p>\n",
"</div>"
],
"text/plain": [
" 身份证件号 姓名 性别 出生日期 民族 籍贯 户口性质 \\\n",
"0 510726200805055219 韩震 男 20080505 羌族 四川省绵阳市北川羌族自治县 农业户口 \n",
"1 510704200802282127 胥倩文 女 20080228 汉族 四川省绵阳市游仙区 农业户口 \n",
"2 513332200405011637 四郎 男 20040501 藏族 四川省甘孜藏族自治州石渠县 农业户口 \n",
"3 513327200706166519 东红丹巴达吉 男 20070616 藏族 四川省甘孜藏族自治州炉霍县 农业户口 \n",
"4 513333200805241614 尼谢交 男 20080524 藏族 四川省甘孜藏族自治州色达县 农业户口 \n",
"... ... ... .. ... .. ... ... \n",
"2977 510726201003181410 杨马浩 男 20100318 羌族 四川省绵阳市北川羌族自治县 农业户口 \n",
"2978 510724201007141616 杨逸晨 男 20100714 汉族 四川省绵阳市安县 农业户口 \n",
"2979 510724201005172056 张文博 男 20100517 汉族 四川省绵阳市安县 农业户口 \n",
"2980 50022820100822337X 张玺毓 男 20100822 汉族 重庆市梁平县 农业户口 \n",
"2981 510724201007140816 张宇鹏 男 20100714 羌族 四川省绵阳市安县 农业户口 \n",
"\n",
" 学生类别 入学年月 学校名称 ... 电子信箱 英文姓名 姓名拼音 省 \\\n",
"0 职业高中学生 202309 北川羌族自治县“七一”职业中学 ... nan nan HanZhen 四川省 \n",
"1 职业高中学生 202309 北川羌族自治县“七一”职业中学 ... nan nan XuQingWen 四川省 \n",
"2 职业高中学生 202309 北川羌族自治县“七一”职业中学 ... nan nan SiLang 四川省 \n",
"3 职业高中学生 202309 北川羌族自治县“七一”职业中学 ... nan nan DongHongDanBaDaJi 四川省 \n",
"4 职业高中学生 202309 北川羌族自治县“七一”职业中学 ... nan nan NiXieJiao 四川省 \n",
"... ... ... ... ... ... ... ... ... \n",
"2977 职业高中学生 202509 北川羌族自治县“七一”职业中学 ... nan nan YangMaHao 四川省 \n",
"2978 职业高中学生 202509 北川羌族自治县“七一”职业中学 ... nan nan YangYiChen 四川省 \n",
"2979 职业高中学生 202509 北川羌族自治县“七一”职业中学 ... nan nan ZhangWenBo 四川省 \n",
"2980 职业高中学生 202509 北川羌族自治县“七一”职业中学 ... nan nan ZhangXiYu 四川省 \n",
"2981 职业高中学生 202509 北川羌族自治县“七一”职业中学 ... nan nan ZhangYuPeng 四川省 \n",
"\n",
" 市 县 学习形式 专业简称 在校生状态 健康状况 \n",
"0 绵阳市 北川羌族自治县 全日制 数字媒体技术应用（2021） 正常在校 1 \n",
"1 绵阳市 北川羌族自治县 全日制 数字媒体技术应用（2021） 正常在校 2 \n",
"2 绵阳市 北川羌族自治县 全日制 数字媒体技术应用（2021） 正常在校 1 \n",
"3 绵阳市 北川羌族自治县 全日制 数字媒体技术应用（2021） 正常在校 1 \n",
"4 绵阳市 北川羌族自治县 全日制 数字媒体技术应用（2021） 正常在校 1 \n",
"... ... ... ... ... ... ... \n",
"2977 绵阳市 北川羌族自治县 全日制 智能设备运行与维护（2021） 正常在校 1 \n",
"2978 绵阳市 北川羌族自治县 全日制 智能设备运行与维护（2021） 正常在校 1 \n",
"2979 绵阳市 北川羌族自治县 全日制 智能设备运行与维护（2021） 正常在校 1 \n",
"2980 绵阳市 北川羌族自治县 全日制 智能设备运行与维护（2021） 正常在校 1 \n",
"2981 绵阳市 北川羌族自治县 全日制 智能设备运行与维护（2021） 正常在校 1 \n",
"\n",
"[2982 rows x 42 columns]"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "46443947",
"metadata": {},
"outputs": [],
"source": [
"names = '''嘎玛丁杰\n",
"孙振涛\n",
"张宏\n",
"曲扎\n",
"朱晴源\n",
"李学涛\n",
"李治李\n",
"杨涵熙\n",
"杨瑞昕\n",
"甘佳馨\n",
"罗雨霏\n",
"肖潇\n",
"苏胜步\n",
"蒲弘垣\n",
"贾惠青\n",
"邓城林\n",
"陈祝遥加\n",
"陈飞扬\n",
"韦浩添\n",
"黎席伟'''.split(\"\\n\")"
]
},
{
"cell_type": "code",
"execution_count": 21,
"id": "54ebb990",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n",
"Series([], Name: 姓名, dtype: object)\n"
]
}
],
"source": [
"for item in names:\n",
" print(df.loc[df['姓名']==item,'姓名'])"
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "c039a73f",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0 510726200805055219\n",
"1 510704200802282127\n",
"2 513332200405011637\n",
"3 513327200706166519\n",
"4 513333200805241614\n",
" ... \n",
"2977 510726201003181410\n",
"2978 510724201007141616\n",
"2979 510724201005172056\n",
"2980 50022820100822337X\n",
"2981 510724201007140816\n",
"Name: 身份证件号, Length: 2982, dtype: object"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['身份证件号']"
]
},
{
"cell_type": "code",
"execution_count": 22,
"id": "9d88637a",
"metadata": {},
"outputs": [],
"source": [
"a =df1['身份证件号']\n",
"b = df['身份证件号']\n"
]
},
{
"cell_type": "code",
"execution_count": 24,
"id": "d875c809",
"metadata": {},
"outputs": [],
"source": [
"a = df1['身份证件号'].astype(str).str.strip()\n",
"b = df['身份证件号'].astype(str).str.strip()\n",
"diff_values = b[~b.isin(a)].drop_duplicates()"
]
},
{
"cell_type": "code",
"execution_count": 25,
"id": "42939b6f",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Series([], Name: 身份证件号, dtype: object)"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"diff_values"
]
},
{
"cell_type": "code",
"execution_count": 15,
"id": "7f52438a",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"set()"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"set(b)-set(a)"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "f32dec2e",
"metadata": {},
"outputs": [],
"source": [
"嘎玛丁杰\n",
"孙振涛\n",
"张宏\n",
"曲扎\n",
"朱晴源\n",
"李学涛\n",
"李治李\n",
"杨涵熙\n",
"杨瑞昕\n",
"甘佳馨\n",
"罗雨霏\n",
"肖潇\n",
"苏胜步\n",
"蒲弘垣\n",
"贾惠青\n",
"邓城林\n",
"陈祝遥加\n",
"陈飞扬\n",
"韦浩添\n",
"黎席伟"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.12.4"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Reference in New Issue View Git Blame Copy Permalink