Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "items = {'note':1,'notebook':2,'sketchbook':3}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>N0</th>\n",
       "      <th>90</th>\n",
       "      <th>G</th>\n",
       "      <th>0</th>\n",
       "      <th>X</th>\n",
       "      <th>160</th>\n",
       "      <th>Z</th>\n",
       "      <th>60</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 10</th>\n",
       "      <th>Unnamed: 11</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "      <th>Unnamed: 15</th>\n",
       "      <th>Unnamed: 16</th>\n",
       "      <th>Unnamed: 17</th>\n",
       "      <th>Unnamed: 18</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>N0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T0001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>N0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>G</td>\n",
       "      <td>1.0</td>\n",
       "      <td>X</td>\n",
       "      <td>147.00</td>\n",
       "      <td>Z</td>\n",
       "      <td>65.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>N0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>G</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Z</td>\n",
       "      <td>125.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>R</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>N0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>G</td>\n",
       "      <td>2.0</td>\n",
       "      <td>X</td>\n",
       "      <td>142.00</td>\n",
       "      <td>Z</td>\n",
       "      <td>69.68</td>\n",
       "      <td>R</td>\n",
       "      <td>500.0</td>\n",
       "      <td>F</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>N0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>G</td>\n",
       "      <td>1.0</td>\n",
       "      <td>X</td>\n",
       "      <td>147.00</td>\n",
       "      <td>Z</td>\n",
       "      <td>65.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>G</td>\n",
       "      <td>1.0</td>\n",
       "      <td>X</td>\n",
       "      <td>298.00</td>\n",
       "      <td>F</td>\n",
       "      <td>2000.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>G</td>\n",
       "      <td>1.0</td>\n",
       "      <td>X</td>\n",
       "      <td>316.00</td>\n",
       "      <td>F</td>\n",
       "      <td>100.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>G</td>\n",
       "      <td>1.0</td>\n",
       "      <td>X</td>\n",
       "      <td>300.00</td>\n",
       "      <td>F</td>\n",
       "      <td>3000.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>G</td>\n",
       "      <td>0.0</td>\n",
       "      <td>X</td>\n",
       "      <td>280.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>G</td>\n",
       "      <td>28.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>U0.</td>\n",
       "      <td>W0.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>76 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     N0     90    G     0    X     160    Z       60 Unnamed: 8  Unnamed: 9  \\\n",
       "0    N0  100.0  NaN   NaN  NaN     NaN  NaN      NaN        NaN         NaN   \n",
       "1    N0  110.0    G   1.0    X  147.00    Z    65.30        NaN         NaN   \n",
       "2    N0  120.0    G   3.0    Z  125.35  NaN      NaN          R       500.0   \n",
       "3    N0  130.0    G   2.0    X  142.00    Z    69.68          R       500.0   \n",
       "4    N0  140.0    G   1.0    X  147.00    Z    65.30        NaN         NaN   \n",
       "..  ...    ...  ...   ...  ...     ...  ...      ...        ...         ...   \n",
       "71  NaN    NaN    G   1.0    X  298.00    F  2000.00        NaN         NaN   \n",
       "72  NaN    NaN    G   1.0    X  316.00    F   100.00        NaN         NaN   \n",
       "73  NaN    NaN    G   1.0    X  300.00    F  3000.00        NaN         NaN   \n",
       "74  NaN    NaN    G   0.0    X  280.00  NaN      NaN        NaN         NaN   \n",
       "75  NaN    NaN    G  28.0  NaN     NaN  NaN      NaN        NaN         NaN   \n",
       "\n",
       "   Unnamed: 10  Unnamed: 11 Unnamed: 12  Unnamed: 13 Unnamed: 14  Unnamed: 15  \\\n",
       "0          NaN          NaN       T0001          NaN         NaN          NaN   \n",
       "1            F       4000.0         NaN          NaN         NaN          NaN   \n",
       "2          NaN          NaN         NaN          NaN         NaN          NaN   \n",
       "3            F       4000.0         NaN          NaN         NaN          NaN   \n",
       "4          NaN          NaN         NaN          NaN         NaN          NaN   \n",
       "..         ...          ...         ...          ...         ...          ...   \n",
       "71         NaN          NaN         NaN          NaN         NaN          NaN   \n",
       "72         NaN          NaN         NaN          NaN         NaN          NaN   \n",
       "73         NaN          NaN         NaN          NaN         NaN          NaN   \n",
       "74         NaN          NaN         NaN          NaN         NaN          NaN   \n",
       "75         NaN          NaN         NaN          NaN         NaN          NaN   \n",
       "\n",
       "   Unnamed: 16  Unnamed: 17 Unnamed: 18 Unnamed: 19  \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",
       "71         NaN          NaN         NaN         NaN  \n",
       "72         NaN          NaN         NaN         NaN  \n",
       "73         NaN          NaN         NaN         NaN  \n",
       "74         NaN          NaN         NaN         NaN  \n",
       "75         NaN          NaN         U0.         W0.  \n",
       "\n",
       "[76 rows x 20 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import glob\n",
    "\n",
    "df0 = pd.read_csv('501.csv', encoding = \"shift-jis\", engine='python')\n",
    "df0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['N0090', '', 'G00', 'X160.', 'Z60.\\n']\n"
     ]
    }
   ],
   "source": [
    "with open('501.txt') as f:\n",
    "    s = f.readlines()\n",
    "    l=s[0].split(' ')\n",
    "    print(l)\n",
    "\n",
    "    \n",
    "    #print(l[0][0:2],l[0][2:])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}