Convert_From_Excel.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2c48f1c8",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from openpyxl import load_workbook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "571e7dc4-0ae6-47c9-91e8-ffe6c4cecb08",
   "metadata": {},
   "outputs": [],
   "source": [
    "master_sheet_df = pd.read_excel(r\"C:\\Users\\dpomp\\Downloads\\Quantum Software Market Segmentation (1).xlsx\", sheet_name=\"Master\", header=0) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "980bcf63-761e-4591-9a30-b93c7d2936e0",
   "metadata": {},
   "outputs": [],
   "source": [
    "segmentation_all_df = pd.read_excel(r\"C:\\Users\\dpomp\\Downloads\\Quantum Software Market Segmentation (1).xlsx\", sheet_name=\"Segmentation ALL\", header=0) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "e5e1011d-10d2-40aa-9407-a2f961cc06f4",
   "metadata": {},
   "outputs": [],
   "source": [
    "comp_companies_with_data = pd.merge(master_sheet_df, segmentation_all_df, left_on='Company', right_on='Company', how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "f0fc8871-d824-4f9e-beaa-ded9cfc0c773",
   "metadata": {},
   "outputs": [],
   "source": [
    "comp_companies_with_data.to_excel(r\"C:\\Users\\dpomp\\Downloads\\Quantum Software Market Segmentation Merged.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5b660cec-78a7-4c14-b7d8-1ecb8a803fb3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "\n",
    "# Specify the folder containing the CSV files\n",
    "folder_path = r'C:\\Users\\dpomp\\OneDrive\\Documents\\ZoomInfo-QC-companies'\n",
    "\n",
    "# Get the list of all CSV files in the folder\n",
    "csv_files = [f for f in os.listdir(folder_path) if f.endswith('.csv')]\n",
    "\n",
    "# Read and concatenate all CSV files into a single DataFrame\n",
    "dataframes = []\n",
    "for file in csv_files:\n",
    "    file_path = os.path.join(folder_path, file)\n",
    "    df = pd.read_csv(file_path)\n",
    "    dataframes.append(df)\n",
    "\n",
    "# Concatenate all DataFrames into one\n",
    "combined_df = pd.concat(dataframes, ignore_index=True)\n",
    "\n",
    "# Optional: save the concatenated DataFrame to a new CSV file\n",
    "combined_df.to_excel(r'C:\\Users\\dpomp\\Downloads\\ZoomInfo-QC-All-companies.xlsx', index=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "c767e50e-c9b3-4d36-be6b-ffcc04e068ad",
   "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>#</th>\n",
       "      <th>Company</th>\n",
       "      <th>Industry</th>\n",
       "      <th>By</th>\n",
       "      <th>Quantum Team Size</th>\n",
       "      <th>Quantum Companies Engaged</th>\n",
       "      <th>Secondary Quantum company engaged</th>\n",
       "      <th>Area of Research</th>\n",
       "      <th>Links to papers</th>\n",
       "      <th>Dates of Announcements / Publications</th>\n",
       "      <th>...</th>\n",
       "      <th>QNLP</th>\n",
       "      <th>PDE</th>\n",
       "      <th>QML</th>\n",
       "      <th>CHM</th>\n",
       "      <th>QMCI/Financial Derivitives</th>\n",
       "      <th>Other QC paper</th>\n",
       "      <th>Sum (Priority)</th>\n",
       "      <th>BizDev Team Input (High/Low Priority)</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "      <th>Unnamed: 20</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Currently:</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Green means we have worked with them and have ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Note that the opportunity may not be compute r...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Companies with sum of 3-4 are priority 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Light green means we havent worked with them b...</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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Companies with sum of 2 are priority 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yellow means we have worked with them but dont...</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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Companies with sum of 0/1 are priority 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Blank means we havent worked with them and we ...</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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\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>...</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>927</th>\n",
       "      <td>335.0</td>\n",
       "      <td>General Motors (GM)</td>\n",
       "      <td>Automotive</td>\n",
       "      <td>HD</td>\n",
       "      <td>2+</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Automitive Paint Optimization</td>\n",
       "      <td>https://arxiv.org/ftp/arxiv/papers/2206/2206.1...</td>\n",
       "      <td>2022</td>\n",
       "      <td>...</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>928</th>\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>...</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>929</th>\n",
       "      <td>336.0</td>\n",
       "      <td>Triumf</td>\n",
       "      <td>National Lab</td>\n",
       "      <td>DM</td>\n",
       "      <td>2+</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\"Quantum automatic differentiation\"</td>\n",
       "      <td>https://arxiv.org/pdf/2207.06526.pdf</td>\n",
       "      <td>2021</td>\n",
       "      <td>...</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>930</th>\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>Theoretical qubit model for U(1) lattice gauge...</td>\n",
       "      <td>https://arxiv.org/pdf/1905.09789.pdf</td>\n",
       "      <td>2019</td>\n",
       "      <td>...</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>931 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         #                                            Company      Industry  \\\n",
       "0      NaN                                                NaN           NaN   \n",
       "1      NaN  Green means we have worked with them and have ...           NaN   \n",
       "2      NaN  Light green means we havent worked with them b...           NaN   \n",
       "3      NaN  Yellow means we have worked with them but dont...           NaN   \n",
       "4      NaN  Blank means we havent worked with them and we ...           NaN   \n",
       "..     ...                                                ...           ...   \n",
       "926    NaN                                                NaN           NaN   \n",
       "927  335.0                                General Motors (GM)    Automotive   \n",
       "928    NaN                                                NaN           NaN   \n",
       "929  336.0                                             Triumf  National Lab   \n",
       "930    NaN                                                NaN           NaN   \n",
       "\n",
       "      By Quantum Team Size Quantum Companies Engaged  \\\n",
       "0    NaN               NaN                       NaN   \n",
       "1    NaN               NaN                       NaN   \n",
       "2    NaN               NaN                       NaN   \n",
       "3    NaN               NaN                       NaN   \n",
       "4    NaN               NaN                       NaN   \n",
       "..   ...               ...                       ...   \n",
       "926  NaN               NaN                       NaN   \n",
       "927   HD                2+                       NaN   \n",
       "928  NaN               NaN                       NaN   \n",
       "929   DM                2+                       NaN   \n",
       "930  NaN               NaN                       NaN   \n",
       "\n",
       "    Secondary Quantum company engaged  \\\n",
       "0                                 NaN   \n",
       "1                                 NaN   \n",
       "2                                 NaN   \n",
       "3                                 NaN   \n",
       "4                                 NaN   \n",
       "..                                ...   \n",
       "926                               NaN   \n",
       "927                               NaN   \n",
       "928                               NaN   \n",
       "929                               NaN   \n",
       "930                               NaN   \n",
       "\n",
       "                                      Area of Research  \\\n",
       "0                                                  NaN   \n",
       "1    Note that the opportunity may not be compute r...   \n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "..                                                 ...   \n",
       "926                                                NaN   \n",
       "927                      Automitive Paint Optimization   \n",
       "928                                                NaN   \n",
       "929                \"Quantum automatic differentiation\"   \n",
       "930  Theoretical qubit model for U(1) lattice gauge...   \n",
       "\n",
       "                                       Links to papers  \\\n",
       "0                                                  NaN   \n",
       "1                                                  NaN   \n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "..                                                 ...   \n",
       "926                                                NaN   \n",
       "927  https://arxiv.org/ftp/arxiv/papers/2206/2206.1...   \n",
       "928                                                NaN   \n",
       "929               https://arxiv.org/pdf/2207.06526.pdf   \n",
       "930               https://arxiv.org/pdf/1905.09789.pdf   \n",
       "\n",
       "    Dates of Announcements / Publications  ... QNLP  PDE  QML  CHM  \\\n",
       "0                                     NaN  ...  0.0  0.0  0.0  1.0   \n",
       "1                                     NaN  ...  0.0  0.0  0.0  0.0   \n",
       "2                                     NaN  ...  0.0  0.0  0.0  1.0   \n",
       "3                                     NaN  ...  0.0  0.0  1.0  0.0   \n",
       "4                                     NaN  ...  0.0  1.0  1.0  0.0   \n",
       "..                                    ...  ...  ...  ...  ...  ...   \n",
       "926                                   NaN  ...  NaN  NaN  NaN  NaN   \n",
       "927                                  2022  ...  NaN  NaN  NaN  NaN   \n",
       "928                                   NaN  ...  NaN  NaN  NaN  NaN   \n",
       "929                                  2021  ...  NaN  NaN  NaN  NaN   \n",
       "930                                  2019  ...  NaN  NaN  NaN  NaN   \n",
       "\n",
       "    QMCI/Financial Derivitives Other QC paper Sum (Priority)  \\\n",
       "0                          0.0            1.0            4.0   \n",
       "1                          0.0            1.0            4.0   \n",
       "2                          0.0            0.0            4.0   \n",
       "3                          1.0            1.0            4.0   \n",
       "4                          0.0            1.0            4.0   \n",
       "..                         ...            ...            ...   \n",
       "926                        NaN            NaN            NaN   \n",
       "927                        NaN            NaN            NaN   \n",
       "928                        NaN            NaN            NaN   \n",
       "929                        NaN            NaN            NaN   \n",
       "930                        NaN            NaN            NaN   \n",
       "\n",
       "     BizDev Team Input (High/Low Priority) Unnamed: 19  \\\n",
       "0                                      NaN         NaN   \n",
       "1                                      NaN         NaN   \n",
       "2                                      NaN         NaN   \n",
       "3                                      NaN         NaN   \n",
       "4                                      NaN         NaN   \n",
       "..                                     ...         ...   \n",
       "926                                    NaN         NaN   \n",
       "927                                    NaN         NaN   \n",
       "928                                    NaN         NaN   \n",
       "929                                    NaN         NaN   \n",
       "930                                    NaN         NaN   \n",
       "\n",
       "                                  Unnamed: 20  \n",
       "0                                  Currently:  \n",
       "1    Companies with sum of 3-4 are priority 1  \n",
       "2      Companies with sum of 2 are priority 2  \n",
       "3    Companies with sum of 0/1 are priority 3  \n",
       "4                                         NaN  \n",
       "..                                        ...  \n",
       "926                                       NaN  \n",
       "927                                       NaN  \n",
       "928                                       NaN  \n",
       "929                                       NaN  \n",
       "930                                       NaN  \n",
       "\n",
       "[931 rows x 42 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comp_companies_with_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "01caddd2-9c23-4685-8532-5c845bda552f",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}