{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Pandas" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## pandas import" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import numpy as np" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## create pandas Series" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 100\n", "dtype: int64" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "a = pd.Series(np.array(100), dtype=int)\n", "a" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## create pandas Series with data type and index" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "a 1\n", "b 2\n", "c 3\n", "d 4\n", "dtype: int64" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "b = pd.Series([1,2,3,4], dtype=int, index=['a', 'b', 'c', 'd'])\n", "b" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## create pandas Series from dictionary" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "a 0.0\n", "b 1.0\n", "c 2.0\n", "dtype: float64" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data = {'a' : 0., 'b' : 1., 'c' : 2.}\n", "s = pd.Series(data)\n", "s" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas data by index" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "2.0" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "s[2]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas data by 'named' index" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "2.0" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "s['c']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## create pandas from list, and set columns name" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAge
0Alex10
1Bob12
2Clarke13
\n", "
" ], "text/plain": [ " Name Age\n", "0 Alex 10\n", "1 Bob 12\n", "2 Clarke 13" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data = [['Alex',10],['Bob',12],['Clarke',13]]\n", "df = pd.DataFrame(data,columns=['Name','Age'])\n", "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas column names" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['Name', 'Age'], dtype='object')" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.columns" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas shape" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(3, 2)" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.shape" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas indexes" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "RangeIndex(start=0, stop=3, step=1)" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.index" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas data by column names" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
AgeName
010Alex
112Bob
213Clarke
\n", "
" ], "text/plain": [ " Age Name\n", "0 10 Alex\n", "1 12 Bob\n", "2 13 Clarke" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[['Age', 'Name']]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas data by row indexes" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAge
1Bob12
2Clarke13
\n", "
" ], "text/plain": [ " Name Age\n", "1 Bob 12\n", "2 Clarke 13" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.loc[1:]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get pandas cell data by row/column" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "12" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.loc[1]['Age']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Read from csv file " ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [], "source": [ "df_demo = pd.read_csv('demo.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### print the data frame" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
MailboxNotes IDTeam LeaderGithub accountSession 1Unnamed: 5Session 2Unnamed: 7Session 3Unnamed: 9Session 4Unnamed: 11Session 5Unnamed: 13Session 6Unnamed: 15Session 7Unnamed: 17Session 8
0pdlzhang@cn.ibm.comPing DZ Zhang/China/IBMCheng ChenYYIncorrectYNYNYNYNaNNNaNYNaNY
1yananzh@cn.ibm.comYa Nan YN Zhuang/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNaNN 项目会议冲突NaNYNaNY
2lizhjdl@cn.ibm.comZhen Jie DL Li/China/IBMCheng ChenYYDoneN shiftDoneN shiftDoneN shiftDoneN shiftNaNN shiftNaNN shiftNaNN shift
3yuanlyy@cn.ibm.comYuan Yuan YB Li/China/IBMCheng ChenYYDoneYIncorrectYDoneN 项目会议冲突IncorrectYNaNYNaNNNaNY
4shuyang@cn.ibm.comYang Shu/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNaNYNaNYNaNN会议冲突
5zhouyldl@cn.ibm.comYi Li AZ Zhou/China/IBMCheng ChenYYDoneYDoneYDoneN 项目会议冲突DoneYNaNYNaNYNaNY
6lizidl@cn.ibm.comZi DL Li/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
7wangyih@cn.ibm.comYi Han HY Wang/China/IBMCheng ChenYYDoneYDoneYDoneYIncorrectYNaNYNaNYNaNY
8guoqq@cn.ibm.comQian Qian QQ Guo/China/IBMYin LuYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
9shangx@cn.ibm.comXia Shang/China/IBMYin LuYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
10xinzhdl@cn.ibm.comXin RZ Zhang/China/IBMYin LuYYDoneYDoneYDoneYIncorrectYNaNYNaNYNaNY
11ymying@cn.ibm.comMiao Ying MY Yang/China/IBMYin LuYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
12jmhjiang@cn.ibm.comMing Hui LJ Jiang/China/IBMYin LuY迟到Done迟到DoneYIncorrectYIncorrectYNaNYNaNYNaNY
13xiaoywdl@cn.ibm.comXiao Yan XY Wang/China/IBMYin LuYYDoneYDoneYDoneYIncorrectYNaNN有其他会议NaNYNaNY
14wpeter@cn.ibm.comPeter Y Wang/China/IBMYin LuYYDoneYNNNN跟客户有会NNNaNN跟客户有会NaNYNaNN
15issczli@cn.ibm.comLi T Zhang/China/IBMHeng CaiYYDoneYNNNNNYNaNYNaNYNaNY
16zoujin@cn.ibm.comJin Zou/China/IBMHeng CaiYYDoneYDoneYDoneN 项目会议冲突IncorrectYNaNYNaNYNaNN会议冲突
17fygao@cn.ibm.comFang Yue FY Gao/China/IBMHeng CaiYYDoneN 项目会议冲突DoneYDoneYDoneYNaNYNaNYNaNY
18dllsyliu@cn.ibm.comSi Yang IL Liu/China/IBMHeng CaiYYDoneYNYIncorrectYNYNaNYNaNYNaNY
19dlwjia@cn.ibm.comJia AW Wang/China/IBMHeng CaiYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
20ssliu@cn.ibm.comSheng Heng Liu/China/IBMHeng CaiY早退DoneYDoneYDoneN见客户IncorrectYNaNN跟客户有会议NaNYNaNN跟客户有会议
21fenghao@cn.ibm.comfenghao@cn.ibm.comHeng CaiYNA(从第六节课来的插班生)DoneNaNNNaNNNaNNNaNNaNYNaNYNaNY
22xhongdl@cn.ibm.comHong XH Xiao/China/IBMWu DanYYDoneYDoneYDoneYIncorrectYNaNYNaNYNaNY
23haojiedl@cn.ibm.comJie EH Hao/China/IBMWu DanYYDoneYDoneNDoneYNYNaNYNaNYNaNY
24mumeilun@cn.ibm.comMei Lun IM Mu/China/IBMWu DanYYDoneYDoneNDoneYDoneYNaNYNaNYNaNY
25jinglil@cn.ibm.comJing Li Liu/China/IBMWu DanYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
26caijm@cn.ibm.comJin Ming JM Cai/China/IBMWu DanYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
27lidannie@cn.ibm.comLi Dan N Nie/China/IBMWu DanYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
28dongmhtu@cn.ibm.comMei Hua TU Dong/China/IBMWu DanYYDoneYDoneYIncorrectYIncorrectYNaNYNaNYNaNY
29zhangwyi@cn.ibm.comWei Yi WY Zhang/China/IBMWu DanYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
30zhanglp@cn.ibm.comLian Ping Zhang/China/IBMHeng Cai（四年经验（以后答疑））NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "
" ], "text/plain": [ " Mailbox Notes ID Team Leader \\\n", "0 pdlzhang@cn.ibm.com Ping DZ Zhang/China/IBM Cheng Chen \n", "1 yananzh@cn.ibm.com Ya Nan YN Zhuang/China/IBM Cheng Chen \n", "2 lizhjdl@cn.ibm.com Zhen Jie DL Li/China/IBM Cheng Chen \n", "3 yuanlyy@cn.ibm.com Yuan Yuan YB Li/China/IBM Cheng Chen \n", "4 shuyang@cn.ibm.com Yang Shu/China/IBM Cheng Chen \n", "5 zhouyldl@cn.ibm.com Yi Li AZ Zhou/China/IBM Cheng Chen \n", "6 lizidl@cn.ibm.com Zi DL Li/China/IBM Cheng Chen \n", "7 wangyih@cn.ibm.com Yi Han HY Wang/China/IBM Cheng Chen \n", "8 guoqq@cn.ibm.com Qian Qian QQ Guo/China/IBM Yin Lu \n", "9 shangx@cn.ibm.com Xia Shang/China/IBM Yin Lu \n", "10 xinzhdl@cn.ibm.com Xin RZ Zhang/China/IBM Yin Lu \n", "11 ymying@cn.ibm.com Miao Ying MY Yang/China/IBM Yin Lu \n", "12 jmhjiang@cn.ibm.com Ming Hui LJ Jiang/China/IBM Yin Lu \n", "13 xiaoywdl@cn.ibm.com Xiao Yan XY Wang/China/IBM Yin Lu \n", "14 wpeter@cn.ibm.com Peter Y Wang/China/IBM Yin Lu \n", "15 issczli@cn.ibm.com Li T Zhang/China/IBM Heng Cai \n", "16 zoujin@cn.ibm.com Jin Zou/China/IBM Heng Cai \n", "17 fygao@cn.ibm.com Fang Yue FY Gao/China/IBM Heng Cai \n", "18 dllsyliu@cn.ibm.com Si Yang IL Liu/China/IBM Heng Cai \n", "19 dlwjia@cn.ibm.com Jia AW Wang/China/IBM Heng Cai \n", "20 ssliu@cn.ibm.com Sheng Heng Liu/China/IBM Heng Cai \n", "21 fenghao@cn.ibm.com fenghao@cn.ibm.com Heng Cai \n", "22 xhongdl@cn.ibm.com Hong XH Xiao/China/IBM Wu Dan \n", "23 haojiedl@cn.ibm.com Jie EH Hao/China/IBM Wu Dan \n", "24 mumeilun@cn.ibm.com Mei Lun IM Mu/China/IBM Wu Dan \n", "25 jinglil@cn.ibm.com Jing Li Liu/China/IBM Wu Dan \n", "26 caijm@cn.ibm.com Jin Ming JM Cai/China/IBM Wu Dan \n", "27 lidannie@cn.ibm.com Li Dan N Nie/China/IBM Wu Dan \n", "28 dongmhtu@cn.ibm.com Mei Hua TU Dong/China/IBM Wu Dan \n", "29 zhangwyi@cn.ibm.com Wei Yi WY Zhang/China/IBM Wu Dan \n", "30 zhanglp@cn.ibm.com Lian Ping Zhang/China/IBM Heng Cai \n", "\n", " Github account Session 1 Unnamed: 5 Session 2 Unnamed: 7 Session 3 \\\n", "0 Y Y Incorrect Y N Y \n", "1 Y Y Done Y Done Y \n", "2 Y Y Done N shift Done N shift \n", "3 Y Y Done Y Incorrect Y \n", "4 Y Y Done Y Done Y \n", "5 Y Y Done Y Done Y \n", "6 Y Y Done Y Done Y \n", "7 Y Y Done Y Done Y \n", "8 Y Y Done Y Done Y \n", "9 Y Y Done Y Done Y \n", "10 Y Y Done Y Done Y \n", "11 Y Y Done Y Done Y \n", "12 Y 迟到 Done 迟到 Done Y \n", "13 Y Y Done Y Done Y \n", "14 Y Y Done Y N N \n", "15 Y Y Done Y N N \n", "16 Y Y Done Y Done Y \n", "17 Y Y Done N 项目会议冲突 Done Y \n", "18 Y Y Done Y N Y \n", "19 Y Y Done Y Done Y \n", "20 Y 早退 Done Y Done Y \n", "21 Y NA(从第六节课来的插班生) Done NaN N NaN \n", "22 Y Y Done Y Done Y \n", "23 Y Y Done Y Done N \n", "24 Y Y Done Y Done N \n", "25 Y Y Done Y Done Y \n", "26 Y Y Done Y Done Y \n", "27 Y Y Done Y Done Y \n", "28 Y Y Done Y Done Y \n", "29 Y Y Done Y Done Y \n", "30 （四年经验（以后答疑）） NaN NaN \n", "\n", " Unnamed: 9 Session 4 Unnamed: 11 Session 5 Unnamed: 13 Session 6 \\\n", "0 N Y N Y NaN N \n", "1 Done Y Done Y NaN N 项目会议冲突 \n", "2 Done N shift Done N shift NaN N shift \n", "3 Done N 项目会议冲突 Incorrect Y NaN Y \n", "4 Done Y Done Y NaN Y \n", "5 Done N 项目会议冲突 Done Y NaN Y \n", "6 Done Y Done Y NaN Y \n", "7 Done Y Incorrect Y NaN Y \n", "8 Done Y Done Y NaN Y \n", "9 Done Y Done Y NaN Y \n", "10 Done Y Incorrect Y NaN Y \n", "11 Done Y Done Y NaN Y \n", "12 Incorrect Y Incorrect Y NaN Y \n", "13 Done Y Incorrect Y NaN N有其他会议 \n", "14 N N跟客户有会 N N NaN N跟客户有会 \n", "15 N N N Y NaN Y \n", "16 Done N 项目会议冲突 Incorrect Y NaN Y \n", "17 Done Y Done Y NaN Y \n", "18 Incorrect Y N Y NaN Y \n", "19 Done Y Done Y NaN Y \n", "20 Done N见客户 Incorrect Y NaN N跟客户有会议 \n", "21 N NaN N NaN NaN Y \n", "22 Done Y Incorrect Y NaN Y \n", "23 Done Y N Y NaN Y \n", "24 Done Y Done Y NaN Y \n", "25 Done Y Done Y NaN Y \n", "26 Done Y Done Y NaN Y \n", "27 Done Y Done Y NaN Y \n", "28 Incorrect Y Incorrect Y NaN Y \n", "29 Done Y Done Y NaN Y \n", "30 NaN NaN NaN NaN NaN NaN \n", "\n", " Unnamed: 15 Session 7 Unnamed: 17 Session 8 \n", "0 NaN Y NaN Y \n", "1 NaN Y NaN Y \n", "2 NaN N shift NaN N shift \n", "3 NaN N NaN Y \n", "4 NaN Y NaN N会议冲突 \n", "5 NaN Y NaN Y \n", "6 NaN Y NaN Y \n", "7 NaN Y NaN Y \n", "8 NaN Y NaN Y \n", "9 NaN Y NaN Y \n", "10 NaN Y NaN Y \n", "11 NaN Y NaN Y \n", "12 NaN Y NaN Y \n", "13 NaN Y NaN Y \n", "14 NaN Y NaN N \n", "15 NaN Y NaN Y \n", "16 NaN Y NaN N会议冲突 \n", "17 NaN Y NaN Y \n", "18 NaN Y NaN Y \n", "19 NaN Y NaN Y \n", "20 NaN Y NaN N跟客户有会议 \n", "21 NaN Y NaN Y \n", "22 NaN Y NaN Y \n", "23 NaN Y NaN Y \n", "24 NaN Y NaN Y \n", "25 NaN Y NaN Y \n", "26 NaN Y NaN Y \n", "27 NaN Y NaN Y \n", "28 NaN Y NaN Y \n", "29 NaN Y NaN Y \n", "30 NaN NaN NaN NaN " ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_demo" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## print the head rows" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
MailboxNotes IDTeam LeaderGithub accountSession 1Unnamed: 5Session 2Unnamed: 7Session 3Unnamed: 9Session 4Unnamed: 11Session 5Unnamed: 13Session 6Unnamed: 15Session 7Unnamed: 17Session 8
0pdlzhang@cn.ibm.comPing DZ Zhang/China/IBMCheng ChenYYIncorrectYNYNYNYNaNNNaNYNaNY
1yananzh@cn.ibm.comYa Nan YN Zhuang/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNaNN 项目会议冲突NaNYNaNY
2lizhjdl@cn.ibm.comZhen Jie DL Li/China/IBMCheng ChenYYDoneN shiftDoneN shiftDoneN shiftDoneN shiftNaNN shiftNaNN shiftNaNN shift
3yuanlyy@cn.ibm.comYuan Yuan YB Li/China/IBMCheng ChenYYDoneYIncorrectYDoneN 项目会议冲突IncorrectYNaNYNaNNNaNY
4shuyang@cn.ibm.comYang Shu/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNaNYNaNYNaNN会议冲突
\n", "
" ], "text/plain": [ " Mailbox Notes ID Team Leader Github account \\\n", "0 pdlzhang@cn.ibm.com Ping DZ Zhang/China/IBM Cheng Chen Y \n", "1 yananzh@cn.ibm.com Ya Nan YN Zhuang/China/IBM Cheng Chen Y \n", "2 lizhjdl@cn.ibm.com Zhen Jie DL Li/China/IBM Cheng Chen Y \n", "3 yuanlyy@cn.ibm.com Yuan Yuan YB Li/China/IBM Cheng Chen Y \n", "4 shuyang@cn.ibm.com Yang Shu/China/IBM Cheng Chen Y \n", "\n", " Session 1 Unnamed: 5 Session 2 Unnamed: 7 Session 3 Unnamed: 9 Session 4 \\\n", "0 Y Incorrect Y N Y N Y \n", "1 Y Done Y Done Y Done Y \n", "2 Y Done N shift Done N shift Done N shift \n", "3 Y Done Y Incorrect Y Done N 项目会议冲突 \n", "4 Y Done Y Done Y Done Y \n", "\n", " Unnamed: 11 Session 5 Unnamed: 13 Session 6 Unnamed: 15 Session 7 \\\n", "0 N Y NaN N NaN Y \n", "1 Done Y NaN N 项目会议冲突 NaN Y \n", "2 Done N shift NaN N shift NaN N shift \n", "3 Incorrect Y NaN Y NaN N \n", "4 Done Y NaN Y NaN Y \n", "\n", " Unnamed: 17 Session 8 \n", "0 NaN Y \n", "1 NaN Y \n", "2 NaN N shift \n", "3 NaN Y \n", "4 NaN N会议冲突 " ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_demo.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## print the tail rows" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
MailboxNotes IDTeam LeaderGithub accountSession 1Unnamed: 5Session 2Unnamed: 7Session 3Unnamed: 9Session 4Unnamed: 11Session 5Unnamed: 13Session 6Unnamed: 15Session 7Unnamed: 17Session 8
26caijm@cn.ibm.comJin Ming JM Cai/China/IBMWu DanYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
27lidannie@cn.ibm.comLi Dan N Nie/China/IBMWu DanYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
28dongmhtu@cn.ibm.comMei Hua TU Dong/China/IBMWu DanYYDoneYDoneYIncorrectYIncorrectYNaNYNaNYNaNY
29zhangwyi@cn.ibm.comWei Yi WY Zhang/China/IBMWu DanYYDoneYDoneYDoneYDoneYNaNYNaNYNaNY
30zhanglp@cn.ibm.comLian Ping Zhang/China/IBMHeng Cai（四年经验（以后答疑））NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "
" ], "text/plain": [ " Mailbox Notes ID Team Leader Github account \\\n", "26 caijm@cn.ibm.com Jin Ming JM Cai/China/IBM Wu Dan Y \n", "27 lidannie@cn.ibm.com Li Dan N Nie/China/IBM Wu Dan Y \n", "28 dongmhtu@cn.ibm.com Mei Hua TU Dong/China/IBM Wu Dan Y \n", "29 zhangwyi@cn.ibm.com Wei Yi WY Zhang/China/IBM Wu Dan Y \n", "30 zhanglp@cn.ibm.com Lian Ping Zhang/China/IBM Heng Cai （四年经验（以后答疑）） \n", "\n", " Session 1 Unnamed: 5 Session 2 Unnamed: 7 Session 3 Unnamed: 9 Session 4 \\\n", "26 Y Done Y Done Y Done Y \n", "27 Y Done Y Done Y Done Y \n", "28 Y Done Y Done Y Incorrect Y \n", "29 Y Done Y Done Y Done Y \n", "30 NaN NaN NaN NaN \n", "\n", " Unnamed: 11 Session 5 Unnamed: 13 Session 6 Unnamed: 15 Session 7 \\\n", "26 Done Y NaN Y NaN Y \n", "27 Done Y NaN Y NaN Y \n", "28 Incorrect Y NaN Y NaN Y \n", "29 Done Y NaN Y NaN Y \n", "30 NaN NaN NaN NaN NaN NaN \n", "\n", " Unnamed: 17 Session 8 \n", "26 NaN Y \n", "27 NaN Y \n", "28 NaN Y \n", "29 NaN Y \n", "30 NaN NaN " ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_demo.tail()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get one column" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 pdlzhang@cn.ibm.com\n", "1 yananzh@cn.ibm.com\n", "2 lizhjdl@cn.ibm.com\n", "3 yuanlyy@cn.ibm.com\n", "4 shuyang@cn.ibm.com\n", "5 zhouyldl@cn.ibm.com\n", "6 lizidl@cn.ibm.com\n", "7 wangyih@cn.ibm.com\n", "8 guoqq@cn.ibm.com\n", "9 shangx@cn.ibm.com\n", "10 xinzhdl@cn.ibm.com\n", "11 ymying@cn.ibm.com\n", "12 jmhjiang@cn.ibm.com\n", "13 xiaoywdl@cn.ibm.com\n", "14 wpeter@cn.ibm.com\n", "15 issczli@cn.ibm.com\n", "16 zoujin@cn.ibm.com\n", "17 fygao@cn.ibm.com\n", "18 dllsyliu@cn.ibm.com\n", "19 dlwjia@cn.ibm.com\n", "20 ssliu@cn.ibm.com\n", "21 fenghao@cn.ibm.com\n", "22 xhongdl@cn.ibm.com\n", "23 haojiedl@cn.ibm.com\n", "24 mumeilun@cn.ibm.com\n", "25 jinglil@cn.ibm.com\n", "26 caijm@cn.ibm.com\n", "27 lidannie@cn.ibm.com\n", "28 dongmhtu@cn.ibm.com\n", "29 zhangwyi@cn.ibm.com\n", "30 zhanglp@cn.ibm.com\n", "Name: Mailbox, dtype: object" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_demo['Mailbox']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## get part of the columns" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
MailboxNotes ID
0pdlzhang@cn.ibm.comPing DZ Zhang/China/IBM
1yananzh@cn.ibm.comYa Nan YN Zhuang/China/IBM
2lizhjdl@cn.ibm.comZhen Jie DL Li/China/IBM
3yuanlyy@cn.ibm.comYuan Yuan YB Li/China/IBM
4shuyang@cn.ibm.comYang Shu/China/IBM
5zhouyldl@cn.ibm.comYi Li AZ Zhou/China/IBM
6lizidl@cn.ibm.comZi DL Li/China/IBM
7wangyih@cn.ibm.comYi Han HY Wang/China/IBM
8guoqq@cn.ibm.comQian Qian QQ Guo/China/IBM
9shangx@cn.ibm.comXia Shang/China/IBM
10xinzhdl@cn.ibm.comXin RZ Zhang/China/IBM
11ymying@cn.ibm.comMiao Ying MY Yang/China/IBM
12jmhjiang@cn.ibm.comMing Hui LJ Jiang/China/IBM
13xiaoywdl@cn.ibm.comXiao Yan XY Wang/China/IBM
14wpeter@cn.ibm.comPeter Y Wang/China/IBM
15issczli@cn.ibm.comLi T Zhang/China/IBM
16zoujin@cn.ibm.comJin Zou/China/IBM
17fygao@cn.ibm.comFang Yue FY Gao/China/IBM
18dllsyliu@cn.ibm.comSi Yang IL Liu/China/IBM
19dlwjia@cn.ibm.comJia AW Wang/China/IBM
20ssliu@cn.ibm.comSheng Heng Liu/China/IBM
21fenghao@cn.ibm.comfenghao@cn.ibm.com
22xhongdl@cn.ibm.comHong XH Xiao/China/IBM
23haojiedl@cn.ibm.comJie EH Hao/China/IBM
24mumeilun@cn.ibm.comMei Lun IM Mu/China/IBM
25jinglil@cn.ibm.comJing Li Liu/China/IBM
26caijm@cn.ibm.comJin Ming JM Cai/China/IBM
27lidannie@cn.ibm.comLi Dan N Nie/China/IBM
28dongmhtu@cn.ibm.comMei Hua TU Dong/China/IBM
29zhangwyi@cn.ibm.comWei Yi WY Zhang/China/IBM
30zhanglp@cn.ibm.comLian Ping Zhang/China/IBM
\n", "
" ], "text/plain": [ " Mailbox Notes ID\n", "0 pdlzhang@cn.ibm.com Ping DZ Zhang/China/IBM\n", "1 yananzh@cn.ibm.com Ya Nan YN Zhuang/China/IBM\n", "2 lizhjdl@cn.ibm.com Zhen Jie DL Li/China/IBM\n", "3 yuanlyy@cn.ibm.com Yuan Yuan YB Li/China/IBM\n", "4 shuyang@cn.ibm.com Yang Shu/China/IBM\n", "5 zhouyldl@cn.ibm.com Yi Li AZ Zhou/China/IBM\n", "6 lizidl@cn.ibm.com Zi DL Li/China/IBM\n", "7 wangyih@cn.ibm.com Yi Han HY Wang/China/IBM\n", "8 guoqq@cn.ibm.com Qian Qian QQ Guo/China/IBM\n", "9 shangx@cn.ibm.com Xia Shang/China/IBM\n", "10 xinzhdl@cn.ibm.com Xin RZ Zhang/China/IBM\n", "11 ymying@cn.ibm.com Miao Ying MY Yang/China/IBM\n", "12 jmhjiang@cn.ibm.com Ming Hui LJ Jiang/China/IBM\n", "13 xiaoywdl@cn.ibm.com Xiao Yan XY Wang/China/IBM\n", "14 wpeter@cn.ibm.com Peter Y Wang/China/IBM\n", "15 issczli@cn.ibm.com Li T Zhang/China/IBM\n", "16 zoujin@cn.ibm.com Jin Zou/China/IBM\n", "17 fygao@cn.ibm.com Fang Yue FY Gao/China/IBM\n", "18 dllsyliu@cn.ibm.com Si Yang IL Liu/China/IBM\n", "19 dlwjia@cn.ibm.com Jia AW Wang/China/IBM\n", "20 ssliu@cn.ibm.com Sheng Heng Liu/China/IBM\n", "21 fenghao@cn.ibm.com fenghao@cn.ibm.com\n", "22 xhongdl@cn.ibm.com Hong XH Xiao/China/IBM\n", "23 haojiedl@cn.ibm.com Jie EH Hao/China/IBM\n", "24 mumeilun@cn.ibm.com Mei Lun IM Mu/China/IBM\n", "25 jinglil@cn.ibm.com Jing Li Liu/China/IBM\n", "26 caijm@cn.ibm.com Jin Ming JM Cai/China/IBM\n", "27 lidannie@cn.ibm.com Li Dan N Nie/China/IBM\n", "28 dongmhtu@cn.ibm.com Mei Hua TU Dong/China/IBM\n", "29 zhangwyi@cn.ibm.com Wei Yi WY Zhang/China/IBM\n", "30 zhanglp@cn.ibm.com Lian Ping Zhang/China/IBM" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_demo[['Mailbox', 'Notes ID']]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## data cleaning, process missing data" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [], "source": [ "df_demo.fillna('N', inplace=True)" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
MailboxNotes IDTeam LeaderGithub accountSession 1Unnamed: 5Session 2Unnamed: 7Session 3Unnamed: 9Session 4Unnamed: 11Session 5Unnamed: 13Session 6Unnamed: 15Session 7Unnamed: 17Session 8
0pdlzhang@cn.ibm.comPing DZ Zhang/China/IBMCheng ChenYYIncorrectYNYNYNYNNNYNY
1yananzh@cn.ibm.comYa Nan YN Zhuang/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNN 项目会议冲突NYNY
2lizhjdl@cn.ibm.comZhen Jie DL Li/China/IBMCheng ChenYYDoneN shiftDoneN shiftDoneN shiftDoneN shiftNN shiftNN shiftNN shift
3yuanlyy@cn.ibm.comYuan Yuan YB Li/China/IBMCheng ChenYYDoneYIncorrectYDoneN 项目会议冲突IncorrectYNYNNNY
4shuyang@cn.ibm.comYang Shu/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNYNYNN会议冲突
5zhouyldl@cn.ibm.comYi Li AZ Zhou/China/IBMCheng ChenYYDoneYDoneYDoneN 项目会议冲突DoneYNYNYNY
6lizidl@cn.ibm.comZi DL Li/China/IBMCheng ChenYYDoneYDoneYDoneYDoneYNYNYNY
7wangyih@cn.ibm.comYi Han HY Wang/China/IBMCheng ChenYYDoneYDoneYDoneYIncorrectYNYNYNY
8guoqq@cn.ibm.comQian Qian QQ Guo/China/IBMYin LuYYDoneYDoneYDoneYDoneYNYNYNY
9shangx@cn.ibm.comXia Shang/China/IBMYin LuYYDoneYDoneYDoneYDoneYNYNYNY
10xinzhdl@cn.ibm.comXin RZ Zhang/China/IBMYin LuYYDoneYDoneYDoneYIncorrectYNYNYNY
11ymying@cn.ibm.comMiao Ying MY Yang/China/IBMYin LuYYDoneYDoneYDoneYDoneYNYNYNY
12jmhjiang@cn.ibm.comMing Hui LJ Jiang/China/IBMYin LuY迟到Done迟到DoneYIncorrectYIncorrectYNYNYNY
13xiaoywdl@cn.ibm.comXiao Yan XY Wang/China/IBMYin LuYYDoneYDoneYDoneYIncorrectYNN有其他会议NYNY
14wpeter@cn.ibm.comPeter Y Wang/China/IBMYin LuYYDoneYNNNN跟客户有会NNNN跟客户有会NYNN
15issczli@cn.ibm.comLi T Zhang/China/IBMHeng CaiYYDoneYNNNNNYNYNYNY
16zoujin@cn.ibm.comJin Zou/China/IBMHeng CaiYYDoneYDoneYDoneN 项目会议冲突IncorrectYNYNYNN会议冲突
17fygao@cn.ibm.comFang Yue FY Gao/China/IBMHeng CaiYYDoneN 项目会议冲突DoneYDoneYDoneYNYNYNY
18dllsyliu@cn.ibm.comSi Yang IL Liu/China/IBMHeng CaiYYDoneYNYIncorrectYNYNYNYNY
19dlwjia@cn.ibm.comJia AW Wang/China/IBMHeng CaiYYDoneYDoneYDoneYDoneYNYNYNY
20ssliu@cn.ibm.comSheng Heng Liu/China/IBMHeng CaiY早退DoneYDoneYDoneN见客户IncorrectYNN跟客户有会议NYNN跟客户有会议
21fenghao@cn.ibm.comfenghao@cn.ibm.comHeng CaiYNA(从第六节课来的插班生)DoneNNNNNNNNYNYNY
22xhongdl@cn.ibm.comHong XH Xiao/China/IBMWu DanYYDoneYDoneYDoneYIncorrectYNYNYNY
23haojiedl@cn.ibm.comJie EH Hao/China/IBMWu DanYYDoneYDoneNDoneYNYNYNYNY
24mumeilun@cn.ibm.comMei Lun IM Mu/China/IBMWu DanYYDoneYDoneNDoneYDoneYNYNYNY
25jinglil@cn.ibm.comJing Li Liu/China/IBMWu DanYYDoneYDoneYDoneYDoneYNYNYNY
26caijm@cn.ibm.comJin Ming JM Cai/China/IBMWu DanYYDoneYDoneYDoneYDoneYNYNYNY
27lidannie@cn.ibm.comLi Dan N Nie/China/IBMWu DanYYDoneYDoneYDoneYDoneYNYNYNY
28dongmhtu@cn.ibm.comMei Hua TU Dong/China/IBMWu DanYYDoneYDoneYIncorrectYIncorrectYNYNYNY
29zhangwyi@cn.ibm.comWei Yi WY Zhang/China/IBMWu DanYYDoneYDoneYDoneYDoneYNYNYNY
30zhanglp@cn.ibm.comLian Ping Zhang/China/IBMHeng Cai（四年经验（以后答疑））NNNNNNNNNNNN
\n", "
" ], "text/plain": [ " Mailbox Notes ID Team Leader \\\n", "0 pdlzhang@cn.ibm.com Ping DZ Zhang/China/IBM Cheng Chen \n", "1 yananzh@cn.ibm.com Ya Nan YN Zhuang/China/IBM Cheng Chen \n", "2 lizhjdl@cn.ibm.com Zhen Jie DL Li/China/IBM Cheng Chen \n", "3 yuanlyy@cn.ibm.com Yuan Yuan YB Li/China/IBM Cheng Chen \n", "4 shuyang@cn.ibm.com Yang Shu/China/IBM Cheng Chen \n", "5 zhouyldl@cn.ibm.com Yi Li AZ Zhou/China/IBM Cheng Chen \n", "6 lizidl@cn.ibm.com Zi DL Li/China/IBM Cheng Chen \n", "7 wangyih@cn.ibm.com Yi Han HY Wang/China/IBM Cheng Chen \n", "8 guoqq@cn.ibm.com Qian Qian QQ Guo/China/IBM Yin Lu \n", "9 shangx@cn.ibm.com Xia Shang/China/IBM Yin Lu \n", "10 xinzhdl@cn.ibm.com Xin RZ Zhang/China/IBM Yin Lu \n", "11 ymying@cn.ibm.com Miao Ying MY Yang/China/IBM Yin Lu \n", "12 jmhjiang@cn.ibm.com Ming Hui LJ Jiang/China/IBM Yin Lu \n", "13 xiaoywdl@cn.ibm.com Xiao Yan XY Wang/China/IBM Yin Lu \n", "14 wpeter@cn.ibm.com Peter Y Wang/China/IBM Yin Lu \n", "15 issczli@cn.ibm.com Li T Zhang/China/IBM Heng Cai \n", "16 zoujin@cn.ibm.com Jin Zou/China/IBM Heng Cai \n", "17 fygao@cn.ibm.com Fang Yue FY Gao/China/IBM Heng Cai \n", "18 dllsyliu@cn.ibm.com Si Yang IL Liu/China/IBM Heng Cai \n", "19 dlwjia@cn.ibm.com Jia AW Wang/China/IBM Heng Cai \n", "20 ssliu@cn.ibm.com Sheng Heng Liu/China/IBM Heng Cai \n", "21 fenghao@cn.ibm.com fenghao@cn.ibm.com Heng Cai \n", "22 xhongdl@cn.ibm.com Hong XH Xiao/China/IBM Wu Dan \n", "23 haojiedl@cn.ibm.com Jie EH Hao/China/IBM Wu Dan \n", "24 mumeilun@cn.ibm.com Mei Lun IM Mu/China/IBM Wu Dan \n", "25 jinglil@cn.ibm.com Jing Li Liu/China/IBM Wu Dan \n", "26 caijm@cn.ibm.com Jin Ming JM Cai/China/IBM Wu Dan \n", "27 lidannie@cn.ibm.com Li Dan N Nie/China/IBM Wu Dan \n", "28 dongmhtu@cn.ibm.com Mei Hua TU Dong/China/IBM Wu Dan \n", "29 zhangwyi@cn.ibm.com Wei Yi WY Zhang/China/IBM Wu Dan \n", "30 zhanglp@cn.ibm.com Lian Ping Zhang/China/IBM Heng Cai \n", "\n", " Github account Session 1 Unnamed: 5 Session 2 Unnamed: 7 Session 3 \\\n", "0 Y Y Incorrect Y N Y \n", "1 Y Y Done Y Done Y \n", "2 Y Y Done N shift Done N shift \n", "3 Y Y Done Y Incorrect Y \n", "4 Y Y Done Y Done Y \n", "5 Y Y Done Y Done Y \n", "6 Y Y Done Y Done Y \n", "7 Y Y Done Y Done Y \n", "8 Y Y Done Y Done Y \n", "9 Y Y Done Y Done Y \n", "10 Y Y Done Y Done Y \n", "11 Y Y Done Y Done Y \n", "12 Y 迟到 Done 迟到 Done Y \n", "13 Y Y Done Y Done Y \n", "14 Y Y Done Y N N \n", "15 Y Y Done Y N N \n", "16 Y Y Done Y Done Y \n", "17 Y Y Done N 项目会议冲突 Done Y \n", "18 Y Y Done Y N Y \n", "19 Y Y Done Y Done Y \n", "20 Y 早退 Done Y Done Y \n", "21 Y NA(从第六节课来的插班生) Done N N N \n", "22 Y Y Done Y Done Y \n", "23 Y Y Done Y Done N \n", "24 Y Y Done Y Done N \n", "25 Y Y Done Y Done Y \n", "26 Y Y Done Y Done Y \n", "27 Y Y Done Y Done Y \n", "28 Y Y Done Y Done Y \n", "29 Y Y Done Y Done Y \n", "30 （四年经验（以后答疑）） N N \n", "\n", " Unnamed: 9 Session 4 Unnamed: 11 Session 5 Unnamed: 13 Session 6 \\\n", "0 N Y N Y N N \n", "1 Done Y Done Y N N 项目会议冲突 \n", "2 Done N shift Done N shift N N shift \n", "3 Done N 项目会议冲突 Incorrect Y N Y \n", "4 Done Y Done Y N Y \n", "5 Done N 项目会议冲突 Done Y N Y \n", "6 Done Y Done Y N Y \n", "7 Done Y Incorrect Y N Y \n", "8 Done Y Done Y N Y \n", "9 Done Y Done Y N Y \n", "10 Done Y Incorrect Y N Y \n", "11 Done Y Done Y N Y \n", "12 Incorrect Y Incorrect Y N Y \n", "13 Done Y Incorrect Y N N有其他会议 \n", "14 N N跟客户有会 N N N N跟客户有会 \n", "15 N N N Y N Y \n", "16 Done N 项目会议冲突 Incorrect Y N Y \n", "17 Done Y Done Y N Y \n", "18 Incorrect Y N Y N Y \n", "19 Done Y Done Y N Y \n", "20 Done N见客户 Incorrect Y N N跟客户有会议 \n", "21 N N N N N Y \n", "22 Done Y Incorrect Y N Y \n", "23 Done Y N Y N Y \n", "24 Done Y Done Y N Y \n", "25 Done Y Done Y N Y \n", "26 Done Y Done Y N Y \n", "27 Done Y Done Y N Y \n", "28 Incorrect Y Incorrect Y N Y \n", "29 Done Y Done Y N Y \n", "30 N N N N N N \n", "\n", " Unnamed: 15 Session 7 Unnamed: 17 Session 8 \n", "0 N Y N Y \n", "1 N Y N Y \n", "2 N N shift N N shift \n", "3 N N N Y \n", "4 N Y N N会议冲突 \n", "5 N Y N Y \n", "6 N Y N Y \n", "7 N Y N Y \n", "8 N Y N Y \n", "9 N Y N Y \n", "10 N Y N Y \n", "11 N Y N Y \n", "12 N Y N Y \n", "13 N Y N Y \n", "14 N Y N N \n", "15 N Y N Y \n", "16 N Y N N会议冲突 \n", "17 N Y N Y \n", "18 N Y N Y \n", "19 N Y N Y \n", "20 N Y N N跟客户有会议 \n", "21 N Y N Y \n", "22 N Y N Y \n", "23 N Y N Y \n", "24 N Y N Y \n", "25 N Y N Y \n", "26 N Y N Y \n", "27 N Y N Y \n", "28 N Y N Y \n", "29 N Y N Y \n", "30 N N N N " ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_demo" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "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.7.3" } }, "nbformat": 4, "nbformat_minor": 2 }