{"id":294,"date":"2020-01-20T14:38:00","date_gmt":"2020-01-20T06:38:00","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=294"},"modified":"2023-01-17T17:31:47","modified_gmt":"2023-01-17T09:31:47","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas%e8%ae%80%e5%8f%96107%e5%ad%b8%e5%b9%b4%e5%ba%a6%e5%a4%a7%e5%b0%88%e6%a0%a1%e9%99%a2%e5%85%ac%e9%96%8b%e8%b3%87%e8%a8%8a%ef%bc%8c%e4%be%9d%e9%9c%80","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/294\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18-Pandas\u8b80\u53d6107\u5b78\u5e74\u5ea6\u5927\u5c08\u6821\u9662\u516c\u958b\u8cc7\u8a0a\uff0c\u4f9d\u9700\u6c42\u7d71\u8a08\u5404\u9805\u8cc7\u6599!!"},"content":{"rendered":"
\n
\n
\n

\u7dda\u4e0a\u8b80\u53d6\u5927\u5c08\u6821\u9662\u79d1\u7cfb\u4eba\u6578<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [1]:<\/div>\n
\n
\n
\n
<\/span>import<\/span> pandas<\/span> as<\/span> pd<\/span>\nurl<\/span>=<\/span>\"http:\/\/stats.moe.gov.tw\/files\/detail\/107\/107_students.csv\"<\/span>\ndf<\/span> =<\/span> pd<\/span>.<\/span>read_csv<\/span>(<\/span>url<\/span>)<\/span>\ndf<\/span>.<\/span>head<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[1]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n
<\/th>\n\u5b78\u6821\u4ee3\u78bc<\/th>\n\u5b78\u6821\u540d\u7a31<\/th>\n\u79d1\u7cfb\u4ee3\u78bc<\/th>\n\u79d1\u7cfb\u540d\u7a31<\/th>\n\u65e5\u9593\u2215\u9032\u4fee\u5225<\/th>\n\u7b49\u7d1a\u5225<\/th>\n\u4e00\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e00\u5e74\u7d1a\u5973\u751f<\/th>\n\u4e8c\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e8c\u5e74\u7d1a\u5973\u751f<\/th>\n…<\/th>\n\u4e94\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e94\u5e74\u7d1a\u5973\u751f<\/th>\n\u516d\u5e74\u7d1a\u7537\u751f<\/th>\n\u516d\u5e74\u7d1a\u5973\u751f<\/th>\n\u4e03\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e03\u5e74\u7d1a\u5973\u751f<\/th>\n\u5ef6\u4fee\u751f\u7537\u751f<\/th>\n\u5ef6\u4fee\u751f\u5973\u751f<\/th>\n\u7e23\u5e02\u540d\u7a31<\/th>\n\u9ad4\u7cfb\u5225<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nD \u535a\u58eb<\/td>\n9<\/td>\n13<\/td>\n6<\/td>\n16<\/td>\n…<\/td>\n6<\/td>\n5<\/td>\n7<\/td>\n5<\/td>\n3<\/td>\n2<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
1<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nM \u78a9\u58eb<\/td>\n6<\/td>\n10<\/td>\n1<\/td>\n13<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
2<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nB \u5b78\u58eb<\/td>\n16<\/td>\n41<\/td>\n14<\/td>\n39<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n5<\/td>\n14<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
3<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01114005<\/td>\n\u6559\u80b2\u884c\u653f\u8207\u653f\u7b56\u7814\u7a76\u6240<\/td>\nD \u65e5<\/td>\nM \u78a9\u58eb<\/td>\n7<\/td>\n12<\/td>\n5<\/td>\n5<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
4<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01114006<\/td>\n\u5b78\u6821\u884c\u653f\u78a9\u58eb\u5728\u8077\u5c08\u73ed<\/td>\nN \u8077<\/td>\nM \u78a9\u58eb<\/td>\n5<\/td>\n17<\/td>\n5<\/td>\n14<\/td>\n…<\/td>\n2<\/td>\n5<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
5 rows \u00d7 24 columns<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
\u9806\u5229\u8b80\u53d6\u8cc7\u6599\u5f8c\uff0c\u5148\u5217\u51fa\u6b04\u4f4d\u540d\u7a31<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [2]:<\/div>\n
\n
\n
\n
<\/span>df<\/span>.<\/span>columns<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[2]:<\/div>\n
\n
Index(['\u5b78\u6821\u4ee3\u78bc', '\u5b78\u6821\u540d\u7a31', '\u79d1\u7cfb\u4ee3\u78bc', '\u79d1\u7cfb\u540d\u7a31', '\u65e5\u9593\u2215\u9032\u4fee\u5225', '\u7b49\u7d1a\u5225', '\u4e00\u5e74\u7d1a\u7537\u751f', '\u4e00\u5e74\u7d1a\u5973\u751f',\n       '\u4e8c\u5e74\u7d1a\u7537\u751f', '\u4e8c\u5e74\u7d1a\u5973\u751f', '\u4e09\u5e74\u7d1a\u7537\u751f', '\u4e09\u5e74\u7d1a\u5973\u751f', '\u56db\u5e74\u7d1a\u7537\u751f', '\u56db\u5e74\u7d1a\u5973\u751f', '\u4e94\u5e74\u7d1a\u7537\u751f', '\u4e94\u5e74\u7d1a\u5973\u751f',\n       '\u516d\u5e74\u7d1a\u7537\u751f', '\u516d\u5e74\u7d1a\u5973\u751f', '\u4e03\u5e74\u7d1a\u7537\u751f', '\u4e03\u5e74\u7d1a\u5973\u751f', '\u5ef6\u4fee\u751f\u7537\u751f', '\u5ef6\u4fee\u751f\u5973\u751f', '\u7e23\u5e02\u540d\u7a31', '\u9ad4\u7cfb\u5225'],\n      dtype='object')<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
\u5982\u4f55\u77e5\u9053\u7e3d\u5171\u6709\u591a\u5c11\u9593\u5b78\u6821\u5462\uff1f<\/a><\/h3>\n
\u57fa\u672c\u4e0a\u5c31\u5f9e\u5b78\u6821\u4ee3\u78bc\u548c\u5b78\u6821\u540d\u7a31\u4f86\u64cd\u4f5c\uff0c\u76f8\u540c\u7684\u53ea\u4fdd\u7559\u4e00\u500b\uff0c\u5c31\u80fd\u8a08\u7b97\u51fa\u6709\u591a\u5c11\u9593\u5b78\u6821\u4e86<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [3]:<\/div>\n
\n
\n
\n
<\/span>df<\/span>[<\/span>'\u5b78\u6821\u4ee3\u78bc'<\/span>]<\/span>.<\/span>drop_duplicates<\/span>()<\/span>.<\/span>count<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[3]:<\/div>\n
\n
153<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [4]:<\/div>\n
\n
\n
\n
<\/span>df<\/span>[<\/span>'\u5b78\u6821\u540d\u7a31'<\/span>]<\/span>.<\/span>drop_duplicates<\/span>()<\/span>.<\/span>count<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[4]:<\/div>\n
\n
153<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
\u5982\u679c\u60f3\u77e5\u9053\u5927\u5b78\u6821\u9662\u7e3d\u5171\u6709\u591a\u5c11\u79d1\u7cfb\u5462\uff1f<\/a><\/h3>\n
\u4ee5\u79d1\u7cfb\u540d\u7a31\u4f86\u8aaa\uff0c\u7b54\u6848\u662f107\u5b78\u5e74\u5ea6\u6642\uff0c\u7e3d\u5171\u67093527\u500b\u79d1\u7cfb<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [5]:<\/div>\n
\n
\n
\n
<\/span>df<\/span>[<\/span>'\u79d1\u7cfb\u540d\u7a31'<\/span>]<\/span>.<\/span>drop_duplicates<\/span>()<\/span>.<\/span>count<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[5]:<\/div>\n
\n
3527<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
\u81f3\u65bc\u5728\u6559\u80b2\u90e8\u7684\u5206\u985e\u4e2d\uff0c\u5168\u570b\u7e3d\u5171\u6709\u591a\u5c11\u500b\u985e\u5225\u79d1\u7cfb\u5462\uff1f<\/a><\/h3>\n
\u7b54\u6848\u662f2730<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [6]:<\/div>\n
\n
\n
\n
<\/span>df<\/span>[<\/span>'\u79d1\u7cfb\u4ee3\u78bc'<\/span>]<\/span>.<\/span>drop_duplicates<\/span>()<\/span>.<\/span>count<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[6]:<\/div>\n
\n
2730<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
\u53ef\u4ee5\u770b\u4e00\u4e0b\u6559\u80b2\u76f8\u95dc\u7684\u79d1\u7cfb\u4ee3\u78bc\u662f01111001\uff0c\u6709\u4e0d\u5c11\u9593\u5b78\u6821\u90fd\u6709\u9019\u500b\u79d1\u7cfb\u4ee3\u78bc<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [7]:<\/div>\n
\n
\n
\n
<\/span>df<\/span>[<\/span>df<\/span>[<\/span>'\u79d1\u7cfb\u4ee3\u78bc'<\/span>]<\/span> ==<\/span> '01111001'<\/span>]<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[7]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/th>\n\u5b78\u6821\u4ee3\u78bc<\/th>\n\u5b78\u6821\u540d\u7a31<\/th>\n\u79d1\u7cfb\u4ee3\u78bc<\/th>\n\u79d1\u7cfb\u540d\u7a31<\/th>\n\u65e5\u9593\u2215\u9032\u4fee\u5225<\/th>\n\u7b49\u7d1a\u5225<\/th>\n\u4e00\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e00\u5e74\u7d1a\u5973\u751f<\/th>\n\u4e8c\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e8c\u5e74\u7d1a\u5973\u751f<\/th>\n…<\/th>\n\u4e94\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e94\u5e74\u7d1a\u5973\u751f<\/th>\n\u516d\u5e74\u7d1a\u7537\u751f<\/th>\n\u516d\u5e74\u7d1a\u5973\u751f<\/th>\n\u4e03\u5e74\u7d1a\u7537\u751f<\/th>\n\u4e03\u5e74\u7d1a\u5973\u751f<\/th>\n\u5ef6\u4fee\u751f\u7537\u751f<\/th>\n\u5ef6\u4fee\u751f\u5973\u751f<\/th>\n\u7e23\u5e02\u540d\u7a31<\/th>\n\u9ad4\u7cfb\u5225<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nD \u535a\u58eb<\/td>\n9<\/td>\n13<\/td>\n6<\/td>\n16<\/td>\n…<\/td>\n6<\/td>\n5<\/td>\n7<\/td>\n5<\/td>\n3<\/td>\n2<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
1<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nM \u78a9\u58eb<\/td>\n6<\/td>\n10<\/td>\n1<\/td>\n13<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
2<\/th>\n1<\/td>\n\u570b\u7acb\u653f\u6cbb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nB \u5b78\u58eb<\/td>\n16<\/td>\n41<\/td>\n14<\/td>\n39<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n5<\/td>\n14<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
620<\/th>\n4<\/td>\n\u570b\u7acb\u81fa\u7063\u5e2b\u7bc4\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nD \u535a\u58eb<\/td>\n5<\/td>\n5<\/td>\n8<\/td>\n9<\/td>\n…<\/td>\n3<\/td>\n9<\/td>\n7<\/td>\n5<\/td>\n4<\/td>\n7<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n3 \u5e2b\u7bc4<\/td>\n<\/tr>\n
621<\/th>\n4<\/td>\n\u570b\u7acb\u81fa\u7063\u5e2b\u7bc4\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nM \u78a9\u58eb<\/td>\n5<\/td>\n16<\/td>\n4<\/td>\n21<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n3 \u5e2b\u7bc4<\/td>\n<\/tr>\n
…<\/th>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n<\/tr>\n
6656<\/th>\n1027<\/td>\n\u6148\u6fdf\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u7814\u7a76\u6240\u4e2d\u7b49\u5b78\u6821\u6559\u5e2b\u5728\u8077\u9032\u4fee\u6559\u5b78\u78a9\u58eb\u5b78\u4f4d\u73ed<\/td>\nN \u8077<\/td>\nM \u78a9\u58eb<\/td>\n0<\/td>\n0<\/td>\n1<\/td>\n14<\/td>\n…<\/td>\n1<\/td>\n2<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n15 \u82b1\u84ee\u7e23<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
8756<\/th>\n1067<\/td>\n\u53f0\u7063\u9996\u5e9c\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u7814\u7a76\u6240<\/td>\nD \u65e5<\/td>\nM \u78a9\u58eb<\/td>\n2<\/td>\n14<\/td>\n2<\/td>\n8<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n11 \u81fa\u5357\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
9765<\/th>\n3002<\/td>\n\u81fa\u5317\u5e02\u7acb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nD \u535a\u58eb<\/td>\n3<\/td>\n11<\/td>\n3<\/td>\n8<\/td>\n…<\/td>\n3<\/td>\n11<\/td>\n3<\/td>\n7<\/td>\n11<\/td>\n24<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
9766<\/th>\n3002<\/td>\n\u81fa\u5317\u5e02\u7acb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nM \u78a9\u58eb<\/td>\n0<\/td>\n6<\/td>\n1<\/td>\n12<\/td>\n…<\/td>\n3<\/td>\n0<\/td>\n2<\/td>\n3<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n
9767<\/th>\n3002<\/td>\n\u81fa\u5317\u5e02\u7acb\u5927\u5b78<\/td>\n01111001<\/td>\n\u6559\u80b2\u5b78\u7cfb<\/td>\nD \u65e5<\/td>\nB \u5b78\u58eb<\/td>\n11<\/td>\n51<\/td>\n16<\/td>\n43<\/td>\n…<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n2<\/td>\n14<\/td>\n30 \u81fa\u5317\u5e02<\/td>\n1 \u4e00\u822c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
92 rows \u00d7 24 columns<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
\u63a5\u4e0b\u4f86\u770b\u4e00\u4e0b\u653f\u6cbb\u5927\u5b78\u5b78\u58eb\u73ed\u7684\u7d71\u8a08\u8cc7\u6599<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [8]:<\/div>\n
\n
\n
\n
<\/span>df<\/span>[(<\/span>df<\/span>[<\/span>'\u5b78\u6821\u4ee3\u78bc'<\/span>]<\/span> ==<\/span> 1<\/span>)<\/span> &<\/span> (<\/span>df<\/span>[<\/span>'\u7b49\u7d1a\u5225'<\/span>]<\/span>==<\/span> 'B \u5b78\u58eb'<\/span>)<\/span> ]<\/span>.<\/span>sum<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[8]:<\/div>\n
\n
\u5b78\u6821\u4ee3\u78bc                                                     37\n\u5b78\u6821\u540d\u7a31      \u570b\u7acb\u653f\u6cbb\u5927\u5b78\u570b\u7acb\u653f\u6cbb\u5927\u5b78\u570b\u7acb\u653f\u6cbb\u5927\u5b78\u570b\u7acb\u653f\u6cbb\u5927\u5b78\u570b\u7acb\u653f\u6cbb\u5927\u5b78\u570b\u7acb\u653f\u6cbb\u5927\u5b78\u570b\u7acb\u653f\u6cbb\u5927\u5b78\u570b\u7acb\u653f\u6cbb...\n\u79d1\u7cfb\u4ee3\u78bc      0111100102221020022220310223102202311009023110...\n\u79d1\u7cfb\u540d\u7a31      \u6559\u80b2\u5b78\u7cfb\u6b77\u53f2\u5b78\u7cfb\u6c11\u65cf\u5b78\u7cfb\u54f2\u5b78\u7cfb\u82f1\u570b\u8a9e\u6587\u5b78\u7cfb\u65e5\u672c\u8a9e\u6587\u5b78\u7cfb\u963f\u62c9\u4f2f\u8a9e\u6587\u5b78\u7cfb\u97d3\u570b\u8a9e\u6587\u5b78\u7cfb\u571f\u8033\u5176\u8a9e\u6587\u5b78...\n\u65e5\u9593\u2215\u9032\u4fee\u5225    D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D \u65e5D...\n\u7b49\u7d1a\u5225       B \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB \u5b78\u58ebB ...\n\u4e00\u5e74\u7d1a\u7537\u751f                                                   899\n\u4e00\u5e74\u7d1a\u5973\u751f                                                  1287\n\u4e8c\u5e74\u7d1a\u7537\u751f                                                   890\n\u4e8c\u5e74\u7d1a\u5973\u751f                                                  1332\n\u4e09\u5e74\u7d1a\u7537\u751f                                                   878\n\u4e09\u5e74\u7d1a\u5973\u751f                                                  1325\n\u56db\u5e74\u7d1a\u7537\u751f                                                   990\n\u56db\u5e74\u7d1a\u5973\u751f                                                  1240\n\u4e94\u5e74\u7d1a\u7537\u751f                                                     0\n\u4e94\u5e74\u7d1a\u5973\u751f                                                     0\n\u516d\u5e74\u7d1a\u7537\u751f                                                     0\n\u516d\u5e74\u7d1a\u5973\u751f                                                     0\n\u4e03\u5e74\u7d1a\u7537\u751f                                                     0\n\u4e03\u5e74\u7d1a\u5973\u751f                                                     0\n\u5ef6\u4fee\u751f\u7537\u751f                                                   326\n\u5ef6\u4fee\u751f\u5973\u751f                                                   463\n\u7e23\u5e02\u540d\u7a31      30 \u81fa\u5317\u5e0230 \u81fa\u5317\u5e0230 \u81fa\u5317\u5e0230 \u81fa\u5317\u5e0230 \u81fa\u5317\u5e0230 \u81fa\u5317\u5e0230 \u81fa\u5317\u5e0230 \u81fa...\n\u9ad4\u7cfb\u5225       1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 \u4e00\u822c1 ...\ndtype: object<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
\u5982\u679c\u8981\u77e5\u9053\u653f\u6cbb\u5927\u5b78\u5b78\u58eb\u73ed\u7684\u5b78\u751f\u6578\uff0c\u5c31\u53ef\u4ee5\u5982\u4e0b\u7d71\u8a08\uff1a<\/a><\/h3>\n
\u5b78\u751f\u6578\u70ba9630\u4eba\u3002<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [9]:<\/div>\n
\n
\n
\n
<\/span>undergraduate<\/span> =<\/span> df<\/span>[(<\/span>df<\/span>[<\/span>'\u5b78\u6821\u4ee3\u78bc'<\/span>]<\/span> ==<\/span> 1<\/span>)<\/span> &<\/span> (<\/span>df<\/span>[<\/span>'\u7b49\u7d1a\u5225'<\/span>]<\/span>==<\/span> 'B \u5b78\u58eb'<\/span>)<\/span> ]<\/span>.<\/span>sum<\/span>()<\/span>\nundergraduate<\/span>[<\/span>'\u4e00\u5e74\u7d1a\u7537\u751f'<\/span>:<\/span>'\u5ef6\u4fee\u751f\u5973\u751f'<\/span>]<\/span>.<\/span>sum<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[9]:<\/div>\n
\n
9630<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\u7dda\u4e0a\u8b80\u53d6\u5927\u5c08\u6821\u9662\u79d1\u7cfb\u4eba\u6578 In [1]: import pandas as pd url=”http […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"categories":[4],"tags":[8,9,275,259],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":null,"coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["Pandas<\/a>","Python<\/a>","read_csv<\/a>","\u6b04\u4f4d\u540d\u7a31<\/a>"],"unlinked":["Pandas<\/span>","Python<\/span>","read_csv<\/span>","\u6b04\u4f4d\u540d\u7a31<\/span>"]}},"comment_count":"1","relative_dates":{"created":"Posted 6 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2020 \u5e74 1 \u6708 20 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2020 \u5e74 1 \u6708 20 \u65e5 \u4e0b\u5348 2:38","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 5:31"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/294"}],"collection":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/comments?post=294"}],"version-history":[{"count":1,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/294\/revisions"}],"predecessor-version":[{"id":661,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/294\/revisions\/661"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}