last_name_alphabetized.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6aae2882",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| Letter   | Guest Names                                                                                                                                                                                                                                                  |\n",
      "+==========+==============================================================================================================================================================================================================================================================+\n",
      "| A        | Isabella Adams, Mohammed Adams, Sofia Adams, Ananya Adams, Amelia Adams, Nathan Adams, Hiroshi Adams, Emily Adams, Amelia Adams, Mohammed Adams, Yusuke Adams, Arjun Adams                                                                                   |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| B        | Nathan Brown, Samantha Brown, Aarav Brown, Ella Brown, John Brown, Emily Brown, Yuki Brown, Mohammed Brown, Maria Brown, Alexandre Brown                                                                                                                     |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| C        | Emily Clark, Mohammed Clark, Yusuke Clark, Alexandre Clark, Mohammed Clark, Ananya Clark, Luis Clark, Emily Clark, Ananya Clark, Isabella Clark, Arjun Clark, Liam Clark, Emily Clark                                                                        |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| D        | Liam Davis, Arjun Davis, Samantha Davis, Ananya Davis, Yusuke Davis, Mohammed Davis, Arjun Davis, Natasha Davis, Ananya Davis, Nathan Davis, Isabella Davis, Yuki Davis, Mohammed Davis, Liam Davis, Alexandre Davis                                         |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| E        | Mohammed Evans, Arjun Evans, Aarav Evans, Alexandre Evans, Sofia Evans, Liam Evans, Yusuke Evans, Maria Evans, Ella Evans, Ella Evans, Arjun Evans, Yusuke Evans, Yuki Evans, Hiroshi Evans                                                                  |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| F        | Yusuke Frank, Alexandre Frank, Aarav Frank, Amelia Frank                                                                                                                                                                                                     |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| G        | Amelia Gomez, Nathan Gomez, Emily Gomez, Sofia Gomez, Alexandre Gomez, Sofia Gomez, Alexandre Gomez, Yusuke Gomez, Alexandre Gomez, Natasha Gomez, John Gomez, Alexandre Gomez, Luis Gomez                                                                   |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| H        | Nathan Hall, Ella Hall, Mohammed Hall, Yusuke Hall, Ella Hall, Amelia Hall, Amelia Hall, Liam Hall, John Hall, Ananya Hall, Isabella Hall, Mohammed Hall, Luis Hall                                                                                          |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| I        | Ananya Irwin, Ella Irwin, Samantha Irwin, Mohammed Irwin, Yuki Irwin, Yusuke Irwin, Liam Irwin, Natasha Irwin, Luis Irwin                                                                                                                                    |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| J        | Alexandre Johnson, Luis Johnson, Amelia Johnson, Hiroshi Johnson, Nathan Johnson, John Johnson, Nathan Johnson, Sofia Johnson, Sofia Johnson, Isabella Johnson                                                                                               |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| K        | Hiroshi Klein, Aarav Klein, John Klein, Hiroshi Klein, John Klein, Alexandre Klein, Natasha Klein, Liam Klein, Natasha Klein, Yusuke Klein, Mohammed Klein                                                                                                   |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| L        | Natasha Lee, Alexandre Lee, Yuki Lee, Ananya Lee, John Lee, Mohammed Lee                                                                                                                                                                                     |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| M        | John Miller, Isabella Miller, Mohammed Miller, Maria Miller, Natasha Miller, Nathan Miller, Luis Miller, Isabella Miller, Samantha Miller, Sofia Miller, Sofia Miller, Yusuke Miller, Luis Miller, Samantha Miller, Maria Miller, Yusuke Miller, John Miller |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| N        | Amelia Nguyen, Natasha Nguyen, Arjun Nguyen, Amelia Nguyen, Ananya Nguyen, Sofia Nguyen, Luis Nguyen, Alexandre Nguyen, Ella Nguyen, Luis Nguyen, John Nguyen, Yusuke Nguyen, Isabella Nguyen                                                                |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| O        | Maria O'Connor, Natasha O'Connor, Maria O'Connor, Samantha O'Connor, Isabella O'Connor, Yusuke O'Connor, Natasha O'Connor, Luis O'Connor, Mohammed O'Connor, Arjun O'Connor                                                                                  |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| P        | John Patel, Alexandre Patel, Liam Patel, Natasha Patel, Sofia Patel, John Patel, Aarav Patel, Maria Patel, Arjun Patel                                                                                                                                       |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| Q        | Aarav Quinn, Sofia Quinn, Mohammed Quinn, Samantha Quinn, Liam Quinn, Emily Quinn, John Quinn, John Quinn, Nathan Quinn, Ella Quinn, Liam Quinn, Hiroshi Quinn, Luis Quinn, Nathan Quinn, Ella Quinn                                                         |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| R        | Mohammed Rodriguez, Alexandre Rodriguez, Alexandre Rodriguez, Emily Rodriguez, Hiroshi Rodriguez, John Rodriguez, Emily Rodriguez, Sofia Rodriguez, Natasha Rodriguez, Amelia Rodriguez, Yusuke Rodriguez                                                    |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| S        | Ananya Smith, Emily Smith, Hiroshi Smith, Liam Smith, Arjun Smith, Liam Smith, Luis Smith, Sofia Smith, Aarav Smith, Liam Smith, Natasha Smith, Maria Smith, Luis Smith, John Smith, Maria Smith, Natasha Smith, Emily Smith, Liam Smith, Yusuke Smith       |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| T        | Sofia Taylor, Mohammed Taylor, Natasha Taylor, Yusuke Taylor, Amelia Taylor, Emily Taylor, Ella Taylor, Maria Taylor, Luis Taylor, Isabella Taylor, Luis Taylor, Yusuke Taylor                                                                               |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| U        | Maria Ueda, Yuki Ueda, Mohammed Ueda, Samantha Ueda, Alexandre Ueda, Yuki Ueda                                                                                                                                                                               |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| V        | Liam Vargas, Yusuke Vargas, John Vargas, Emily Vargas, Hiroshi Vargas, Natasha Vargas, Alexandre Vargas, Samantha Vargas, Arjun Vargas, Yusuke Vargas, Sofia Vargas, Aarav Vargas                                                                            |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| W        | Ananya Williams, Alexandre Williams, Mohammed Williams, Maria Williams, Alexandre Williams, Ella Williams, Hiroshi Williams, Luis Williams, Arjun Williams, Emily Williams, Hiroshi Williams, Isabella Williams                                              |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| X        | Mohammed Xiong, Yuki Xiong, Nathan Xiong, Amelia Xiong, Arjun Xiong, Emily Xiong, Luis Xiong, Luis Xiong, Luis Xiong, Samantha Xiong                                                                                                                         |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| Y        | Alexandre Yang, Luis Yang, Ella Yang, Sofia Yang, Hiroshi Yang, Arjun Yang, Mohammed Yang, Emily Yang, Arjun Yang, Samantha Yang, Samantha Yang, Alexandre Yang, Liam Yang                                                                                   |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n",
      "| Z        | Nathan Zhang, Aarav Zhang, Yuki Zhang, Mohammed Zhang, Ananya Zhang, Nathan Zhang, Mohammed Zhang, Mohammed Zhang, Yuki Zhang, Isabella Zhang, Amelia Zhang                                                                                                  |\n",
      "+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from tabulate import tabulate\n",
    "import datetime\n",
    "\n",
    "# Read data from the TXT file\n",
    "df = pd.read_csv('guest_list.txt', delimiter='\\t')\n",
    "\n",
    "# Function to extract the first letter of the last name\n",
    "def extract_last_name_first_letter(name):\n",
    "    last_name = name.split()[-1]\n",
    "    return last_name[0].upper()\n",
    "\n",
    "# Sort the DataFrame by last name\n",
    "df['Last Name'] = df['Guest Name'].apply(lambda x: x.split()[-1])\n",
    "df.sort_values(by='Last Name', inplace=True)\n",
    "\n",
    "# Group the DataFrame by the first letter of the last name\n",
    "groups = df.groupby(df['Last Name'].apply(extract_last_name_first_letter))\n",
    "\n",
    "# Generate the tab layout for each group\n",
    "tab_layout = []\n",
    "for letter, group in groups:\n",
    "    tab_layout.append([letter, ', '.join(group['Guest Name'])])\n",
    "\n",
    "# Print the tab layout\n",
    "print(tabulate(tab_layout, headers=['Letter', 'Guest Names'], tablefmt='grid'))\n",
    "\n",
    "# Save the tab layout to a TXT file with the specified name format\n",
    "\n",
    "# Get the current date in the specified format\n",
    "date_today = datetime.datetime.today().strftime('%b-%d-%y')\n",
    "\n",
    "# Define the filename based on the date\n",
    "filename = f'last_name_alphabetized_{date_today}.txt'\n",
    "\n",
    "# Save the tab layout to the TXT file\n",
    "with open(filename, 'w') as file:\n",
    "    file.write(tabulate(tab_layout, headers=['Letter', 'Guest Names'], tablefmt='grid'))\n"
   ]
  }
 ],
 "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}