gen_subject_spatialpy_group.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting xlsxwriter\n",
      "  Downloading XlsxWriter-3.2.0-py3-none-any.whl.metadata (2.6 kB)\n",
      "Downloading XlsxWriter-3.2.0-py3-none-any.whl (159 kB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m159.9/159.9 kB\u001b[0m \u001b[31m15.1 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
      "\u001b[?25hInstalling collected packages: xlsxwriter\n",
      "Successfully installed xlsxwriter-3.2.0\n"
     ]
    }
   ],
   "source": [
    "!pip install xlsxwriter "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_WetSunset\n",
      "Town03_FogMorning\n",
      "Town04_WetCloudyNoon\n",
      "Town05_ClearSunset\n",
      "Town06_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_WetCloudyNoon\n",
      "Town03_FogMorning\n",
      "Town04_HardRainSunset\n",
      "Town05_WetSunset\n",
      "Town06_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "['Town08']\n",
      "Town08_ClearSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_WetSunset\n",
      "Town03_WetCloudyNoon\n",
      "Town04_ClearNight\n",
      "Town05_ClearSunset\n",
      "Town06_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_FogMorning\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_ClearSunset\n",
      "Town03_FogMorning\n",
      "Town04_ClearNight\n",
      "Town05_WetSunset\n",
      "Town06_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNight\n",
      "Town02_FogMorning\n",
      "Town03_ClearSunset\n",
      "Town04_ClearNoon\n",
      "Town05_HardRainSunset\n",
      "Town06_WetSunset\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_FogMorning\n",
      "Town02_ClearSunset\n",
      "Town03_HardRainSunset\n",
      "Town04_ClearNoon\n",
      "Town05_WetCloudyNoon\n",
      "Town06_ClearNight\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_ClearSunset\n",
      "Town03_FogMorning\n",
      "Town04_WetSunset\n",
      "Town05_HardRainSunset\n",
      "Town06_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "Town07_FogMorning\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_ClearNoon\n",
      "Town03_WetSunset\n",
      "Town04_ClearNight\n",
      "Town05_FogMorning\n",
      "Town06_ClearSunset\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_HardRainSunset\n",
      "Town03_FogMorning\n",
      "Town04_WetSunset\n",
      "Town05_WetCloudyNoon\n",
      "Town06_ClearNight\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_ClearSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearSunset\n",
      "Town02_FogMorning\n",
      "Town03_ClearNoon\n",
      "Town04_HardRainSunset\n",
      "Town05_WetSunset\n",
      "Town06_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_FogMorning\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_WetCloudyNoon\n",
      "Town03_WetSunset\n",
      "Town04_ClearNight\n",
      "Town05_ClearSunset\n",
      "Town06_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_HardRainSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_FogMorning\n",
      "Town03_ClearSunset\n",
      "Town04_WetCloudyNoon\n",
      "Town05_HardRainSunset\n",
      "Town06_ClearNight\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_FogMorning\n",
      "Town03_HardRainSunset\n",
      "Town04_ClearNight\n",
      "Town05_ClearSunset\n",
      "Town06_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_ClearNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_ClearNight\n",
      "Town03_HardRainSunset\n",
      "Town04_ClearSunset\n",
      "Town05_ClearNoon\n",
      "Town06_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_ClearSunset\n",
      "['Town08']\n",
      "Town08_FogMorning\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_ClearSunset\n",
      "Town03_HardRainSunset\n",
      "Town04_WetSunset\n",
      "Town05_FogMorning\n",
      "Town06_ClearNight\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_FogMorning\n",
      "Town02_WetCloudyNoon\n",
      "Town03_ClearNoon\n",
      "Town04_ClearSunset\n",
      "Town05_HardRainSunset\n",
      "Town06_ClearNight\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_ClearNight\n",
      "Town03_ClearNoon\n",
      "Town04_HardRainSunset\n",
      "Town05_FogMorning\n",
      "Town06_ClearSunset\n",
      "Town07_ClearSunset\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_FogMorning\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_ClearSunset\n",
      "Town03_WetSunset\n",
      "Town04_FogMorning\n",
      "Town05_ClearNight\n",
      "Town06_HardRainSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearSunset\n",
      "Town02_FogMorning\n",
      "Town03_WetCloudyNoon\n",
      "Town04_WetSunset\n",
      "Town05_ClearNoon\n",
      "Town06_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_FogMorning\n",
      "Town07_WetCloudyNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_HardRainSunset\n",
      "Town03_ClearSunset\n",
      "Town04_WetCloudyNoon\n",
      "Town05_FogMorning\n",
      "Town06_WetSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_ClearNight\n",
      "Town03_ClearSunset\n",
      "Town04_FogMorning\n",
      "Town05_WetSunset\n",
      "Town06_ClearNoon\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_HardRainSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_HardRainSunset\n",
      "Town03_WetCloudyNoon\n",
      "Town04_ClearNoon\n",
      "Town05_FogMorning\n",
      "Town06_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_ClearSunset\n",
      "['Town08']\n",
      "Town08_ClearSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearSunset\n",
      "Town02_ClearNight\n",
      "Town03_HardRainSunset\n",
      "Town04_FogMorning\n",
      "Town05_ClearNoon\n",
      "Town06_WetSunset\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_ClearSunset\n",
      "Town03_WetCloudyNoon\n",
      "Town04_ClearNight\n",
      "Town05_FogMorning\n",
      "Town06_ClearNoon\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNight\n",
      "Town02_FogMorning\n",
      "Town03_HardRainSunset\n",
      "Town04_ClearNoon\n",
      "Town05_WetSunset\n",
      "Town06_ClearSunset\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNight\n",
      "Town02_FogMorning\n",
      "Town03_ClearSunset\n",
      "Town04_WetSunset\n",
      "Town05_ClearNoon\n",
      "Town06_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_ClearSunset\n",
      "Town03_FogMorning\n",
      "Town04_HardRainSunset\n",
      "Town05_ClearNight\n",
      "Town06_ClearNoon\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_ClearNoon\n",
      "Town03_WetCloudyNoon\n",
      "Town04_FogMorning\n",
      "Town05_ClearNight\n",
      "Town06_ClearSunset\n",
      "Town07_ClearSunset\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_ClearNight\n",
      "Town03_WetSunset\n",
      "Town04_ClearSunset\n",
      "Town05_HardRainSunset\n",
      "Town06_ClearNoon\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_ClearNight\n",
      "['Town08']\n",
      "Town08_FogMorning\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_ClearNoon\n",
      "Town03_ClearSunset\n",
      "Town04_ClearNight\n",
      "Town05_FogMorning\n",
      "Town06_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "['Town08']\n",
      "Town08_HardRainSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_ClearNight\n",
      "Town03_WetCloudyNoon\n",
      "Town04_ClearSunset\n",
      "Town05_FogMorning\n",
      "Town06_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_ClearNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_FogMorning\n",
      "Town03_ClearNight\n",
      "Town04_HardRainSunset\n",
      "Town05_WetCloudyNoon\n",
      "Town06_ClearSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_FogMorning\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_ClearNight\n",
      "Town03_WetSunset\n",
      "Town04_ClearSunset\n",
      "Town05_HardRainSunset\n",
      "Town06_FogMorning\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearSunset\n",
      "Town02_FogMorning\n",
      "Town03_HardRainSunset\n",
      "Town04_WetCloudyNoon\n",
      "Town05_WetSunset\n",
      "Town06_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNight\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_ClearNoon\n",
      "Town03_WetCloudyNoon\n",
      "Town04_HardRainSunset\n",
      "Town05_ClearSunset\n",
      "Town06_FogMorning\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_WetSunset\n",
      "Town03_FogMorning\n",
      "Town04_ClearNight\n",
      "Town05_ClearSunset\n",
      "Town06_ClearNoon\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_WetCloudyNoon\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_FogMorning\n",
      "Town02_HardRainSunset\n",
      "Town03_ClearNight\n",
      "Town04_ClearSunset\n",
      "Town05_ClearNoon\n",
      "Town06_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_ClearNight\n",
      "Town07_ClearSunset\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_ClearSunset\n",
      "Town03_WetSunset\n",
      "Town04_FogMorning\n",
      "Town05_ClearNight\n",
      "Town06_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_ClearNoon\n",
      "Town03_HardRainSunset\n",
      "Town04_ClearNight\n",
      "Town05_FogMorning\n",
      "Town06_ClearSunset\n",
      "Town07_ClearNight\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetCloudyNoon\n",
      "Town02_ClearNight\n",
      "Town03_ClearNoon\n",
      "Town04_WetSunset\n",
      "Town05_FogMorning\n",
      "Town06_HardRainSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "Town07_WetSunset\n",
      "Town07_ClearNight\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_ClearSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_WetSunset\n",
      "Town02_ClearNoon\n",
      "Town03_WetCloudyNoon\n",
      "Town04_HardRainSunset\n",
      "Town05_ClearNight\n",
      "Town06_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNoon\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "['Town08']\n",
      "Town08_ClearSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_ClearNoon\n",
      "Town03_FogMorning\n",
      "Town04_WetSunset\n",
      "Town05_ClearSunset\n",
      "Town06_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_FogMorning\n",
      "Town03_ClearSunset\n",
      "Town04_HardRainSunset\n",
      "Town05_WetCloudyNoon\n",
      "Town06_ClearNight\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNight\n",
      "Town07_ClearNoon\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNoon\n",
      "Town02_ClearSunset\n",
      "Town03_FogMorning\n",
      "Town04_ClearNight\n",
      "Town05_WetSunset\n",
      "Town06_WetCloudyNoon\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_HardRainSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNight\n",
      "Town02_WetCloudyNoon\n",
      "Town03_WetSunset\n",
      "Town04_ClearSunset\n",
      "Town05_ClearNoon\n",
      "Town06_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearSunset\n",
      "['Town08']\n",
      "Town08_HardRainSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearSunset\n",
      "Town02_FogMorning\n",
      "Town03_WetCloudyNoon\n",
      "Town04_HardRainSunset\n",
      "Town05_WetSunset\n",
      "Town06_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_ClearSunset\n",
      "Town07_FogMorning\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearNoon\n",
      "['Town08']\n",
      "Town08_ClearNight\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearNight\n",
      "Town02_WetCloudyNoon\n",
      "Town03_FogMorning\n",
      "Town04_ClearSunset\n",
      "Town05_ClearNoon\n",
      "Town06_WetSunset\n",
      "Town07_ClearSunset\n",
      "Town07_HardRainSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_ClearNight\n",
      "Town07_FogMorning\n",
      "Town07_ClearNoon\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_HardRainSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearSunset\n",
      "Town02_WetCloudyNoon\n",
      "Town03_FogMorning\n",
      "Town04_ClearNight\n",
      "Town05_ClearNoon\n",
      "Town06_HardRainSunset\n",
      "Town07_ClearSunset\n",
      "Town07_ClearNoon\n",
      "Town07_HardRainSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_WetSunset\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "['Town08']\n",
      "Town08_WetSunset\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_ClearSunset\n",
      "Town02_FogMorning\n",
      "Town03_ClearNight\n",
      "Town04_HardRainSunset\n",
      "Town05_WetCloudyNoon\n",
      "Town06_WetSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "Town07_FogMorning\n",
      "Town07_ClearNight\n",
      "Town07_HardRainSunset\n",
      "Town07_WetSunset\n",
      "['Town08']\n",
      "Town08_ClearNoon\n",
      "['Town01', 'Town02', 'Town03', 'Town04', 'Town05', 'Town06']\n",
      "Town01_HardRainSunset\n",
      "Town02_ClearNoon\n",
      "Town03_ClearNight\n",
      "Town04_WetSunset\n",
      "Town05_ClearSunset\n",
      "Town06_FogMorning\n",
      "Town07_WetSunset\n",
      "Town07_ClearNoon\n",
      "Town07_ClearNight\n",
      "Town07_FogMorning\n",
      "Town07_HardRainSunset\n",
      "Town07_ClearSunset\n",
      "Town07_WetCloudyNoon\n",
      "['Town08']\n",
      "Town08_WetCloudyNoon\n"
     ]
    }
   ],
   "source": [
    "# import xlsxwriter module\n",
    "import xlsxwriter\n",
    "import random\n",
    "import copy\n",
    "\n",
    "# Some data we want to write to the worksheet.\n",
    "town_name = [\"Town01\", \"Town02\", \"Town03\", \"Town04\", \"Town05\", \"Town06\", \"Town07\", \"Town08\"]\n",
    "weather_name = [\"ClearNight\", \"ClearNoon\", \"ClearSunset\", \"FogMorning\", \"HardRainSunset\", \"WetCloudyNoon\", \"WetSunset\"]\n",
    "dir=\"conditions/groups/\"\n",
    "\n",
    "index_town_allweather = 6\n",
    "cross_town_name = town_name[:index_town_allweather] + town_name[index_town_allweather+1:]\n",
    "\n",
    "start_id = 0\n",
    "participant_num = 50\n",
    "for index in range(participant_num):\n",
    "    filename_participant = \"{id:02d}.xlsx\".format(id=index+start_id)\n",
    "    \n",
    "    workbook = xlsxwriter.Workbook(dir+filename_participant)\n",
    "    worksheet = workbook.add_worksheet()\n",
    "\n",
    "    random_weather = random.shuffle(weather_name)\n",
    "    \n",
    "    # write town weather name\n",
    "    worksheet.write(0, 0, \"town_weather_name\")\n",
    "    \n",
    "    front_town_name = town_name[:index_town_allweather]\n",
    "    print(front_town_name)\n",
    "    for i in range(0,len(front_town_name)) :\n",
    "        item = town_name[i]+\"_\"+weather_name[i]\n",
    "        print(item)\n",
    "        worksheet.write(i+1, 0, item)\n",
    "    \n",
    "    weather_for_onetown_name = copy.deepcopy(weather_name)\n",
    "    random_weather_for_onetown = random.shuffle(weather_for_onetown_name)\n",
    "    # print(weather_for_onetown_name)\n",
    "    for i in range(len(weather_for_onetown_name)) :\n",
    "        item = town_name[index_town_allweather]+\"_\"+weather_for_onetown_name[i]\n",
    "        print(item)\n",
    "        worksheet.write(i+1+len(front_town_name), 0, item)\n",
    "\n",
    "    behind_town_name = town_name[index_town_allweather+1:]\n",
    "    print(behind_town_name)\n",
    "    for i in range(len(behind_town_name)):\n",
    "        item = behind_town_name[i]+\"_\"+weather_name[i+len(front_town_name)]\n",
    "        print(item)\n",
    "        worksheet.write(i+1+len(front_town_name)+len(weather_for_onetown_name), 0, item)\n",
    "\n",
    "    workbook.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "aee8b7b246df8f9039afb4144a1f6fd8d2ca17a180786b69acc140d282b71a49"
  },
  "kernelspec": {
   "display_name": "Python 3.9.6 64-bit",
   "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.9.7"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}