0715-4.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "file=open('aqx_p_432.csv',newline='',mode='r',encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['sitename', 'county', 'aqi', 'pollutant', 'status', 'so2', 'co', 'o3', 'o3_8hr', 'pm10', 'pm2.5', 'no2', 'nox', 'no', 'wind_speed', 'wind_direc', 'publishtime', 'co_8hr', 'pm2.5_avg', 'pm10_avg', 'so2_avg', 'longitude', 'latitude', 'siteid']\n",
      "['桃園', '桃園市', '61', '臭氧八小時', '普通', '2.6', '0.22', '67.7', '58.4', '34', '9', '8.6', '9.6', '1', '2.2', '326', '2023/07/15 15:00:00', '0.2', '15.5', '33', '1', '121.30500531', '24.9947107', '17']\n",
      "['平鎮', '桃園市', '54', '細懸浮微粒', '普通', '1.7', '0.28', '66', '52.3', '36', '16', '8.4', '9.8', '1.4', '2.4', '26', '2023/07/15 15:00:00', '0.2', '16.8', '34', '1', '121.203986', '24.952786', '20']\n",
      "['龍潭', '桃園市', '53', '細懸浮微粒', '普通', '0.6', '0.27', '68', '55.5', '36', '18', '7.1', '8', '0.9', '2.4', '19', '2023/07/15 15:00:00', '0.2', '16.3', '31', '0', '121.21645772', '24.86400048', '21']\n",
      "['三義', '苗栗縣', '66', '細懸浮微粒', '普通', '1.3', '0.12', '46.8', '45.2', '', '10', '2.3', '3.3', '1', '1.9', '346', '2023/07/15 15:00:00', '0.1', '21.5', '', '1', '120.75956754', '24.38248443', '27']\n",
      "['嘉義', '嘉義市', '54', '臭氧八小時', '普通', '3', '0.14', '55.8', '56.8', '20', '9', '3.6', '4.5', '0.9', '3.3', '306', '2023/07/15 15:00:00', '0.1', '12.8', '27', '2', '120.44125148', '23.46477865', '42']\n",
      "['大寮', '高雄市', '54', '細懸浮微粒', '普通', '1.6', '0.15', '47.7', '46.7', '34', '13', '7.7', '8.9', '1.2', '2.3', '296', '2023/07/15 15:00:00', '0.2', '16.7', '35', '2', '120.425311', '22.56413611', '51']\n",
      "['林園', '高雄市', '64', '臭氧八小時', '普通', '1.8', '0.14', '59.7', '59', '24', '10', '2.6', '2.9', '0.3', '3.7', '299', '2023/07/15 15:00:00', '0.1', '12.2', '32', '1', '120.41175', '22.4795', '52']\n",
      "['潮州', '屏東縣', '53', '細懸浮微粒', '普通', '2.6', '0.21', '73.6', '55.5', '27', '15', '', '', '', '3.8', '279', '2023/07/15 15:00:00', '0.2', '16.4', '28', '1', '120.561175', '22.523108', '60']\n",
      "['金門', '金門縣', '64', '臭氧八小時', '普通', '2.5', '0.2', '70.4', '59.4', '16', '11', '4.3', '4.7', '0.4', '2.9', '140', '2023/07/15 15:00:00', '0.2', '17.3', '22', '2', '118.312256', '24.432133', '77']\n",
      "['高雄(湖內)', '高雄市', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023/07/15 15:00:00', '', '', '', '', '120.24535', '22.87985556', '202']\n",
      "['屏東(琉球)', '屏東縣', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2023/07/15 15:00:00', '', '', '', '', '120.37722', '22.35222', '204']\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "csv_reader = csv.reader(file)\n",
    "\n",
    "for item in csv_reader:\n",
    "    if item[4] != \"良好\":\n",
    "        print(item)"
   ]
  }
 ],
 "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.10.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}