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

1111 lines
71 KiB
Plaintext
Raw Permalink Blame History

{
"cells": [
{
"cell_type": "code",
"execution_count": 10,
"id": "bae0db67",
"metadata": {},
"outputs": [],
"source": [
"from requests import get,post,put\n",
"import pandas as pd\n",
"import time\n",
"teamId = 106\n",
"# ip = \"http://192.168.0.244:8101\"\n",
"ip = \"http://10.143.25.3:8090\"\n",
"param = {\n",
" \"username\": \"tangchao\",\n",
" \"password\": \"123456a\",\n",
" \"client_id\": \"client\",\n",
" \"grant_type\": \"password\",\n",
" \"client_secret\": \"123456\",\n",
"}\n",
"data = get(url=f\"{ip}/oauth/token\",params=param).json()\n",
"token = data[\"access_token\"]\n",
"header = {\n",
" \"content-type\": \"application/json\",\n",
" \"authorization\": f\"Bearer {token}\",\n",
"}"
]
},
{
"cell_type": "code",
"execution_count": 11,
"id": "563802dc",
"metadata": {},
"outputs": [],
"source": [
"data = get(f\"{ip}/classAndRoom/listPage?teamId=106&page=1&pageSize=100&pageNumber=0\",headers=header).json()[\"data\"][\"records\"]\n",
"rooms = []\n",
"for item in data:\n",
" if item.get('classAndRooms',[]):\n",
" rooms.append(item['classAndRooms'][0]['roomName'])"
]
},
{
"cell_type": "code",
"execution_count": 12,
"id": "e3422c91",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['5-303',\n",
" '1-210',\n",
" '5-304',\n",
" '1-202',\n",
" '2-202',\n",
" '5-307',\n",
" '1-203',\n",
" '1-206',\n",
" '1-205',\n",
" '1-309',\n",
" '2-203',\n",
" '1-207',\n",
" '2-205',\n",
" '2-209',\n",
" '2-206',\n",
" '1-406',\n",
" '1-209',\n",
" '2-408',\n",
" '2-306',\n",
" '9-308',\n",
" '2-309',\n",
" '2-401',\n",
" '2-406',\n",
" '2-403',\n",
" '2-302',\n",
" '2-303',\n",
" '2-304',\n",
" '2-409',\n",
" '2-402',\n",
" '2-405',\n",
" '2-305',\n",
" '涂装实训室对面']"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"rooms"
]
},
{
"cell_type": "code",
"execution_count": 13,
"id": "c7fdd07d",
"metadata": {},
"outputs": [],
"source": [
"times = ['8:25-9:05','9:15-9:55','9:55-10:30','10:30-11:10','14:55-15:35','15:45-16:25','16:35-17:15','18:50-19:30','19:40-20:20',\"20:30-21:00\"]"
]
},
{
"cell_type": "code",
"execution_count": 16,
"id": "c8947925",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[{'className': '2506电商升学',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 693,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2524汽修2班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 694,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 12,\n",
" 'classId': 694,\n",
" 'roomId': 306,\n",
" 'roomName': '5-303'}]},\n",
" {'className': '2525汽修3班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 695,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 13,\n",
" 'classId': 695,\n",
" 'roomId': 301,\n",
" 'roomName': '1-210'}]},\n",
" {'className': '2523汽修1班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 696,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 14,\n",
" 'classId': 696,\n",
" 'roomId': 305,\n",
" 'roomName': '5-304'}]},\n",
" {'className': '2514旅游升学',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 697,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 15,\n",
" 'classId': 697,\n",
" 'roomId': 245,\n",
" 'roomName': '1-202'}]},\n",
" {'className': '2521融通9班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 698,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2522融通10班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 699,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2519数字媒体2班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 700,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 17,\n",
" 'classId': 700,\n",
" 'roomId': 267,\n",
" 'roomName': '2-202'}]},\n",
" {'className': '2518数字媒体1班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 701,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 16,\n",
" 'classId': 701,\n",
" 'roomId': 307,\n",
" 'roomName': '5-307'}]},\n",
" {'className': '2528智慧服务',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 702,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 18,\n",
" 'classId': 702,\n",
" 'roomId': 246,\n",
" 'roomName': '1-203'}]},\n",
" {'className': '2511融通4班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 703,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2517融通8班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 704,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2512融通5班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 705,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2516融通7班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 706,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2526汽修4班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 707,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2505融通1班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 708,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2508会计升学',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 709,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2529融通11班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 710,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2530智维升学',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 711,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 26,\n",
" 'classId': 711,\n",
" 'roomId': 249,\n",
" 'roomName': '1-206'}]},\n",
" {'className': '2527运动训练',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 712,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2513融通6班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 713,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2503五年制数字媒体',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 714,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 20,\n",
" 'classId': 714,\n",
" 'roomId': 248,\n",
" 'roomName': '1-205'}]},\n",
" {'className': '2515音乐舞蹈',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 715,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 21,\n",
" 'classId': 715,\n",
" 'roomId': 309,\n",
" 'roomName': '1-309'}]},\n",
" {'className': '2520数字媒体3班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 716,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2501五年制会计',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 717,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 22,\n",
" 'classId': 717,\n",
" 'roomId': 268,\n",
" 'roomName': '2-203'}]},\n",
" {'className': '2507融通2班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 718,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2531一年制',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 719,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2510建筑升学',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 720,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 24,\n",
" 'classId': 720,\n",
" 'roomId': 250,\n",
" 'roomName': '1-207'}]},\n",
" {'className': '2502五年制建筑',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 721,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2504五年制汽修',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 722,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 25,\n",
" 'classId': 722,\n",
" 'roomId': 270,\n",
" 'roomName': '2-205'}]},\n",
" {'className': '2509融通3班',\n",
" 'gradeName': '2025级',\n",
" 'gradeId': 322,\n",
" 'classIds': 723,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2422汽修2班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 724,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2420融通7班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 725,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2411融通3班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 726,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2409会计升学',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 727,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2418数媒1班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 728,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2421汽修1班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 729,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2414旅游升学',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 730,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2427智维升学',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 731,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2406融通1班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 732,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2408融通2班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 733,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2407电商升学',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 734,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2402五年制会计',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 735,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 27,\n",
" 'classId': 735,\n",
" 'roomId': 274,\n",
" 'roomName': '2-209'}]},\n",
" {'className': '2417融通6班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 736,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2424运动训练',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 737,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 28,\n",
" 'classId': 737,\n",
" 'roomId': 271,\n",
" 'roomName': '2-206'}]},\n",
" {'className': '2410建筑升学',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 738,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2423汽修3班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 739,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2419数媒2班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 740,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2413融通5班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 741,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2425智慧服务',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 742,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 29,\n",
" 'classId': 742,\n",
" 'roomId': 264,\n",
" 'roomName': '1-406'}]},\n",
" {'className': '2426融通8班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 743,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2415舞蹈',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 744,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 30,\n",
" 'classId': 744,\n",
" 'roomId': 310,\n",
" 'roomName': '1-209'}]},\n",
" {'className': '2404五年制数媒',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 745,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2405五年制汽修',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 746,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2403五年制建筑',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 747,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2401五年制电子',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 748,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2416音乐',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 749,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2412融通4班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 750,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2418数字媒体1班',\n",
" 'gradeName': '2024级',\n",
" 'gradeId': 326,\n",
" 'classIds': 751,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2322数字媒体',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 752,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 31,\n",
" 'classId': 752,\n",
" 'roomId': 290,\n",
" 'roomName': '2-408'}]},\n",
" {'className': '2317汽修2班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 753,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 32,\n",
" 'classId': 753,\n",
" 'roomId': 297,\n",
" 'roomName': '2-306'}]},\n",
" {'className': '2309旅游升学',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 754,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 33,\n",
" 'classId': 754,\n",
" 'roomId': 302,\n",
" 'roomName': '9-308'}]},\n",
" {'className': '2312电商升学',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 755,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 34,\n",
" 'classId': 755,\n",
" 'roomId': 300,\n",
" 'roomName': '2-309'}]},\n",
" {'className': '2316汽修1班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 756,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 35,\n",
" 'classId': 756,\n",
" 'roomId': 311,\n",
" 'roomName': '2-401'}]},\n",
" {'className': '2321建筑升学',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 757,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2306融通1班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 758,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 36,\n",
" 'classId': 758,\n",
" 'roomId': 288,\n",
" 'roomName': '2-406'}]},\n",
" {'className': '2319会计升学',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 759,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2310融通3班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 760,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 37,\n",
" 'classId': 760,\n",
" 'roomId': 285,\n",
" 'roomName': '2-403'}]},\n",
" {'className': '2314智维升学',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 761,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2315融通5班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 762,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2302五年制会计',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 763,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 38,\n",
" 'classId': 763,\n",
" 'roomId': 293,\n",
" 'roomName': '2-302'}]},\n",
" {'className': '2311电商军事',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 764,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 39,\n",
" 'classId': 764,\n",
" 'roomId': 294,\n",
" 'roomName': '2-303'}]},\n",
" {'className': '2304五年制媒体',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 765,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 40,\n",
" 'classId': 765,\n",
" 'roomId': 295,\n",
" 'roomName': '2-304'}]},\n",
" {'className': '2318会计融通',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 766,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 41,\n",
" 'classId': 766,\n",
" 'roomId': 291,\n",
" 'roomName': '2-409'}]},\n",
" {'className': '2301五年制电子',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 767,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2325体育',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 768,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 43,\n",
" 'classId': 768,\n",
" 'roomId': 284,\n",
" 'roomName': '2-402'}]},\n",
" {'className': '2308旅游融通',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 769,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 44,\n",
" 'classId': 769,\n",
" 'roomId': 287,\n",
" 'roomName': '2-405'}]},\n",
" {'className': '2303五年制建筑',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 770,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2323舞蹈',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 771,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 45,\n",
" 'classId': 771,\n",
" 'roomId': 296,\n",
" 'roomName': '2-305'}]},\n",
" {'className': '2326会计2班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 772,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2305五年制汽修',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 773,\n",
" 'teamId': 106,\n",
" 'classAndRooms': [{'id': 42,\n",
" 'classId': 773,\n",
" 'roomId': 312,\n",
" 'roomName': '涂装实训室对面'}]},\n",
" {'className': '2320建筑融通',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 774,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2328数字媒体2班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 775,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2327汽修3班',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 776,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []},\n",
" {'className': '2324音乐',\n",
" 'gradeName': '2023级',\n",
" 'gradeId': 327,\n",
" 'classIds': 777,\n",
" 'teamId': 106,\n",
" 'classAndRooms': []}]"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 48,
"id": "564077c7",
"metadata": {},
"outputs": [],
"source": [
"grade = '25'\n",
"table = []\n",
"for k in times:\n",
" tem = {}\n",
" for i in range(6):\n",
" tem1 = []\n",
" count = 1\n",
" \n",
" for index,p in enumerate(data,start=1):\n",
" if grade in p[\"gradeName\"] and p['classAndRooms'] and len(p['classAndRooms'])>0:\n",
" tem1.append(f\"{k}/语文/{grade}老师{count}/{ p['classAndRooms'][0]['roomName']}/100\") \n",
" count+=1\n",
" tem[f\"星期{i}\"] = ';\\n'.join(tem1)\n",
" table.append(tem)\n",
" tem = {}"
]
},
{
"cell_type": "code",
"execution_count": 49,
"id": "b80963d7",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 50,
"id": "52b14d93",
"metadata": {},
"outputs": [],
"source": [
"df = pd.DataFrame(table)"
]
},
{
"cell_type": "code",
"execution_count": 51,
"id": "850103c2",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[{'星期0': '8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25老师2/1-210/100;\\n8:25-9:05/语文/25老师3/5-304/100;\\n8:25-9:05/语文/25老师4/1-202/100;\\n8:25-9:05/语文/25老师5/2-202/100;\\n8:25-9:05/语文/25老师6/5-307/100;\\n8:25-9:05/语文/25老师7/1-203/100;\\n8:25-9:05/语文/25老师8/1-206/100;\\n8:25-9:05/语文/25老师9/1-205/100;\\n8:25-9:05/语文/25老师10/1-309/100;\\n8:25-9:05/语文/25老师11/2-203/100;\\n8:25-9:05/语文/25老师12/1-207/100;\\n8:25-9:05/语文/25老师13/2-205/100',\n",
" '星期1': '8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25老师2/1-210/100;\\n8:25-9:05/语文/25老师3/5-304/100;\\n8:25-9:05/语文/25老师4/1-202/100;\\n8:25-9:05/语文/25老师5/2-202/100;\\n8:25-9:05/语文/25老师6/5-307/100;\\n8:25-9:05/语文/25老师7/1-203/100;\\n8:25-9:05/语文/25老师8/1-206/100;\\n8:25-9:05/语文/25老师9/1-205/100;\\n8:25-9:05/语文/25老师10/1-309/100;\\n8:25-9:05/语文/25老师11/2-203/100;\\n8:25-9:05/语文/25老师12/1-207/100;\\n8:25-9:05/语文/25老师13/2-205/100',\n",
" '星期2': '8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25老师2/1-210/100;\\n8:25-9:05/语文/25老师3/5-304/100;\\n8:25-9:05/语文/25老师4/1-202/100;\\n8:25-9:05/语文/25老师5/2-202/100;\\n8:25-9:05/语文/25老师6/5-307/100;\\n8:25-9:05/语文/25老师7/1-203/100;\\n8:25-9:05/语文/25老师8/1-206/100;\\n8:25-9:05/语文/25老师9/1-205/100;\\n8:25-9:05/语文/25老师10/1-309/100;\\n8:25-9:05/语文/25老师11/2-203/100;\\n8:25-9:05/语文/25老师12/1-207/100;\\n8:25-9:05/语文/25老师13/2-205/100',\n",
" '星期3': '8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25老师2/1-210/100;\\n8:25-9:05/语文/25老师3/5-304/100;\\n8:25-9:05/语文/25老师4/1-202/100;\\n8:25-9:05/语文/25老师5/2-202/100;\\n8:25-9:05/语文/25老师6/5-307/100;\\n8:25-9:05/语文/25老师7/1-203/100;\\n8:25-9:05/语文/25老师8/1-206/100;\\n8:25-9:05/语文/25老师9/1-205/100;\\n8:25-9:05/语文/25老师10/1-309/100;\\n8:25-9:05/语文/25老师11/2-203/100;\\n8:25-9:05/语文/25老师12/1-207/100;\\n8:25-9:05/语文/25老师13/2-205/100',\n",
" '星期4': '8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25老师2/1-210/100;\\n8:25-9:05/语文/25老师3/5-304/100;\\n8:25-9:05/语文/25老师4/1-202/100;\\n8:25-9:05/语文/25老师5/2-202/100;\\n8:25-9:05/语文/25老师6/5-307/100;\\n8:25-9:05/语文/25老师7/1-203/100;\\n8:25-9:05/语文/25老师8/1-206/100;\\n8:25-9:05/语文/25老师9/1-205/100;\\n8:25-9:05/语文/25老师10/1-309/100;\\n8:25-9:05/语文/25老师11/2-203/100;\\n8:25-9:05/语文/25老师12/1-207/100;\\n8:25-9:05/语文/25老师13/2-205/100',\n",
" '星期5': '8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25老师2/1-210/100;\\n8:25-9:05/语文/25老师3/5-304/100;\\n8:25-9:05/语文/25老师4/1-202/100;\\n8:25-9:05/语文/25老师5/2-202/100;\\n8:25-9:05/语文/25老师6/5-307/100;\\n8:25-9:05/语文/25老师7/1-203/100;\\n8:25-9:05/语文/25老师8/1-206/100;\\n8:25-9:05/语文/25老师9/1-205/100;\\n8:25-9:05/语文/25老师10/1-309/100;\\n8:25-9:05/语文/25老师11/2-203/100;\\n8:25-9:05/语文/25老师12/1-207/100;\\n8:25-9:05/语文/25老师13/2-205/100'},\n",
" {'星期0': '9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25老师2/1-210/100;\\n9:15-9:55/语文/25老师3/5-304/100;\\n9:15-9:55/语文/25老师4/1-202/100;\\n9:15-9:55/语文/25老师5/2-202/100;\\n9:15-9:55/语文/25老师6/5-307/100;\\n9:15-9:55/语文/25老师7/1-203/100;\\n9:15-9:55/语文/25老师8/1-206/100;\\n9:15-9:55/语文/25老师9/1-205/100;\\n9:15-9:55/语文/25老师10/1-309/100;\\n9:15-9:55/语文/25老师11/2-203/100;\\n9:15-9:55/语文/25老师12/1-207/100;\\n9:15-9:55/语文/25老师13/2-205/100',\n",
" '星期1': '9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25老师2/1-210/100;\\n9:15-9:55/语文/25老师3/5-304/100;\\n9:15-9:55/语文/25老师4/1-202/100;\\n9:15-9:55/语文/25老师5/2-202/100;\\n9:15-9:55/语文/25老师6/5-307/100;\\n9:15-9:55/语文/25老师7/1-203/100;\\n9:15-9:55/语文/25老师8/1-206/100;\\n9:15-9:55/语文/25老师9/1-205/100;\\n9:15-9:55/语文/25老师10/1-309/100;\\n9:15-9:55/语文/25老师11/2-203/100;\\n9:15-9:55/语文/25老师12/1-207/100;\\n9:15-9:55/语文/25老师13/2-205/100',\n",
" '星期2': '9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25老师2/1-210/100;\\n9:15-9:55/语文/25老师3/5-304/100;\\n9:15-9:55/语文/25老师4/1-202/100;\\n9:15-9:55/语文/25老师5/2-202/100;\\n9:15-9:55/语文/25老师6/5-307/100;\\n9:15-9:55/语文/25老师7/1-203/100;\\n9:15-9:55/语文/25老师8/1-206/100;\\n9:15-9:55/语文/25老师9/1-205/100;\\n9:15-9:55/语文/25老师10/1-309/100;\\n9:15-9:55/语文/25老师11/2-203/100;\\n9:15-9:55/语文/25老师12/1-207/100;\\n9:15-9:55/语文/25老师13/2-205/100',\n",
" '星期3': '9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25老师2/1-210/100;\\n9:15-9:55/语文/25老师3/5-304/100;\\n9:15-9:55/语文/25老师4/1-202/100;\\n9:15-9:55/语文/25老师5/2-202/100;\\n9:15-9:55/语文/25老师6/5-307/100;\\n9:15-9:55/语文/25老师7/1-203/100;\\n9:15-9:55/语文/25老师8/1-206/100;\\n9:15-9:55/语文/25老师9/1-205/100;\\n9:15-9:55/语文/25老师10/1-309/100;\\n9:15-9:55/语文/25老师11/2-203/100;\\n9:15-9:55/语文/25老师12/1-207/100;\\n9:15-9:55/语文/25老师13/2-205/100',\n",
" '星期4': '9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25老师2/1-210/100;\\n9:15-9:55/语文/25老师3/5-304/100;\\n9:15-9:55/语文/25老师4/1-202/100;\\n9:15-9:55/语文/25老师5/2-202/100;\\n9:15-9:55/语文/25老师6/5-307/100;\\n9:15-9:55/语文/25老师7/1-203/100;\\n9:15-9:55/语文/25老师8/1-206/100;\\n9:15-9:55/语文/25老师9/1-205/100;\\n9:15-9:55/语文/25老师10/1-309/100;\\n9:15-9:55/语文/25老师11/2-203/100;\\n9:15-9:55/语文/25老师12/1-207/100;\\n9:15-9:55/语文/25老师13/2-205/100',\n",
" '星期5': '9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25老师2/1-210/100;\\n9:15-9:55/语文/25老师3/5-304/100;\\n9:15-9:55/语文/25老师4/1-202/100;\\n9:15-9:55/语文/25老师5/2-202/100;\\n9:15-9:55/语文/25老师6/5-307/100;\\n9:15-9:55/语文/25老师7/1-203/100;\\n9:15-9:55/语文/25老师8/1-206/100;\\n9:15-9:55/语文/25老师9/1-205/100;\\n9:15-9:55/语文/25老师10/1-309/100;\\n9:15-9:55/语文/25老师11/2-203/100;\\n9:15-9:55/语文/25老师12/1-207/100;\\n9:15-9:55/语文/25老师13/2-205/100'},\n",
" {'星期0': '9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/25老师2/1-210/100;\\n9:55-10:30/语文/25老师3/5-304/100;\\n9:55-10:30/语文/25老师4/1-202/100;\\n9:55-10:30/语文/25老师5/2-202/100;\\n9:55-10:30/语文/25老师6/5-307/100;\\n9:55-10:30/语文/25老师7/1-203/100;\\n9:55-10:30/语文/25老师8/1-206/100;\\n9:55-10:30/语文/25老师9/1-205/100;\\n9:55-10:30/语文/25老师10/1-309/100;\\n9:55-10:30/语文/25老师11/2-203/100;\\n9:55-10:30/语文/25老师12/1-207/100;\\n9:55-10:30/语文/25老师13/2-205/100',\n",
" '星期1': '9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/25老师2/1-210/100;\\n9:55-10:30/语文/25老师3/5-304/100;\\n9:55-10:30/语文/25老师4/1-202/100;\\n9:55-10:30/语文/25老师5/2-202/100;\\n9:55-10:30/语文/25老师6/5-307/100;\\n9:55-10:30/语文/25老师7/1-203/100;\\n9:55-10:30/语文/25老师8/1-206/100;\\n9:55-10:30/语文/25老师9/1-205/100;\\n9:55-10:30/语文/25老师10/1-309/100;\\n9:55-10:30/语文/25老师11/2-203/100;\\n9:55-10:30/语文/25老师12/1-207/100;\\n9:55-10:30/语文/25老师13/2-205/100',\n",
" '星期2': '9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/25老师2/1-210/100;\\n9:55-10:30/语文/25老师3/5-304/100;\\n9:55-10:30/语文/25老师4/1-202/100;\\n9:55-10:30/语文/25老师5/2-202/100;\\n9:55-10:30/语文/25老师6/5-307/100;\\n9:55-10:30/语文/25老师7/1-203/100;\\n9:55-10:30/语文/25老师8/1-206/100;\\n9:55-10:30/语文/25老师9/1-205/100;\\n9:55-10:30/语文/25老师10/1-309/100;\\n9:55-10:30/语文/25老师11/2-203/100;\\n9:55-10:30/语文/25老师12/1-207/100;\\n9:55-10:30/语文/25老师13/2-205/100',\n",
" '星期3': '9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/25老师2/1-210/100;\\n9:55-10:30/语文/25老师3/5-304/100;\\n9:55-10:30/语文/25老师4/1-202/100;\\n9:55-10:30/语文/25老师5/2-202/100;\\n9:55-10:30/语文/25老师6/5-307/100;\\n9:55-10:30/语文/25老师7/1-203/100;\\n9:55-10:30/语文/25老师8/1-206/100;\\n9:55-10:30/语文/25老师9/1-205/100;\\n9:55-10:30/语文/25老师10/1-309/100;\\n9:55-10:30/语文/25老师11/2-203/100;\\n9:55-10:30/语文/25老师12/1-207/100;\\n9:55-10:30/语文/25老师13/2-205/100',\n",
" '星期4': '9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/25老师2/1-210/100;\\n9:55-10:30/语文/25老师3/5-304/100;\\n9:55-10:30/语文/25老师4/1-202/100;\\n9:55-10:30/语文/25老师5/2-202/100;\\n9:55-10:30/语文/25老师6/5-307/100;\\n9:55-10:30/语文/25老师7/1-203/100;\\n9:55-10:30/语文/25老师8/1-206/100;\\n9:55-10:30/语文/25老师9/1-205/100;\\n9:55-10:30/语文/25老师10/1-309/100;\\n9:55-10:30/语文/25老师11/2-203/100;\\n9:55-10:30/语文/25老师12/1-207/100;\\n9:55-10:30/语文/25老师13/2-205/100',\n",
" '星期5': '9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/25老师2/1-210/100;\\n9:55-10:30/语文/25老师3/5-304/100;\\n9:55-10:30/语文/25老师4/1-202/100;\\n9:55-10:30/语文/25老师5/2-202/100;\\n9:55-10:30/语文/25老师6/5-307/100;\\n9:55-10:30/语文/25老师7/1-203/100;\\n9:55-10:30/语文/25老师8/1-206/100;\\n9:55-10:30/语文/25老师9/1-205/100;\\n9:55-10:30/语文/25老师10/1-309/100;\\n9:55-10:30/语文/25老师11/2-203/100;\\n9:55-10:30/语文/25老师12/1-207/100;\\n9:55-10:30/语文/25老师13/2-205/100'},\n",
" {'星期0': '10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语文/25老师2/1-210/100;\\n10:30-11:10/语文/25老师3/5-304/100;\\n10:30-11:10/语文/25老师4/1-202/100;\\n10:30-11:10/语文/25老师5/2-202/100;\\n10:30-11:10/语文/25老师6/5-307/100;\\n10:30-11:10/语文/25老师7/1-203/100;\\n10:30-11:10/语文/25老师8/1-206/100;\\n10:30-11:10/语文/25老师9/1-205/100;\\n10:30-11:10/语文/25老师10/1-309/100;\\n10:30-11:10/语文/25老师11/2-203/100;\\n10:30-11:10/语文/25老师12/1-207/100;\\n10:30-11:10/语文/25老师13/2-205/100',\n",
" '星期1': '10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语文/25老师2/1-210/100;\\n10:30-11:10/语文/25老师3/5-304/100;\\n10:30-11:10/语文/25老师4/1-202/100;\\n10:30-11:10/语文/25老师5/2-202/100;\\n10:30-11:10/语文/25老师6/5-307/100;\\n10:30-11:10/语文/25老师7/1-203/100;\\n10:30-11:10/语文/25老师8/1-206/100;\\n10:30-11:10/语文/25老师9/1-205/100;\\n10:30-11:10/语文/25老师10/1-309/100;\\n10:30-11:10/语文/25老师11/2-203/100;\\n10:30-11:10/语文/25老师12/1-207/100;\\n10:30-11:10/语文/25老师13/2-205/100',\n",
" '星期2': '10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语文/25老师2/1-210/100;\\n10:30-11:10/语文/25老师3/5-304/100;\\n10:30-11:10/语文/25老师4/1-202/100;\\n10:30-11:10/语文/25老师5/2-202/100;\\n10:30-11:10/语文/25老师6/5-307/100;\\n10:30-11:10/语文/25老师7/1-203/100;\\n10:30-11:10/语文/25老师8/1-206/100;\\n10:30-11:10/语文/25老师9/1-205/100;\\n10:30-11:10/语文/25老师10/1-309/100;\\n10:30-11:10/语文/25老师11/2-203/100;\\n10:30-11:10/语文/25老师12/1-207/100;\\n10:30-11:10/语文/25老师13/2-205/100',\n",
" '星期3': '10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语文/25老师2/1-210/100;\\n10:30-11:10/语文/25老师3/5-304/100;\\n10:30-11:10/语文/25老师4/1-202/100;\\n10:30-11:10/语文/25老师5/2-202/100;\\n10:30-11:10/语文/25老师6/5-307/100;\\n10:30-11:10/语文/25老师7/1-203/100;\\n10:30-11:10/语文/25老师8/1-206/100;\\n10:30-11:10/语文/25老师9/1-205/100;\\n10:30-11:10/语文/25老师10/1-309/100;\\n10:30-11:10/语文/25老师11/2-203/100;\\n10:30-11:10/语文/25老师12/1-207/100;\\n10:30-11:10/语文/25老师13/2-205/100',\n",
" '星期4': '10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语文/25老师2/1-210/100;\\n10:30-11:10/语文/25老师3/5-304/100;\\n10:30-11:10/语文/25老师4/1-202/100;\\n10:30-11:10/语文/25老师5/2-202/100;\\n10:30-11:10/语文/25老师6/5-307/100;\\n10:30-11:10/语文/25老师7/1-203/100;\\n10:30-11:10/语文/25老师8/1-206/100;\\n10:30-11:10/语文/25老师9/1-205/100;\\n10:30-11:10/语文/25老师10/1-309/100;\\n10:30-11:10/语文/25老师11/2-203/100;\\n10:30-11:10/语文/25老师12/1-207/100;\\n10:30-11:10/语文/25老师13/2-205/100',\n",
" '星期5': '10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语文/25老师2/1-210/100;\\n10:30-11:10/语文/25老师3/5-304/100;\\n10:30-11:10/语文/25老师4/1-202/100;\\n10:30-11:10/语文/25老师5/2-202/100;\\n10:30-11:10/语文/25老师6/5-307/100;\\n10:30-11:10/语文/25老师7/1-203/100;\\n10:30-11:10/语文/25老师8/1-206/100;\\n10:30-11:10/语文/25老师9/1-205/100;\\n10:30-11:10/语文/25老师10/1-309/100;\\n10:30-11:10/语文/25老师11/2-203/100;\\n10:30-11:10/语文/25老师12/1-207/100;\\n10:30-11:10/语文/25老师13/2-205/100'},\n",
" {'星期0': '14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语文/25老师2/1-210/100;\\n14:55-15:35/语文/25老师3/5-304/100;\\n14:55-15:35/语文/25老师4/1-202/100;\\n14:55-15:35/语文/25老师5/2-202/100;\\n14:55-15:35/语文/25老师6/5-307/100;\\n14:55-15:35/语文/25老师7/1-203/100;\\n14:55-15:35/语文/25老师8/1-206/100;\\n14:55-15:35/语文/25老师9/1-205/100;\\n14:55-15:35/语文/25老师10/1-309/100;\\n14:55-15:35/语文/25老师11/2-203/100;\\n14:55-15:35/语文/25老师12/1-207/100;\\n14:55-15:35/语文/25老师13/2-205/100',\n",
" '星期1': '14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语文/25老师2/1-210/100;\\n14:55-15:35/语文/25老师3/5-304/100;\\n14:55-15:35/语文/25老师4/1-202/100;\\n14:55-15:35/语文/25老师5/2-202/100;\\n14:55-15:35/语文/25老师6/5-307/100;\\n14:55-15:35/语文/25老师7/1-203/100;\\n14:55-15:35/语文/25老师8/1-206/100;\\n14:55-15:35/语文/25老师9/1-205/100;\\n14:55-15:35/语文/25老师10/1-309/100;\\n14:55-15:35/语文/25老师11/2-203/100;\\n14:55-15:35/语文/25老师12/1-207/100;\\n14:55-15:35/语文/25老师13/2-205/100',\n",
" '星期2': '14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语文/25老师2/1-210/100;\\n14:55-15:35/语文/25老师3/5-304/100;\\n14:55-15:35/语文/25老师4/1-202/100;\\n14:55-15:35/语文/25老师5/2-202/100;\\n14:55-15:35/语文/25老师6/5-307/100;\\n14:55-15:35/语文/25老师7/1-203/100;\\n14:55-15:35/语文/25老师8/1-206/100;\\n14:55-15:35/语文/25老师9/1-205/100;\\n14:55-15:35/语文/25老师10/1-309/100;\\n14:55-15:35/语文/25老师11/2-203/100;\\n14:55-15:35/语文/25老师12/1-207/100;\\n14:55-15:35/语文/25老师13/2-205/100',\n",
" '星期3': '14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语文/25老师2/1-210/100;\\n14:55-15:35/语文/25老师3/5-304/100;\\n14:55-15:35/语文/25老师4/1-202/100;\\n14:55-15:35/语文/25老师5/2-202/100;\\n14:55-15:35/语文/25老师6/5-307/100;\\n14:55-15:35/语文/25老师7/1-203/100;\\n14:55-15:35/语文/25老师8/1-206/100;\\n14:55-15:35/语文/25老师9/1-205/100;\\n14:55-15:35/语文/25老师10/1-309/100;\\n14:55-15:35/语文/25老师11/2-203/100;\\n14:55-15:35/语文/25老师12/1-207/100;\\n14:55-15:35/语文/25老师13/2-205/100',\n",
" '星期4': '14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语文/25老师2/1-210/100;\\n14:55-15:35/语文/25老师3/5-304/100;\\n14:55-15:35/语文/25老师4/1-202/100;\\n14:55-15:35/语文/25老师5/2-202/100;\\n14:55-15:35/语文/25老师6/5-307/100;\\n14:55-15:35/语文/25老师7/1-203/100;\\n14:55-15:35/语文/25老师8/1-206/100;\\n14:55-15:35/语文/25老师9/1-205/100;\\n14:55-15:35/语文/25老师10/1-309/100;\\n14:55-15:35/语文/25老师11/2-203/100;\\n14:55-15:35/语文/25老师12/1-207/100;\\n14:55-15:35/语文/25老师13/2-205/100',\n",
" '星期5': '14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语文/25老师2/1-210/100;\\n14:55-15:35/语文/25老师3/5-304/100;\\n14:55-15:35/语文/25老师4/1-202/100;\\n14:55-15:35/语文/25老师5/2-202/100;\\n14:55-15:35/语文/25老师6/5-307/100;\\n14:55-15:35/语文/25老师7/1-203/100;\\n14:55-15:35/语文/25老师8/1-206/100;\\n14:55-15:35/语文/25老师9/1-205/100;\\n14:55-15:35/语文/25老师10/1-309/100;\\n14:55-15:35/语文/25老师11/2-203/100;\\n14:55-15:35/语文/25老师12/1-207/100;\\n14:55-15:35/语文/25老师13/2-205/100'},\n",
" {'星期0': '15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语文/25老师2/1-210/100;\\n15:45-16:25/语文/25老师3/5-304/100;\\n15:45-16:25/语文/25老师4/1-202/100;\\n15:45-16:25/语文/25老师5/2-202/100;\\n15:45-16:25/语文/25老师6/5-307/100;\\n15:45-16:25/语文/25老师7/1-203/100;\\n15:45-16:25/语文/25老师8/1-206/100;\\n15:45-16:25/语文/25老师9/1-205/100;\\n15:45-16:25/语文/25老师10/1-309/100;\\n15:45-16:25/语文/25老师11/2-203/100;\\n15:45-16:25/语文/25老师12/1-207/100;\\n15:45-16:25/语文/25老师13/2-205/100',\n",
" '星期1': '15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语文/25老师2/1-210/100;\\n15:45-16:25/语文/25老师3/5-304/100;\\n15:45-16:25/语文/25老师4/1-202/100;\\n15:45-16:25/语文/25老师5/2-202/100;\\n15:45-16:25/语文/25老师6/5-307/100;\\n15:45-16:25/语文/25老师7/1-203/100;\\n15:45-16:25/语文/25老师8/1-206/100;\\n15:45-16:25/语文/25老师9/1-205/100;\\n15:45-16:25/语文/25老师10/1-309/100;\\n15:45-16:25/语文/25老师11/2-203/100;\\n15:45-16:25/语文/25老师12/1-207/100;\\n15:45-16:25/语文/25老师13/2-205/100',\n",
" '星期2': '15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语文/25老师2/1-210/100;\\n15:45-16:25/语文/25老师3/5-304/100;\\n15:45-16:25/语文/25老师4/1-202/100;\\n15:45-16:25/语文/25老师5/2-202/100;\\n15:45-16:25/语文/25老师6/5-307/100;\\n15:45-16:25/语文/25老师7/1-203/100;\\n15:45-16:25/语文/25老师8/1-206/100;\\n15:45-16:25/语文/25老师9/1-205/100;\\n15:45-16:25/语文/25老师10/1-309/100;\\n15:45-16:25/语文/25老师11/2-203/100;\\n15:45-16:25/语文/25老师12/1-207/100;\\n15:45-16:25/语文/25老师13/2-205/100',\n",
" '星期3': '15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语文/25老师2/1-210/100;\\n15:45-16:25/语文/25老师3/5-304/100;\\n15:45-16:25/语文/25老师4/1-202/100;\\n15:45-16:25/语文/25老师5/2-202/100;\\n15:45-16:25/语文/25老师6/5-307/100;\\n15:45-16:25/语文/25老师7/1-203/100;\\n15:45-16:25/语文/25老师8/1-206/100;\\n15:45-16:25/语文/25老师9/1-205/100;\\n15:45-16:25/语文/25老师10/1-309/100;\\n15:45-16:25/语文/25老师11/2-203/100;\\n15:45-16:25/语文/25老师12/1-207/100;\\n15:45-16:25/语文/25老师13/2-205/100',\n",
" '星期4': '15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语文/25老师2/1-210/100;\\n15:45-16:25/语文/25老师3/5-304/100;\\n15:45-16:25/语文/25老师4/1-202/100;\\n15:45-16:25/语文/25老师5/2-202/100;\\n15:45-16:25/语文/25老师6/5-307/100;\\n15:45-16:25/语文/25老师7/1-203/100;\\n15:45-16:25/语文/25老师8/1-206/100;\\n15:45-16:25/语文/25老师9/1-205/100;\\n15:45-16:25/语文/25老师10/1-309/100;\\n15:45-16:25/语文/25老师11/2-203/100;\\n15:45-16:25/语文/25老师12/1-207/100;\\n15:45-16:25/语文/25老师13/2-205/100',\n",
" '星期5': '15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语文/25老师2/1-210/100;\\n15:45-16:25/语文/25老师3/5-304/100;\\n15:45-16:25/语文/25老师4/1-202/100;\\n15:45-16:25/语文/25老师5/2-202/100;\\n15:45-16:25/语文/25老师6/5-307/100;\\n15:45-16:25/语文/25老师7/1-203/100;\\n15:45-16:25/语文/25老师8/1-206/100;\\n15:45-16:25/语文/25老师9/1-205/100;\\n15:45-16:25/语文/25老师10/1-309/100;\\n15:45-16:25/语文/25老师11/2-203/100;\\n15:45-16:25/语文/25老师12/1-207/100;\\n15:45-16:25/语文/25老师13/2-205/100'},\n",
" {'星期0': '16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语文/25老师2/1-210/100;\\n16:35-17:15/语文/25老师3/5-304/100;\\n16:35-17:15/语文/25老师4/1-202/100;\\n16:35-17:15/语文/25老师5/2-202/100;\\n16:35-17:15/语文/25老师6/5-307/100;\\n16:35-17:15/语文/25老师7/1-203/100;\\n16:35-17:15/语文/25老师8/1-206/100;\\n16:35-17:15/语文/25老师9/1-205/100;\\n16:35-17:15/语文/25老师10/1-309/100;\\n16:35-17:15/语文/25老师11/2-203/100;\\n16:35-17:15/语文/25老师12/1-207/100;\\n16:35-17:15/语文/25老师13/2-205/100',\n",
" '星期1': '16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语文/25老师2/1-210/100;\\n16:35-17:15/语文/25老师3/5-304/100;\\n16:35-17:15/语文/25老师4/1-202/100;\\n16:35-17:15/语文/25老师5/2-202/100;\\n16:35-17:15/语文/25老师6/5-307/100;\\n16:35-17:15/语文/25老师7/1-203/100;\\n16:35-17:15/语文/25老师8/1-206/100;\\n16:35-17:15/语文/25老师9/1-205/100;\\n16:35-17:15/语文/25老师10/1-309/100;\\n16:35-17:15/语文/25老师11/2-203/100;\\n16:35-17:15/语文/25老师12/1-207/100;\\n16:35-17:15/语文/25老师13/2-205/100',\n",
" '星期2': '16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语文/25老师2/1-210/100;\\n16:35-17:15/语文/25老师3/5-304/100;\\n16:35-17:15/语文/25老师4/1-202/100;\\n16:35-17:15/语文/25老师5/2-202/100;\\n16:35-17:15/语文/25老师6/5-307/100;\\n16:35-17:15/语文/25老师7/1-203/100;\\n16:35-17:15/语文/25老师8/1-206/100;\\n16:35-17:15/语文/25老师9/1-205/100;\\n16:35-17:15/语文/25老师10/1-309/100;\\n16:35-17:15/语文/25老师11/2-203/100;\\n16:35-17:15/语文/25老师12/1-207/100;\\n16:35-17:15/语文/25老师13/2-205/100',\n",
" '星期3': '16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语文/25老师2/1-210/100;\\n16:35-17:15/语文/25老师3/5-304/100;\\n16:35-17:15/语文/25老师4/1-202/100;\\n16:35-17:15/语文/25老师5/2-202/100;\\n16:35-17:15/语文/25老师6/5-307/100;\\n16:35-17:15/语文/25老师7/1-203/100;\\n16:35-17:15/语文/25老师8/1-206/100;\\n16:35-17:15/语文/25老师9/1-205/100;\\n16:35-17:15/语文/25老师10/1-309/100;\\n16:35-17:15/语文/25老师11/2-203/100;\\n16:35-17:15/语文/25老师12/1-207/100;\\n16:35-17:15/语文/25老师13/2-205/100',\n",
" '星期4': '16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语文/25老师2/1-210/100;\\n16:35-17:15/语文/25老师3/5-304/100;\\n16:35-17:15/语文/25老师4/1-202/100;\\n16:35-17:15/语文/25老师5/2-202/100;\\n16:35-17:15/语文/25老师6/5-307/100;\\n16:35-17:15/语文/25老师7/1-203/100;\\n16:35-17:15/语文/25老师8/1-206/100;\\n16:35-17:15/语文/25老师9/1-205/100;\\n16:35-17:15/语文/25老师10/1-309/100;\\n16:35-17:15/语文/25老师11/2-203/100;\\n16:35-17:15/语文/25老师12/1-207/100;\\n16:35-17:15/语文/25老师13/2-205/100',\n",
" '星期5': '16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语文/25老师2/1-210/100;\\n16:35-17:15/语文/25老师3/5-304/100;\\n16:35-17:15/语文/25老师4/1-202/100;\\n16:35-17:15/语文/25老师5/2-202/100;\\n16:35-17:15/语文/25老师6/5-307/100;\\n16:35-17:15/语文/25老师7/1-203/100;\\n16:35-17:15/语文/25老师8/1-206/100;\\n16:35-17:15/语文/25老师9/1-205/100;\\n16:35-17:15/语文/25老师10/1-309/100;\\n16:35-17:15/语文/25老师11/2-203/100;\\n16:35-17:15/语文/25老师12/1-207/100;\\n16:35-17:15/语文/25老师13/2-205/100'},\n",
" {'星期0': '18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语文/25老师2/1-210/100;\\n18:50-19:30/语文/25老师3/5-304/100;\\n18:50-19:30/语文/25老师4/1-202/100;\\n18:50-19:30/语文/25老师5/2-202/100;\\n18:50-19:30/语文/25老师6/5-307/100;\\n18:50-19:30/语文/25老师7/1-203/100;\\n18:50-19:30/语文/25老师8/1-206/100;\\n18:50-19:30/语文/25老师9/1-205/100;\\n18:50-19:30/语文/25老师10/1-309/100;\\n18:50-19:30/语文/25老师11/2-203/100;\\n18:50-19:30/语文/25老师12/1-207/100;\\n18:50-19:30/语文/25老师13/2-205/100',\n",
" '星期1': '18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语文/25老师2/1-210/100;\\n18:50-19:30/语文/25老师3/5-304/100;\\n18:50-19:30/语文/25老师4/1-202/100;\\n18:50-19:30/语文/25老师5/2-202/100;\\n18:50-19:30/语文/25老师6/5-307/100;\\n18:50-19:30/语文/25老师7/1-203/100;\\n18:50-19:30/语文/25老师8/1-206/100;\\n18:50-19:30/语文/25老师9/1-205/100;\\n18:50-19:30/语文/25老师10/1-309/100;\\n18:50-19:30/语文/25老师11/2-203/100;\\n18:50-19:30/语文/25老师12/1-207/100;\\n18:50-19:30/语文/25老师13/2-205/100',\n",
" '星期2': '18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语文/25老师2/1-210/100;\\n18:50-19:30/语文/25老师3/5-304/100;\\n18:50-19:30/语文/25老师4/1-202/100;\\n18:50-19:30/语文/25老师5/2-202/100;\\n18:50-19:30/语文/25老师6/5-307/100;\\n18:50-19:30/语文/25老师7/1-203/100;\\n18:50-19:30/语文/25老师8/1-206/100;\\n18:50-19:30/语文/25老师9/1-205/100;\\n18:50-19:30/语文/25老师10/1-309/100;\\n18:50-19:30/语文/25老师11/2-203/100;\\n18:50-19:30/语文/25老师12/1-207/100;\\n18:50-19:30/语文/25老师13/2-205/100',\n",
" '星期3': '18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语文/25老师2/1-210/100;\\n18:50-19:30/语文/25老师3/5-304/100;\\n18:50-19:30/语文/25老师4/1-202/100;\\n18:50-19:30/语文/25老师5/2-202/100;\\n18:50-19:30/语文/25老师6/5-307/100;\\n18:50-19:30/语文/25老师7/1-203/100;\\n18:50-19:30/语文/25老师8/1-206/100;\\n18:50-19:30/语文/25老师9/1-205/100;\\n18:50-19:30/语文/25老师10/1-309/100;\\n18:50-19:30/语文/25老师11/2-203/100;\\n18:50-19:30/语文/25老师12/1-207/100;\\n18:50-19:30/语文/25老师13/2-205/100',\n",
" '星期4': '18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语文/25老师2/1-210/100;\\n18:50-19:30/语文/25老师3/5-304/100;\\n18:50-19:30/语文/25老师4/1-202/100;\\n18:50-19:30/语文/25老师5/2-202/100;\\n18:50-19:30/语文/25老师6/5-307/100;\\n18:50-19:30/语文/25老师7/1-203/100;\\n18:50-19:30/语文/25老师8/1-206/100;\\n18:50-19:30/语文/25老师9/1-205/100;\\n18:50-19:30/语文/25老师10/1-309/100;\\n18:50-19:30/语文/25老师11/2-203/100;\\n18:50-19:30/语文/25老师12/1-207/100;\\n18:50-19:30/语文/25老师13/2-205/100',\n",
" '星期5': '18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语文/25老师2/1-210/100;\\n18:50-19:30/语文/25老师3/5-304/100;\\n18:50-19:30/语文/25老师4/1-202/100;\\n18:50-19:30/语文/25老师5/2-202/100;\\n18:50-19:30/语文/25老师6/5-307/100;\\n18:50-19:30/语文/25老师7/1-203/100;\\n18:50-19:30/语文/25老师8/1-206/100;\\n18:50-19:30/语文/25老师9/1-205/100;\\n18:50-19:30/语文/25老师10/1-309/100;\\n18:50-19:30/语文/25老师11/2-203/100;\\n18:50-19:30/语文/25老师12/1-207/100;\\n18:50-19:30/语文/25老师13/2-205/100'},\n",
" {'星期0': '19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语文/25老师2/1-210/100;\\n19:40-20:20/语文/25老师3/5-304/100;\\n19:40-20:20/语文/25老师4/1-202/100;\\n19:40-20:20/语文/25老师5/2-202/100;\\n19:40-20:20/语文/25老师6/5-307/100;\\n19:40-20:20/语文/25老师7/1-203/100;\\n19:40-20:20/语文/25老师8/1-206/100;\\n19:40-20:20/语文/25老师9/1-205/100;\\n19:40-20:20/语文/25老师10/1-309/100;\\n19:40-20:20/语文/25老师11/2-203/100;\\n19:40-20:20/语文/25老师12/1-207/100;\\n19:40-20:20/语文/25老师13/2-205/100',\n",
" '星期1': '19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语文/25老师2/1-210/100;\\n19:40-20:20/语文/25老师3/5-304/100;\\n19:40-20:20/语文/25老师4/1-202/100;\\n19:40-20:20/语文/25老师5/2-202/100;\\n19:40-20:20/语文/25老师6/5-307/100;\\n19:40-20:20/语文/25老师7/1-203/100;\\n19:40-20:20/语文/25老师8/1-206/100;\\n19:40-20:20/语文/25老师9/1-205/100;\\n19:40-20:20/语文/25老师10/1-309/100;\\n19:40-20:20/语文/25老师11/2-203/100;\\n19:40-20:20/语文/25老师12/1-207/100;\\n19:40-20:20/语文/25老师13/2-205/100',\n",
" '星期2': '19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语文/25老师2/1-210/100;\\n19:40-20:20/语文/25老师3/5-304/100;\\n19:40-20:20/语文/25老师4/1-202/100;\\n19:40-20:20/语文/25老师5/2-202/100;\\n19:40-20:20/语文/25老师6/5-307/100;\\n19:40-20:20/语文/25老师7/1-203/100;\\n19:40-20:20/语文/25老师8/1-206/100;\\n19:40-20:20/语文/25老师9/1-205/100;\\n19:40-20:20/语文/25老师10/1-309/100;\\n19:40-20:20/语文/25老师11/2-203/100;\\n19:40-20:20/语文/25老师12/1-207/100;\\n19:40-20:20/语文/25老师13/2-205/100',\n",
" '星期3': '19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语文/25老师2/1-210/100;\\n19:40-20:20/语文/25老师3/5-304/100;\\n19:40-20:20/语文/25老师4/1-202/100;\\n19:40-20:20/语文/25老师5/2-202/100;\\n19:40-20:20/语文/25老师6/5-307/100;\\n19:40-20:20/语文/25老师7/1-203/100;\\n19:40-20:20/语文/25老师8/1-206/100;\\n19:40-20:20/语文/25老师9/1-205/100;\\n19:40-20:20/语文/25老师10/1-309/100;\\n19:40-20:20/语文/25老师11/2-203/100;\\n19:40-20:20/语文/25老师12/1-207/100;\\n19:40-20:20/语文/25老师13/2-205/100',\n",
" '星期4': '19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语文/25老师2/1-210/100;\\n19:40-20:20/语文/25老师3/5-304/100;\\n19:40-20:20/语文/25老师4/1-202/100;\\n19:40-20:20/语文/25老师5/2-202/100;\\n19:40-20:20/语文/25老师6/5-307/100;\\n19:40-20:20/语文/25老师7/1-203/100;\\n19:40-20:20/语文/25老师8/1-206/100;\\n19:40-20:20/语文/25老师9/1-205/100;\\n19:40-20:20/语文/25老师10/1-309/100;\\n19:40-20:20/语文/25老师11/2-203/100;\\n19:40-20:20/语文/25老师12/1-207/100;\\n19:40-20:20/语文/25老师13/2-205/100',\n",
" '星期5': '19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语文/25老师2/1-210/100;\\n19:40-20:20/语文/25老师3/5-304/100;\\n19:40-20:20/语文/25老师4/1-202/100;\\n19:40-20:20/语文/25老师5/2-202/100;\\n19:40-20:20/语文/25老师6/5-307/100;\\n19:40-20:20/语文/25老师7/1-203/100;\\n19:40-20:20/语文/25老师8/1-206/100;\\n19:40-20:20/语文/25老师9/1-205/100;\\n19:40-20:20/语文/25老师10/1-309/100;\\n19:40-20:20/语文/25老师11/2-203/100;\\n19:40-20:20/语文/25老师12/1-207/100;\\n19:40-20:20/语文/25老师13/2-205/100'},\n",
" {'星期0': '20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语文/25老师2/1-210/100;\\n20:30-21:00/语文/25老师3/5-304/100;\\n20:30-21:00/语文/25老师4/1-202/100;\\n20:30-21:00/语文/25老师5/2-202/100;\\n20:30-21:00/语文/25老师6/5-307/100;\\n20:30-21:00/语文/25老师7/1-203/100;\\n20:30-21:00/语文/25老师8/1-206/100;\\n20:30-21:00/语文/25老师9/1-205/100;\\n20:30-21:00/语文/25老师10/1-309/100;\\n20:30-21:00/语文/25老师11/2-203/100;\\n20:30-21:00/语文/25老师12/1-207/100;\\n20:30-21:00/语文/25老师13/2-205/100',\n",
" '星期1': '20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语文/25老师2/1-210/100;\\n20:30-21:00/语文/25老师3/5-304/100;\\n20:30-21:00/语文/25老师4/1-202/100;\\n20:30-21:00/语文/25老师5/2-202/100;\\n20:30-21:00/语文/25老师6/5-307/100;\\n20:30-21:00/语文/25老师7/1-203/100;\\n20:30-21:00/语文/25老师8/1-206/100;\\n20:30-21:00/语文/25老师9/1-205/100;\\n20:30-21:00/语文/25老师10/1-309/100;\\n20:30-21:00/语文/25老师11/2-203/100;\\n20:30-21:00/语文/25老师12/1-207/100;\\n20:30-21:00/语文/25老师13/2-205/100',\n",
" '星期2': '20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语文/25老师2/1-210/100;\\n20:30-21:00/语文/25老师3/5-304/100;\\n20:30-21:00/语文/25老师4/1-202/100;\\n20:30-21:00/语文/25老师5/2-202/100;\\n20:30-21:00/语文/25老师6/5-307/100;\\n20:30-21:00/语文/25老师7/1-203/100;\\n20:30-21:00/语文/25老师8/1-206/100;\\n20:30-21:00/语文/25老师9/1-205/100;\\n20:30-21:00/语文/25老师10/1-309/100;\\n20:30-21:00/语文/25老师11/2-203/100;\\n20:30-21:00/语文/25老师12/1-207/100;\\n20:30-21:00/语文/25老师13/2-205/100',\n",
" '星期3': '20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语文/25老师2/1-210/100;\\n20:30-21:00/语文/25老师3/5-304/100;\\n20:30-21:00/语文/25老师4/1-202/100;\\n20:30-21:00/语文/25老师5/2-202/100;\\n20:30-21:00/语文/25老师6/5-307/100;\\n20:30-21:00/语文/25老师7/1-203/100;\\n20:30-21:00/语文/25老师8/1-206/100;\\n20:30-21:00/语文/25老师9/1-205/100;\\n20:30-21:00/语文/25老师10/1-309/100;\\n20:30-21:00/语文/25老师11/2-203/100;\\n20:30-21:00/语文/25老师12/1-207/100;\\n20:30-21:00/语文/25老师13/2-205/100',\n",
" '星期4': '20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语文/25老师2/1-210/100;\\n20:30-21:00/语文/25老师3/5-304/100;\\n20:30-21:00/语文/25老师4/1-202/100;\\n20:30-21:00/语文/25老师5/2-202/100;\\n20:30-21:00/语文/25老师6/5-307/100;\\n20:30-21:00/语文/25老师7/1-203/100;\\n20:30-21:00/语文/25老师8/1-206/100;\\n20:30-21:00/语文/25老师9/1-205/100;\\n20:30-21:00/语文/25老师10/1-309/100;\\n20:30-21:00/语文/25老师11/2-203/100;\\n20:30-21:00/语文/25老师12/1-207/100;\\n20:30-21:00/语文/25老师13/2-205/100',\n",
" '星期5': '20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语文/25老师2/1-210/100;\\n20:30-21:00/语文/25老师3/5-304/100;\\n20:30-21:00/语文/25老师4/1-202/100;\\n20:30-21:00/语文/25老师5/2-202/100;\\n20:30-21:00/语文/25老师6/5-307/100;\\n20:30-21:00/语文/25老师7/1-203/100;\\n20:30-21:00/语文/25老师8/1-206/100;\\n20:30-21:00/语文/25老师9/1-205/100;\\n20:30-21:00/语文/25老师10/1-309/100;\\n20:30-21:00/语文/25老师11/2-203/100;\\n20:30-21:00/语文/25老师12/1-207/100;\\n20:30-21:00/语文/25老师13/2-205/100'}]"
]
},
"execution_count": 51,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"table"
]
},
{
"cell_type": "code",
"execution_count": 52,
"id": "f2cd1ec7",
"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>星期0</th>\n",
" <th>星期1</th>\n",
" <th>星期2</th>\n",
" <th>星期3</th>\n",
" <th>星期4</th>\n",
" <th>星期5</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25...</td>\n",
" <td>8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25...</td>\n",
" <td>8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25...</td>\n",
" <td>8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25...</td>\n",
" <td>8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25...</td>\n",
" <td>8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25...</td>\n",
" <td>9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25...</td>\n",
" <td>9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25...</td>\n",
" <td>9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25...</td>\n",
" <td>9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25...</td>\n",
" <td>9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/...</td>\n",
" <td>9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/...</td>\n",
" <td>9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/...</td>\n",
" <td>9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/...</td>\n",
" <td>9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/...</td>\n",
" <td>9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语...</td>\n",
" <td>10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语...</td>\n",
" <td>10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语...</td>\n",
" <td>10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语...</td>\n",
" <td>10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语...</td>\n",
" <td>10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语...</td>\n",
" <td>14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语...</td>\n",
" <td>14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语...</td>\n",
" <td>14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语...</td>\n",
" <td>14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语...</td>\n",
" <td>14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语...</td>\n",
" <td>15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语...</td>\n",
" <td>15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语...</td>\n",
" <td>15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语...</td>\n",
" <td>15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语...</td>\n",
" <td>15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语...</td>\n",
" <td>16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语...</td>\n",
" <td>16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语...</td>\n",
" <td>16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语...</td>\n",
" <td>16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语...</td>\n",
" <td>16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语...</td>\n",
" <td>18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语...</td>\n",
" <td>18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语...</td>\n",
" <td>18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语...</td>\n",
" <td>18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语...</td>\n",
" <td>18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语...</td>\n",
" <td>19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语...</td>\n",
" <td>19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语...</td>\n",
" <td>19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语...</td>\n",
" <td>19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语...</td>\n",
" <td>19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语...</td>\n",
" <td>20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语...</td>\n",
" <td>20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语...</td>\n",
" <td>20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语...</td>\n",
" <td>20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语...</td>\n",
" <td>20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 星期0 \\\n",
"0 8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25... \n",
"1 9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25... \n",
"2 9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/... \n",
"3 10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语... \n",
"4 14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语... \n",
"5 15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语... \n",
"6 16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语... \n",
"7 18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语... \n",
"8 19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语... \n",
"9 20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语... \n",
"\n",
" 星期1 \\\n",
"0 8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25... \n",
"1 9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25... \n",
"2 9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/... \n",
"3 10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语... \n",
"4 14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语... \n",
"5 15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语... \n",
"6 16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语... \n",
"7 18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语... \n",
"8 19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语... \n",
"9 20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语... \n",
"\n",
" 星期2 \\\n",
"0 8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25... \n",
"1 9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25... \n",
"2 9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/... \n",
"3 10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语... \n",
"4 14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语... \n",
"5 15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语... \n",
"6 16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语... \n",
"7 18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语... \n",
"8 19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语... \n",
"9 20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语... \n",
"\n",
" 星期3 \\\n",
"0 8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25... \n",
"1 9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25... \n",
"2 9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/... \n",
"3 10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语... \n",
"4 14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语... \n",
"5 15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语... \n",
"6 16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语... \n",
"7 18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语... \n",
"8 19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语... \n",
"9 20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语... \n",
"\n",
" 星期4 \\\n",
"0 8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25... \n",
"1 9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25... \n",
"2 9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/... \n",
"3 10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语... \n",
"4 14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语... \n",
"5 15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语... \n",
"6 16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语... \n",
"7 18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语... \n",
"8 19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语... \n",
"9 20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语... \n",
"\n",
" 星期5 \n",
"0 8:25-9:05/语文/25老师1/5-303/100;\\n8:25-9:05/语文/25... \n",
"1 9:15-9:55/语文/25老师1/5-303/100;\\n9:15-9:55/语文/25... \n",
"2 9:55-10:30/语文/25老师1/5-303/100;\\n9:55-10:30/语文/... \n",
"3 10:30-11:10/语文/25老师1/5-303/100;\\n10:30-11:10/语... \n",
"4 14:55-15:35/语文/25老师1/5-303/100;\\n14:55-15:35/语... \n",
"5 15:45-16:25/语文/25老师1/5-303/100;\\n15:45-16:25/语... \n",
"6 16:35-17:15/语文/25老师1/5-303/100;\\n16:35-17:15/语... \n",
"7 18:50-19:30/语文/25老师1/5-303/100;\\n18:50-19:30/语... \n",
"8 19:40-20:20/语文/25老师1/5-303/100;\\n19:40-20:20/语... \n",
"9 20:30-21:00/语文/25老师1/5-303/100;\\n20:30-21:00/语... "
]
},
"execution_count": 52,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 53,
"id": "a9676764",
"metadata": {},
"outputs": [],
"source": [
"df.to_excel(f'{grade}届课表.xlsx',index=False)"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "04b1d0b8",
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "base",
"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