hermes_partial_shuffler.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "60f308b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\"\n",
    "Inputs NFT metadata, shuffles part of it, outputs shuffled metadata\n",
    "\n",
    "Use case: \n",
    "a week ago we revealed part of our collection but not the whole thing\n",
    "Today we want to assign metadata to NFTs which were bought after the previous \n",
    "shuffle. \n",
    "\n",
    "Inputs: \n",
    "trait_sheet: a csv with columns:\n",
    "Image_Number,Eyes,Backgrounds,Mask,Headgear,Outfit,Accessory_M,Accessory_F,Gender\n",
    "\n",
    "seed: a 256 bit integer generated by the chainlink VRF\n",
    "Obtain seed by calling s_randomWords(0) on 0xbD1d2Ea3127587f4ECFD271e1dADFc95320b8DeA\n",
    "for the first reveal. \n",
    "\n",
    "\"\"\"\n",
    "#Metadata for the current NFTs -- \n",
    "TRAIT_SHEET_NAME='03_11_21_HonestNFT_Vigilante_Metadata.csv'\n",
    "#token ID of the last token which was revealed -- revealed tokens remain static\n",
    "LAST_REVEALED=1330\n",
    "#chainlink gives us a 256-bit int but pandas can only handle an int up to 2^32-1 so we take modulo here\n",
    "SEED=98718832011749334867803327334638907568821983820441926603690513%(2**32-1)\n",
    "\n",
    "import pandas as pd\n",
    "#load trait sheet\n",
    "full_trait_sheet=pd.read_csv(TRAIT_SHEET_NAME)\n",
    "\n",
    "#get metadata for all unrevealed NFTs\n",
    "trait_sheet_to_shuffle=full_trait_sheet.tail(3777-LAST_REVEALED)\n",
    "\n",
    "#shuffle\n",
    "trait_sheet_shuffled=trait_sheet_to_shuffle.sample(frac=1,random_state=SEED).reset_index(drop=True)\n",
    "#update token IDs for newly revealed NFTs\n",
    "trait_sheet_shuffled['TOKEN ID']=trait_sheet_shuffled.index+1+LAST_REVEALED\n",
    "#append newly revealed NFTs to previously revealed NFTs\n",
    "new_trait_sheet=full_trait_sheet[0:LAST_REVEALED].append(trait_sheet_shuffled)\n",
    "#output shuffled sheet\n",
    "new_trait_sheet.to_csv('shuffled_'+TRAIT_SHEET_NAME,index=False)\n",
    " "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "d8e56470",
   "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>Image_Number</th>\n",
       "      <th>Eyes</th>\n",
       "      <th>Background</th>\n",
       "      <th>Masks</th>\n",
       "      <th>Headgear</th>\n",
       "      <th>Outfit</th>\n",
       "      <th>Accessory_M</th>\n",
       "      <th>Accessory_F</th>\n",
       "      <th>Gender</th>\n",
       "      <th>TOKEN ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2838</td>\n",
       "      <td>Binary Pink</td>\n",
       "      <td>Cosmos 2</td>\n",
       "      <td>Gold</td>\n",
       "      <td>Yellow Hoodie</td>\n",
       "      <td>Yellow Hoodie</td>\n",
       "      <td>Blue Face Bandana</td>\n",
       "      <td>Blue Face Bandana</td>\n",
       "      <td>Masculine</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3063</td>\n",
       "      <td>Solid White</td>\n",
       "      <td>Brown</td>\n",
       "      <td>Green Tech</td>\n",
       "      <td>White Hoodie</td>\n",
       "      <td>White Hoodie</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Masculine</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2104</td>\n",
       "      <td>Electronic Blue &amp; Yellow</td>\n",
       "      <td>Yellow</td>\n",
       "      <td>Red Tech</td>\n",
       "      <td>Red Bucket Hat</td>\n",
       "      <td>Spiked Black Leather Jacket</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Masculine</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1779</td>\n",
       "      <td>Blue &amp; Black</td>\n",
       "      <td>Deep Fried Abstract</td>\n",
       "      <td>Silver</td>\n",
       "      <td>Pink Hoodie</td>\n",
       "      <td>Pink Hoodie</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Masculine</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>448</td>\n",
       "      <td>Electronic Blue</td>\n",
       "      <td>Gray</td>\n",
       "      <td>Red Tech</td>\n",
       "      <td>Tan Fedora</td>\n",
       "      <td>Yellow Jacket</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Feminine</td>\n",
       "      <td>5</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3772</th>\n",
       "      <td>1939</td>\n",
       "      <td>Electronic Blue &amp; Yellow</td>\n",
       "      <td>Green Grid</td>\n",
       "      <td>Black</td>\n",
       "      <td>Black Fedora</td>\n",
       "      <td>Light Blue Suit</td>\n",
       "      <td>Cowboy Moustache</td>\n",
       "      <td>Silver Hoop Earrings</td>\n",
       "      <td>Feminine</td>\n",
       "      <td>3773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3773</th>\n",
       "      <td>3228</td>\n",
       "      <td>Black</td>\n",
       "      <td>Red Grid</td>\n",
       "      <td>Wood Tech</td>\n",
       "      <td>White Bucket Hat</td>\n",
       "      <td>Red Peacoat</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Feminine</td>\n",
       "      <td>3774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3774</th>\n",
       "      <td>2021</td>\n",
       "      <td>Solid Purple</td>\n",
       "      <td>Blue Grid</td>\n",
       "      <td>Silver Tech</td>\n",
       "      <td>Black Hoodie</td>\n",
       "      <td>Black Hoodie</td>\n",
       "      <td>Silver Chain</td>\n",
       "      <td>Silver Necklace</td>\n",
       "      <td>Masculine</td>\n",
       "      <td>3775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3775</th>\n",
       "      <td>3714</td>\n",
       "      <td>Solid Green</td>\n",
       "      <td>Glitched</td>\n",
       "      <td>White &amp; Black</td>\n",
       "      <td>Sand Camo Beanie</td>\n",
       "      <td>Red &amp; Gold Coat</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Masculine</td>\n",
       "      <td>3776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3776</th>\n",
       "      <td>2209</td>\n",
       "      <td>Blue</td>\n",
       "      <td>Cosmos 1</td>\n",
       "      <td>Wood</td>\n",
       "      <td>Camo Beanie</td>\n",
       "      <td>Blue Leather Jacket</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Feminine</td>\n",
       "      <td>3777</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3777 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Image_Number                      Eyes           Background  \\\n",
       "0             2838               Binary Pink             Cosmos 2   \n",
       "1             3063               Solid White                Brown   \n",
       "2             2104  Electronic Blue & Yellow               Yellow   \n",
       "3             1779              Blue & Black  Deep Fried Abstract   \n",
       "4              448           Electronic Blue                 Gray   \n",
       "...            ...                       ...                  ...   \n",
       "3772          1939  Electronic Blue & Yellow           Green Grid   \n",
       "3773          3228                     Black             Red Grid   \n",
       "3774          2021              Solid Purple            Blue Grid   \n",
       "3775          3714               Solid Green             Glitched   \n",
       "3776          2209                      Blue             Cosmos 1   \n",
       "\n",
       "              Masks          Headgear                       Outfit  \\\n",
       "0              Gold     Yellow Hoodie                Yellow Hoodie   \n",
       "1        Green Tech      White Hoodie                 White Hoodie   \n",
       "2          Red Tech    Red Bucket Hat  Spiked Black Leather Jacket   \n",
       "3            Silver       Pink Hoodie                  Pink Hoodie   \n",
       "4          Red Tech        Tan Fedora                Yellow Jacket   \n",
       "...             ...               ...                          ...   \n",
       "3772          Black      Black Fedora              Light Blue Suit   \n",
       "3773      Wood Tech  White Bucket Hat                  Red Peacoat   \n",
       "3774    Silver Tech      Black Hoodie                 Black Hoodie   \n",
       "3775  White & Black  Sand Camo Beanie              Red & Gold Coat   \n",
       "3776           Wood       Camo Beanie         Blue Leather Jacket    \n",
       "\n",
       "            Accessory_M           Accessory_F     Gender  TOKEN ID  \n",
       "0     Blue Face Bandana     Blue Face Bandana  Masculine         1  \n",
       "1                  None                  None  Masculine         2  \n",
       "2                  None                  None  Masculine         3  \n",
       "3                  None                  None  Masculine         4  \n",
       "4                  None                  None  Feminine          5  \n",
       "...                 ...                   ...        ...       ...  \n",
       "3772   Cowboy Moustache  Silver Hoop Earrings  Feminine       3773  \n",
       "3773               None                  None  Feminine       3774  \n",
       "3774       Silver Chain       Silver Necklace  Masculine      3775  \n",
       "3775               None                  None  Masculine      3776  \n",
       "3776               None                  None  Feminine       3777  \n",
       "\n",
       "[3777 rows x 10 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "full_trait_sheet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "27ef0bcf",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}