320200930970.ipynb · 叶子晴/dsp2022labs_2

forked from Steven / dsp2022labs

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

320200930970.ipynb 17.63 KB

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "f0f64c8d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "        gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
      "0         88150.776780            0    0.828006    0.531433    0.397509   \n",
      "1         88150.776787            0    0.459705    0.337051    0.186147   \n",
      "2         88150.779709            0    0.888789    0.543140    0.410668   \n",
      "3         88150.779759            0    0.550258    0.337923    0.173301   \n",
      "4         88150.787485            1    0.502595    0.340109    0.142989   \n",
      "...                ...          ...         ...         ...         ...   \n",
      "125259    88443.695600         8788    0.995336    0.407831    0.413470   \n",
      "125260    88443.697570         8788    0.948733    0.407552    0.414731   \n",
      "125261    88443.701580         8788    0.945284    0.407467    0.414705   \n",
      "125262    88443.703608         8788    0.945284    0.407160    0.415340   \n",
      "125263    88443.705574         8788    0.945284    0.407637    0.413674   \n",
      "\n",
      "                                 base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
      "0                            88150.77678-0        28.369753        52.033135   \n",
      "1                           88150.776787-1      -142.869866       154.788121   \n",
      "2                           88150.779709-0        38.942051        45.359863   \n",
      "3                           88150.779759-1      -141.879169       160.867779   \n",
      "4                           88150.787485-1      -139.404860       175.088321   \n",
      "...                                    ...              ...              ...   \n",
      "125259        88443.69561-0 88443.695591-1       327.648915      -173.027524   \n",
      "125260   88443.69561-0 88443.69953099999-1       311.054477      -161.381388   \n",
      "125261  88443.703629-0 88443.69953099999-1       313.566509      -162.585330   \n",
      "125262       88443.703629-0 88443.703587-1       297.019831      -152.352987   \n",
      "125263  88443.703629-0 88443.70751899999-1       323.629974      -170.142461   \n",
      "\n",
      "        gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  \\\n",
      "0            705.121116         20.000000  ...        -20.000000   \n",
      "1            684.981621        -39.934928  ...        -20.075283   \n",
      "2            705.232112         20.000000  ...        -20.000000   \n",
      "3            683.893108        -39.934928  ...        -20.075283   \n",
      "4            681.151453        -39.934928  ...        -20.075283   \n",
      "...                 ...               ...  ...               ...   \n",
      "125259     -2777.243340         19.888755  ...        -20.707271   \n",
      "125260     -2628.637408         19.888755  ...        -20.707271   \n",
      "125261     -2647.420719         19.888755  ...        -20.707271   \n",
      "125262     -2499.428189         19.888755  ...        -20.707271   \n",
      "125263     -2737.404466         19.888755  ...        -20.707271   \n",
      "\n",
      "        gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  \\\n",
      "0             0.011527        0.051002        0.998632               NaN   \n",
      "1            -0.141761        0.192518        0.971000               NaN   \n",
      "2             0.026087        0.041811        0.998785               NaN   \n",
      "3            -0.140397        0.200891        0.969501               NaN   \n",
      "4            -0.136989        0.220475        0.965725               NaN   \n",
      "...                ...             ...             ...               ...   \n",
      "125259       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125260       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125261       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125262       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125263       -0.111009        0.041794        0.992940        -37.372594   \n",
      "\n",
      "        eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  \\\n",
      "0                    NaN               NaN             NaN             NaN   \n",
      "1                    NaN               NaN             NaN             NaN   \n",
      "2                    NaN               NaN             NaN             NaN   \n",
      "3                    NaN               NaN             NaN             NaN   \n",
      "4                    NaN               NaN             NaN             NaN   \n",
      "...                  ...               ...             ...             ...   \n",
      "125259         14.763454        -23.294339       -0.130868        0.093021   \n",
      "125260         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125261         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125262         14.763454        -23.294339       -0.133311        0.091656   \n",
      "125263         14.763454        -23.294339       -0.131320        0.092941   \n",
      "\n",
      "        gaze_normal1_z  \n",
      "0                  NaN  \n",
      "1                  NaN  \n",
      "2                  NaN  \n",
      "3                  NaN  \n",
      "4                  NaN  \n",
      "...                ...  \n",
      "125259        0.987026  \n",
      "125260        0.986979  \n",
      "125261        0.986979  \n",
      "125262        0.986827  \n",
      "125263        0.986974  \n",
      "\n",
      "[125264 rows x 21 columns]\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "with open ('/Users/hxxy/Desktop/gaze.csv', 'r') as train:\n",
    "    df=pd.read_csv(train)\n",
    "    print(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6d3929ff",
   "metadata": {},
   "source": [
    "第一题"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "1d92511e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "        gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
      "21        88150.825638            2    0.915197    0.493612    0.398950   \n",
      "22        88150.827729            2    0.915197    0.493561    0.399305   \n",
      "23        88150.829663            2    0.915197    0.493570    0.399542   \n",
      "39        88150.866015            3    0.922197    0.492592    0.398705   \n",
      "40        88150.869620            3    0.922197    0.492635    0.398814   \n",
      "...                ...          ...         ...         ...         ...   \n",
      "125259    88443.695600         8788    0.995336    0.407831    0.413470   \n",
      "125260    88443.697570         8788    0.948733    0.407552    0.414731   \n",
      "125261    88443.701580         8788    0.945284    0.407467    0.414705   \n",
      "125262    88443.703608         8788    0.945284    0.407160    0.415340   \n",
      "125263    88443.705574         8788    0.945284    0.407637    0.413674   \n",
      "\n",
      "                                 base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
      "21           88150.827729-0 88150.823548-1         2.412810       -21.468145   \n",
      "22           88150.827729-0 88150.827729-1         2.429837       -21.374413   \n",
      "23      88150.827729-0 88150.83159799999-1         2.427118       -21.328193   \n",
      "39      88150.867514-0 88150.86451599999-1         2.827911       -21.750938   \n",
      "40           88150.867514-0 88150.871726-1         2.813774       -21.744854   \n",
      "...                                    ...              ...              ...   \n",
      "125259        88443.69561-0 88443.695591-1       327.648915      -173.027524   \n",
      "125260   88443.69561-0 88443.69953099999-1       311.054477      -161.381388   \n",
      "125261  88443.703629-0 88443.69953099999-1       313.566509      -162.585330   \n",
      "125262       88443.703629-0 88443.703587-1       297.019831      -152.352987   \n",
      "125263  88443.703629-0 88443.70751899999-1       323.629974      -170.142461   \n",
      "\n",
      "        gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  \\\n",
      "21          -295.071057         20.000000  ...        -20.000000   \n",
      "22          -294.819200         20.000000  ...        -20.000000   \n",
      "23          -294.874516         20.000000  ...        -20.000000   \n",
      "39          -298.233245         20.000000  ...        -20.000000   \n",
      "40          -298.471253         20.000000  ...        -20.000000   \n",
      "...                 ...               ...  ...               ...   \n",
      "125259     -2777.243340         19.888755  ...        -20.707271   \n",
      "125260     -2628.637408         19.888755  ...        -20.707271   \n",
      "125261     -2647.420719         19.888755  ...        -20.707271   \n",
      "125262     -2499.428189         19.888755  ...        -20.707271   \n",
      "125263     -2737.404466         19.888755  ...        -20.707271   \n",
      "\n",
      "        gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  \\\n",
      "21            0.062883        0.025100        0.997705        -39.934928   \n",
      "22            0.062883        0.025100        0.997705        -39.934928   \n",
      "23            0.062883        0.025100        0.997705        -39.934928   \n",
      "39            0.060717        0.025220        0.997836        -39.934928   \n",
      "40            0.060717        0.025220        0.997836        -39.934928   \n",
      "...                ...             ...             ...               ...   \n",
      "125259       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125260       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125261       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125262       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125263       -0.111009        0.041794        0.992940        -37.372594   \n",
      "\n",
      "        eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  \\\n",
      "21             14.997919        -20.075283       -0.150041        0.234536   \n",
      "22             14.997919        -20.075283       -0.150243        0.234115   \n",
      "23             14.997919        -20.075283       -0.150210        0.233747   \n",
      "39             14.997919        -20.075283       -0.149814        0.233510   \n",
      "40             14.997919        -20.075283       -0.149645        0.233258   \n",
      "...                  ...               ...             ...             ...   \n",
      "125259         14.763454        -23.294339       -0.130868        0.093021   \n",
      "125260         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125261         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125262         14.763454        -23.294339       -0.133311        0.091656   \n",
      "125263         14.763454        -23.294339       -0.131320        0.092941   \n",
      "\n",
      "        gaze_normal1_z  \n",
      "21            0.960458  \n",
      "22            0.960530  \n",
      "23            0.960624  \n",
      "39            0.960744  \n",
      "40            0.960831  \n",
      "...                ...  \n",
      "125259        0.987026  \n",
      "125260        0.986979  \n",
      "125261        0.986979  \n",
      "125262        0.986827  \n",
      "125263        0.986974  \n",
      "\n",
      "[87442 rows x 21 columns]\n",
      "87442\n"
     ]
    }
   ],
   "source": [
    "df.delete = df[df['confidence'] >= 0.9]\n",
    "print(df.delete)\n",
    "print(len(df.delete))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe10f053",
   "metadata": {},
   "source": [
    "第二题"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "ef75a4bc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "121084\n",
      "120135\n"
     ]
    }
   ],
   "source": [
    "with open ('/Users/hxxy/Desktop/gaze.csv', 'r') as train:\n",
    "    df=pd.read_csv(train)\n",
    "mean_x = df['norm_pos_x'].mean()\n",
    "mean_y = df['norm_pos_y'].mean()\n",
    "std_x = df['norm_pos_x'].std()\n",
    "std_y = df['norm_pos_y'].std()\n",
    "\n",
    "error_x = df[np.abs(df['norm_pos_x'] - mean_x) > 3*std_x]\n",
    "data_x = df[np.abs(df['norm_pos_x'] - mean_x) <= 3*std_x]\n",
    "\n",
    "error_y = df[np.abs(df['norm_pos_y'] - mean_y) > 3*std_y]\n",
    "data_y = df[np.abs(df['norm_pos_y'] - mean_y) <= 3*std_y]\n",
    "\n",
    "print(len(data_x))\n",
    "print(len(data_y))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7f49a7cf",
   "metadata": {},
   "source": [
    "第三题"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "c8bcc839",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0        1970-01-01 00:00:00.000088150\n",
      "1        1970-01-01 00:00:00.000088150\n",
      "2        1970-01-01 00:00:00.000088150\n",
      "3        1970-01-01 00:00:00.000088150\n",
      "4        1970-01-01 00:00:00.000088150\n",
      "                      ...             \n",
      "125259   1970-01-01 00:00:00.000088443\n",
      "125260   1970-01-01 00:00:00.000088443\n",
      "125261   1970-01-01 00:00:00.000088443\n",
      "125262   1970-01-01 00:00:00.000088443\n",
      "125263   1970-01-01 00:00:00.000088443\n",
      "Name: gaze_timestamp, Length: 125264, dtype: datetime64[ns]\n"
     ]
    }
   ],
   "source": [
    "import datetime\n",
    "with open ('/Users/hxxy/Desktop/gaze.csv', 'r') as train:\n",
    "    df=pd.read_csv(train)\n",
    "df['gaze_timestamp'] = pd.to_datetime(df['gaze_timestamp'])\n",
    "print(df['gaze_timestamp'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "055a06b0",
   "metadata": {},
   "source": [
    "第四题"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "2203ebbd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "125264"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "0b879210",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "427.62610766083765\n"
     ]
    }
   ],
   "source": [
    "with open ('/Users/hxxy/Desktop/gaze.csv', 'r') as train:\n",
    "    df=pd.read_csv(train)\n",
    "length = len(df)\n",
    "t1 = df['gaze_timestamp'][0]\n",
    "t2 = df['gaze_timestamp'][125263]\n",
    "hz = length/ (t2-t1)\n",
    "print(hz)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9693904f",
   "metadata": {},
   "source": [
    "第五题"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "8bbd5d62",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
      "gaze_timestamp                                                    \n",
      "1970-01-01      4397.003696    0.885771    0.410273     0.43832   \n",
      "\n",
      "                gaze_point_3d_x  gaze_point_3d_y  gaze_point_3d_z  \\\n",
      "gaze_timestamp                                                      \n",
      "1970-01-01           -37.442424         1.363367      -152.213023   \n",
      "\n",
      "                eye_center0_3d_x  eye_center0_3d_y  eye_center0_3d_z  \\\n",
      "gaze_timestamp                                                         \n",
      "1970-01-01             17.834794         14.561243        -20.730928   \n",
      "\n",
      "                gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  \\\n",
      "gaze_timestamp                                                   \n",
      "1970-01-01           -0.131272        0.034607        0.950761   \n",
      "\n",
      "                eye_center1_3d_x  eye_center1_3d_y  eye_center1_3d_z  \\\n",
      "gaze_timestamp                                                         \n",
      "1970-01-01            -37.070902         14.763101         -23.62837   \n",
      "\n",
      "                gaze_normal1_x  gaze_normal1_y  gaze_normal1_z  \n",
      "gaze_timestamp                                                  \n",
      "1970-01-01           -0.110092        0.079832        0.984028  \n"
     ]
    }
   ],
   "source": [
    "with open('/Users/hxxy/Desktop/gaze.csv', 'r') as train:\n",
    "    df=pd.read_csv(train)\n",
    "df['gaze_timestamp'] = pd.to_datetime(df['gaze_timestamp'])\n",
    "df_5 = df.resample (\"0.01S\",on = \"gaze_timestamp\").mean()\n",
    "result = df_5.head(20)\n",
    "print(result)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}

一键复制编辑原始数据按行查看历史

提交于 2022-03-12 03:34 . 320200930970

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

https://gitee.com/schweinye/dsp2022labs_2.git

git@gitee.com:schweinye/dsp2022labs_2.git

schweinye

dsp2022labs_2

master

叶子晴 / dsp2022labs_2

简介

发行版

贡献者

近期动态

叶子晴 / dsp2022labs_2 .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

叶子晴 / dsp2022labs_2