Chapter 59
Building A RAG System with Gemma, MongoDB and Open Source Models
NotebookPython 324 cells
Building A RAG System with Gemma, MongoDB and Open Source Models
Authored By: Richmond Alake
Step 1: Installing Libraries
The shell command sequence below installs libraries for leveraging open-source large language models (LLMs), embedding models, and database interaction functionalities. These libraries simplify the development of a RAG system, reducing the complexity to a small amount of code:
- PyMongo: A Python library for interacting with MongoDB that enables functionalities to connect to a cluster and query data stored in collections and documents.
- Pandas: Provides a data structure for efficient data processing and analysis using Python
- Hugging Face datasets: Holds audio, vision, and text datasets
- Hugging Face Accelerate: Abstracts the complexity of writing code that leverages hardware accelerators such as GPUs. Accelerate is leveraged in the implementation to utilise the Gemma model on GPU resources.
- Hugging Face Transformers: Access to a vast collection of pre-trained models
- Hugging Face Sentence Transformers: Provides access to sentence, text, and image embeddings.
In [ ]python · cell 3
python
!pip install datasets pandas pymongo sentence_transformers
!pip install -U transformers
# Install below if using GPU
!pip install accelerateStep 2: Data sourcing and preparation
The data utilised in this tutorial is sourced from Hugging Face datasets, specifically the AIatMongoDB/embedded_movies dataset.
In [2]python · cell 5
python
# Load Dataset
from datasets import load_dataset
import pandas as pd
# https://huggingface.co/datasets/AIatMongoDB/embedded_movies
dataset = load_dataset("AIatMongoDB/embedded_movies")
# Convert the dataset to a pandas dataframe
dataset_df = pd.DataFrame(dataset["train"])
dataset_df.head(5)Output
num_mflix_comments genres countries \
0 0 [Action] [USA]
1 0 [Comedy, Short, Action] [USA]
2 0 [Action, Adventure, Drama] [USA]
3 1 [Adventure, Action] [USA]
4 0 [Action, Comedy, Romance] [USA]
directors \
0 [Louis J. Gasnier, Donald MacKenzie]
1 [Alfred J. Goulding, Hal Roach]
2 [Herbert Brenon]
3 [Albert Parker]
4 [Sam Taylor]
fullplot \
0 Young Pauline is left a lot of money when her ...
1 As a penniless man worries about how he will m...
2 Michael "Beau" Geste leaves England in disgrac...
3 A nobleman vows to avenge the death of his fat...
4 The Uptown Boy, J. Harold Manners (Lloyd) is a...
writers \
0 [Charles W. Goddard (screenplay), Basil Dickey...
1 [H.M. Walker (titles)]
2 [Herbert Brenon (adaptation), John Russell (ad...
3 [Douglas Fairbanks (story), Jack Cunningham (a...
4 [Ted Wilde (story), John Grey (story), Clyde B...
awards runtime type rated \
0 {'nominations': 0, 'text': '1 win.', 'wins': 1} 199.0 movie None
1 {'nominations': 1, 'text': '1 nomination.', 'w... 22.0 movie TV-G
2 {'nominations': 0, 'text': '1 win.', 'wins': 1} 101.0 movie None
3 {'nominations': 0, 'text': '1 win.', 'wins': 1} 88.0 movie None
4 {'nominations': 1, 'text': '1 nomination.', 'w... 58.0 movie PASSED
metacritic poster languages \
0 NaN https://m.media-amazon.com/images/M/MV5BMzgxOD... [English]
1 NaN https://m.media-amazon.com/images/M/MV5BNzE1OW... [English]
2 NaN None [English]
3 NaN https://m.media-amazon.com/images/M/MV5BMzU0ND... None
4 NaN https://m.media-amazon.com/images/M/MV5BMTcxMT... [English]
imdb \
0 {'id': 4465, 'rating': 7.6, 'votes': 744}
1 {'id': 10146, 'rating': 7.0, 'votes': 639}
2 {'id': 16634, 'rating': 6.9, 'votes': 222}
3 {'id': 16654, 'rating': 7.2, 'votes': 1146}
4 {'id': 16895, 'rating': 7.6, 'votes': 918}
plot \
0 Young Pauline is left a lot of money when her ...
1 A penniless young man tries to save an heiress...
2 Michael "Beau" Geste leaves England in disgrac...
3 Seeking revenge, an athletic young man joins t...
4 An irresponsible young millionaire changes his...
cast \
0 [Pearl White, Crane Wilbur, Paul Panzer, Edwar...
1 [Harold Lloyd, Mildred Davis, 'Snub' Pollard, ...
2 [Ronald Colman, Neil Hamilton, Ralph Forbes, A...
3 [Billie Dove, Tempe Pigott, Donald Crisp, Sam ...
4 [Harold Lloyd, Jobyna Ralston, Noah Young, Jim...
plot_embedding title
0 [0.00072939653, -0.026834568, 0.013515796, -0.... The Perils of Pauline
1 [-0.022837115, -0.022941574, 0.014937485, -0.0... From Hand to Mouth
2 [0.00023330493, -0.028511643, 0.014653289, -0.... Beau Geste
3 [-0.005927917, -0.033394486, 0.0015323418, -0.... The Black Pirate
4 [-0.0059373598, -0.026604708, -0.0070914757, -... For Heaven's Sake
.dataframe tbody tr th:only-of-type {
vertical-align: middle;
}
.dataframe tbody tr th {
vertical-align: top;
}
.dataframe thead th {
text-align: right;
}
| num_mflix_comments | genres | countries | directors | fullplot | writers | awards | runtime | type | rated | metacritic | poster | languages | imdb | plot | cast | plot_embedding | title | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | [Action] | [USA] | [Louis J. Gasnier, Donald MacKenzie] | Young Pauline is left a lot of money when her ... | [Charles W. Goddard (screenplay), Basil Dickey... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 199.0 | movie | None | NaN | https://m.media-amazon.com/images/M/MV5BMzgxOD... | [English] | {'id': 4465, 'rating': 7.6, 'votes': 744} | Young Pauline is left a lot of money when her ... | [Pearl White, Crane Wilbur, Paul Panzer, Edwar... | [0.00072939653, -0.026834568, 0.013515796, -0.... | The Perils of Pauline |
| 1 | 0 | [Comedy, Short, Action] | [USA] | [Alfred J. Goulding, Hal Roach] | As a penniless man worries about how he will m... | [H.M. Walker (titles)] | {'nominations': 1, 'text': '1 nomination.', 'w... | 22.0 | movie | TV-G | NaN | https://m.media-amazon.com/images/M/MV5BNzE1OW... | [English] | {'id': 10146, 'rating': 7.0, 'votes': 639} | A penniless young man tries to save an heiress... | [Harold Lloyd, Mildred Davis, 'Snub' Pollard, ... | [-0.022837115, -0.022941574, 0.014937485, -0.0... | From Hand to Mouth |
| 2 | 0 | [Action, Adventure, Drama] | [USA] | [Herbert Brenon] | Michael "Beau" Geste leaves England in disgrac... | [Herbert Brenon (adaptation), John Russell (ad... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 101.0 | movie | None | NaN | None | [English] | {'id': 16634, 'rating': 6.9, 'votes': 222} | Michael "Beau" Geste leaves England in disgrac... | [Ronald Colman, Neil Hamilton, Ralph Forbes, A... | [0.00023330493, -0.028511643, 0.014653289, -0.... | Beau Geste |
| 3 | 1 | [Adventure, Action] | [USA] | [Albert Parker] | A nobleman vows to avenge the death of his fat... | [Douglas Fairbanks (story), Jack Cunningham (a... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 88.0 | movie | None | NaN | https://m.media-amazon.com/images/M/MV5BMzU0ND... | None | {'id': 16654, 'rating': 7.2, 'votes': 1146} | Seeking revenge, an athletic young man joins t... | [Billie Dove, Tempe Pigott, Donald Crisp, Sam ... | [-0.005927917, -0.033394486, 0.0015323418, -0.... | The Black Pirate |
| 4 | 0 | [Action, Comedy, Romance] | [USA] | [Sam Taylor] | The Uptown Boy, J. Harold Manners (Lloyd) is a... | [Ted Wilde (story), John Grey (story), Clyde B... | {'nominations': 1, 'text': '1 nomination.', 'w... | 58.0 | movie | PASSED | NaN | https://m.media-amazon.com/images/M/MV5BMTcxMT... | [English] | {'id': 16895, 'rating': 7.6, 'votes': 918} | An irresponsible young millionaire changes his... | [Harold Lloyd, Jobyna Ralston, Noah Young, Jim... | [-0.0059373598, -0.026604708, -0.0070914757, -... | For Heaven's Sake |
.colab-df-container {
display:flex;
gap: 12px;
}
.colab-df-convert {
background-color: #E8F0FE;
border: none;
border-radius: 50%;
cursor: pointer;
display: none;
fill: #1967D2;
height: 32px;
padding: 0 0 0 0;
width: 32px;
}
.colab-df-convert:hover {
background-color: #E2EBFA;
box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);
fill: #174EA6;
}
.colab-df-buttons div {
margin-bottom: 4px;
}
[theme=dark] .colab-df-convert {
background-color: #3B4455;
fill: #D2E3FC;
}
[theme=dark] .colab-df-convert:hover {
background-color: #434B5C;
box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);
filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));
fill: #FFFFFF;
}
.colab-df-quickchart {
--bg-color: #E8F0FE;
--fill-color: #1967D2;
--hover-bg-color: #E2EBFA;
--hover-fill-color: #174EA6;
--disabled-fill-color: #AAA;
--disabled-bg-color: #DDD;
}
[theme=dark] .colab-df-quickchart {
--bg-color: #3B4455;
--fill-color: #D2E3FC;
--hover-bg-color: #434B5C;
--hover-fill-color: #FFFFFF;
--disabled-bg-color: #3B4455;
--disabled-fill-color: #666;
}
.colab-df-quickchart {
background-color: var(--bg-color);
border: none;
border-radius: 50%;
cursor: pointer;
display: none;
fill: var(--fill-color);
height: 32px;
padding: 0;
width: 32px;
}
.colab-df-quickchart:hover {
background-color: var(--hover-bg-color);
box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);
fill: var(--button-hover-fill-color);
}
.colab-df-quickchart-complete:disabled,
.colab-df-quickchart-complete:disabled:hover {
background-color: var(--disabled-bg-color);
fill: var(--disabled-fill-color);
box-shadow: none;
}
.colab-df-spinner {
border: 2px solid var(--fill-color);
border-color: transparent;
border-bottom-color: var(--fill-color);
animation:
spin 1s steps(1) infinite;
}
@keyframes spin {
0% {
border-color: transparent;
border-bottom-color: var(--fill-color);
border-left-color: var(--fill-color);
}
20% {
border-color: transparent;
border-left-color: var(--fill-color);
border-top-color: var(--fill-color);
}
30% {
border-color: transparent;
border-left-color: var(--fill-color);
border-top-color: var(--fill-color);
border-right-color: var(--fill-color);
}
40% {
border-color: transparent;
border-right-color: var(--fill-color);
border-top-color: var(--fill-color);
}
60% {
border-color: transparent;
border-right-color: var(--fill-color);
}
80% {
border-color: transparent;
border-right-color: var(--fill-color);
border-bottom-color: var(--fill-color);
}
90% {
border-color: transparent;
border-bottom-color: var(--fill-color);
}
}
The operations within the following code snippet below focus on enforcing data integrity and quality.
- The first process ensures that each data point's
fullplotattribute is not empty, as this is the primary data we utilise in the embedding process. - This step also ensures we remove the
plot_embeddingattribute from all data points as this will be replaced by new embeddings created with a different embedding model, thegte-large.
In [3]python · cell 7
python
# Data Preparation
# Remove data point where plot coloumn is missing
dataset_df = dataset_df.dropna(subset=["fullplot"])
print("\nNumber of missing values in each column after removal:")
print(dataset_df.isnull().sum())
# Remove the plot_embedding from each data point in the dataset as we are going to create new embeddings with an open source embedding model from Hugging Face
dataset_df = dataset_df.drop(columns=["plot_embedding"])
dataset_df.head(5)Output
Number of missing values in each column after removal: num_mflix_comments 0 genres 0 countries 0 directors 12 fullplot 0 writers 13 awards 0 runtime 14 type 0 rated 279 metacritic 893 poster 78 languages 1 imdb 0 plot 0 cast 1 plot_embedding 1 title 0 dtype: int64
num_mflix_comments genres countries \
0 0 [Action] [USA]
1 0 [Comedy, Short, Action] [USA]
2 0 [Action, Adventure, Drama] [USA]
3 1 [Adventure, Action] [USA]
4 0 [Action, Comedy, Romance] [USA]
directors \
0 [Louis J. Gasnier, Donald MacKenzie]
1 [Alfred J. Goulding, Hal Roach]
2 [Herbert Brenon]
3 [Albert Parker]
4 [Sam Taylor]
fullplot \
0 Young Pauline is left a lot of money when her ...
1 As a penniless man worries about how he will m...
2 Michael "Beau" Geste leaves England in disgrac...
3 A nobleman vows to avenge the death of his fat...
4 The Uptown Boy, J. Harold Manners (Lloyd) is a...
writers \
0 [Charles W. Goddard (screenplay), Basil Dickey...
1 [H.M. Walker (titles)]
2 [Herbert Brenon (adaptation), John Russell (ad...
3 [Douglas Fairbanks (story), Jack Cunningham (a...
4 [Ted Wilde (story), John Grey (story), Clyde B...
awards runtime type rated \
0 {'nominations': 0, 'text': '1 win.', 'wins': 1} 199.0 movie None
1 {'nominations': 1, 'text': '1 nomination.', 'w... 22.0 movie TV-G
2 {'nominations': 0, 'text': '1 win.', 'wins': 1} 101.0 movie None
3 {'nominations': 0, 'text': '1 win.', 'wins': 1} 88.0 movie None
4 {'nominations': 1, 'text': '1 nomination.', 'w... 58.0 movie PASSED
metacritic poster languages \
0 NaN https://m.media-amazon.com/images/M/MV5BMzgxOD... [English]
1 NaN https://m.media-amazon.com/images/M/MV5BNzE1OW... [English]
2 NaN None [English]
3 NaN https://m.media-amazon.com/images/M/MV5BMzU0ND... None
4 NaN https://m.media-amazon.com/images/M/MV5BMTcxMT... [English]
imdb \
0 {'id': 4465, 'rating': 7.6, 'votes': 744}
1 {'id': 10146, 'rating': 7.0, 'votes': 639}
2 {'id': 16634, 'rating': 6.9, 'votes': 222}
3 {'id': 16654, 'rating': 7.2, 'votes': 1146}
4 {'id': 16895, 'rating': 7.6, 'votes': 918}
plot \
0 Young Pauline is left a lot of money when her ...
1 A penniless young man tries to save an heiress...
2 Michael "Beau" Geste leaves England in disgrac...
3 Seeking revenge, an athletic young man joins t...
4 An irresponsible young millionaire changes his...
cast title
0 [Pearl White, Crane Wilbur, Paul Panzer, Edwar... The Perils of Pauline
1 [Harold Lloyd, Mildred Davis, 'Snub' Pollard, ... From Hand to Mouth
2 [Ronald Colman, Neil Hamilton, Ralph Forbes, A... Beau Geste
3 [Billie Dove, Tempe Pigott, Donald Crisp, Sam ... The Black Pirate
4 [Harold Lloyd, Jobyna Ralston, Noah Young, Jim... For Heaven's Sake
.dataframe tbody tr th:only-of-type {
vertical-align: middle;
}
.dataframe tbody tr th {
vertical-align: top;
}
.dataframe thead th {
text-align: right;
}
| num_mflix_comments | genres | countries | directors | fullplot | writers | awards | runtime | type | rated | metacritic | poster | languages | imdb | plot | cast | title | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | [Action] | [USA] | [Louis J. Gasnier, Donald MacKenzie] | Young Pauline is left a lot of money when her ... | [Charles W. Goddard (screenplay), Basil Dickey... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 199.0 | movie | None | NaN | https://m.media-amazon.com/images/M/MV5BMzgxOD... | [English] | {'id': 4465, 'rating': 7.6, 'votes': 744} | Young Pauline is left a lot of money when her ... | [Pearl White, Crane Wilbur, Paul Panzer, Edwar... | The Perils of Pauline |
| 1 | 0 | [Comedy, Short, Action] | [USA] | [Alfred J. Goulding, Hal Roach] | As a penniless man worries about how he will m... | [H.M. Walker (titles)] | {'nominations': 1, 'text': '1 nomination.', 'w... | 22.0 | movie | TV-G | NaN | https://m.media-amazon.com/images/M/MV5BNzE1OW... | [English] | {'id': 10146, 'rating': 7.0, 'votes': 639} | A penniless young man tries to save an heiress... | [Harold Lloyd, Mildred Davis, 'Snub' Pollard, ... | From Hand to Mouth |
| 2 | 0 | [Action, Adventure, Drama] | [USA] | [Herbert Brenon] | Michael "Beau" Geste leaves England in disgrac... | [Herbert Brenon (adaptation), John Russell (ad... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 101.0 | movie | None | NaN | None | [English] | {'id': 16634, 'rating': 6.9, 'votes': 222} | Michael "Beau" Geste leaves England in disgrac... | [Ronald Colman, Neil Hamilton, Ralph Forbes, A... | Beau Geste |
| 3 | 1 | [Adventure, Action] | [USA] | [Albert Parker] | A nobleman vows to avenge the death of his fat... | [Douglas Fairbanks (story), Jack Cunningham (a... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 88.0 | movie | None | NaN | https://m.media-amazon.com/images/M/MV5BMzU0ND... | None | {'id': 16654, 'rating': 7.2, 'votes': 1146} | Seeking revenge, an athletic young man joins t... | [Billie Dove, Tempe Pigott, Donald Crisp, Sam ... | The Black Pirate |
| 4 | 0 | [Action, Comedy, Romance] | [USA] | [Sam Taylor] | The Uptown Boy, J. Harold Manners (Lloyd) is a... | [Ted Wilde (story), John Grey (story), Clyde B... | {'nominations': 1, 'text': '1 nomination.', 'w... | 58.0 | movie | PASSED | NaN | https://m.media-amazon.com/images/M/MV5BMTcxMT... | [English] | {'id': 16895, 'rating': 7.6, 'votes': 918} | An irresponsible young millionaire changes his... | [Harold Lloyd, Jobyna Ralston, Noah Young, Jim... | For Heaven's Sake |
.colab-df-container {
display:flex;
gap: 12px;
}
.colab-df-convert {
background-color: #E8F0FE;
border: none;
border-radius: 50%;
cursor: pointer;
display: none;
fill: #1967D2;
height: 32px;
padding: 0 0 0 0;
width: 32px;
}
.colab-df-convert:hover {
background-color: #E2EBFA;
box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);
fill: #174EA6;
}
.colab-df-buttons div {
margin-bottom: 4px;
}
[theme=dark] .colab-df-convert {
background-color: #3B4455;
fill: #D2E3FC;
}
[theme=dark] .colab-df-convert:hover {
background-color: #434B5C;
box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);
filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));
fill: #FFFFFF;
}
.colab-df-quickchart {
--bg-color: #E8F0FE;
--fill-color: #1967D2;
--hover-bg-color: #E2EBFA;
--hover-fill-color: #174EA6;
--disabled-fill-color: #AAA;
--disabled-bg-color: #DDD;
}
[theme=dark] .colab-df-quickchart {
--bg-color: #3B4455;
--fill-color: #D2E3FC;
--hover-bg-color: #434B5C;
--hover-fill-color: #FFFFFF;
--disabled-bg-color: #3B4455;
--disabled-fill-color: #666;
}
.colab-df-quickchart {
background-color: var(--bg-color);
border: none;
border-radius: 50%;
cursor: pointer;
display: none;
fill: var(--fill-color);
height: 32px;
padding: 0;
width: 32px;
}
.colab-df-quickchart:hover {
background-color: var(--hover-bg-color);
box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);
fill: var(--button-hover-fill-color);
}
.colab-df-quickchart-complete:disabled,
.colab-df-quickchart-complete:disabled:hover {
background-color: var(--disabled-bg-color);
fill: var(--disabled-fill-color);
box-shadow: none;
}
.colab-df-spinner {
border: 2px solid var(--fill-color);
border-color: transparent;
border-bottom-color: var(--fill-color);
animation:
spin 1s steps(1) infinite;
}
@keyframes spin {
0% {
border-color: transparent;
border-bottom-color: var(--fill-color);
border-left-color: var(--fill-color);
}
20% {
border-color: transparent;
border-left-color: var(--fill-color);
border-top-color: var(--fill-color);
}
30% {
border-color: transparent;
border-left-color: var(--fill-color);
border-top-color: var(--fill-color);
border-right-color: var(--fill-color);
}
40% {
border-color: transparent;
border-right-color: var(--fill-color);
border-top-color: var(--fill-color);
}
60% {
border-color: transparent;
border-right-color: var(--fill-color);
}
80% {
border-color: transparent;
border-right-color: var(--fill-color);
border-bottom-color: var(--fill-color);
}
90% {
border-color: transparent;
border-bottom-color: var(--fill-color);
}
}
Step 3: Generating embeddings
The steps in the code snippets are as follows:
- Import the
Sentence[Transformer](/glossary/transformer)class to access the embedding models. - Load the embedding model using the
Sentence[Transformer](/glossary/transformer)constructor to instantiate thegte-largeembedding model. - Define the
get_embeddingfunction, which takes a text string as input and returns a list of floats representing the embedding. The function first checks if the input text is not empty (after stripping whitespace). If the text is empty, it returns an empty list. Otherwise, it generates an embedding using the loaded model. - Generate embeddings by applying the
get_embeddingfunction to the "fullplot" column of thedataset_dfDataFrame, generating embeddings for each movie's plot. The resulting list of embeddings is assigned to a new column named embedding.
Note: It's not necessary to chunk the text in the full plot, as we can ensure that the text length remains within a manageable range.
In [4]python · cell 9
python
from sentence_transformers import SentenceTransformer
# https://huggingface.co/thenlper/gte-large
embedding_model = SentenceTransformer("thenlper/gte-large")
def get_embedding(text: str) -> list[float]:
if not text.strip():
print("Attempted to get embedding for empty text.")
return []
embedding = embedding_model.encode(text)
return embedding.tolist()
dataset_df["embedding"] = dataset_df["fullplot"].apply(get_embedding)
dataset_df.head()Output
num_mflix_comments genres countries \
0 0 [Action] [USA]
1 0 [Comedy, Short, Action] [USA]
2 0 [Action, Adventure, Drama] [USA]
3 1 [Adventure, Action] [USA]
4 0 [Action, Comedy, Romance] [USA]
directors \
0 [Louis J. Gasnier, Donald MacKenzie]
1 [Alfred J. Goulding, Hal Roach]
2 [Herbert Brenon]
3 [Albert Parker]
4 [Sam Taylor]
fullplot \
0 Young Pauline is left a lot of money when her ...
1 As a penniless man worries about how he will m...
2 Michael "Beau" Geste leaves England in disgrac...
3 A nobleman vows to avenge the death of his fat...
4 The Uptown Boy, J. Harold Manners (Lloyd) is a...
writers \
0 [Charles W. Goddard (screenplay), Basil Dickey...
1 [H.M. Walker (titles)]
2 [Herbert Brenon (adaptation), John Russell (ad...
3 [Douglas Fairbanks (story), Jack Cunningham (a...
4 [Ted Wilde (story), John Grey (story), Clyde B...
awards runtime type rated \
0 {'nominations': 0, 'text': '1 win.', 'wins': 1} 199.0 movie None
1 {'nominations': 1, 'text': '1 nomination.', 'w... 22.0 movie TV-G
2 {'nominations': 0, 'text': '1 win.', 'wins': 1} 101.0 movie None
3 {'nominations': 0, 'text': '1 win.', 'wins': 1} 88.0 movie None
4 {'nominations': 1, 'text': '1 nomination.', 'w... 58.0 movie PASSED
metacritic poster languages \
0 NaN https://m.media-amazon.com/images/M/MV5BMzgxOD... [English]
1 NaN https://m.media-amazon.com/images/M/MV5BNzE1OW... [English]
2 NaN None [English]
3 NaN https://m.media-amazon.com/images/M/MV5BMzU0ND... None
4 NaN https://m.media-amazon.com/images/M/MV5BMTcxMT... [English]
imdb \
0 {'id': 4465, 'rating': 7.6, 'votes': 744}
1 {'id': 10146, 'rating': 7.0, 'votes': 639}
2 {'id': 16634, 'rating': 6.9, 'votes': 222}
3 {'id': 16654, 'rating': 7.2, 'votes': 1146}
4 {'id': 16895, 'rating': 7.6, 'votes': 918}
plot \
0 Young Pauline is left a lot of money when her ...
1 A penniless young man tries to save an heiress...
2 Michael "Beau" Geste leaves England in disgrac...
3 Seeking revenge, an athletic young man joins t...
4 An irresponsible young millionaire changes his...
cast title \
0 [Pearl White, Crane Wilbur, Paul Panzer, Edwar... The Perils of Pauline
1 [Harold Lloyd, Mildred Davis, 'Snub' Pollard, ... From Hand to Mouth
2 [Ronald Colman, Neil Hamilton, Ralph Forbes, A... Beau Geste
3 [Billie Dove, Tempe Pigott, Donald Crisp, Sam ... The Black Pirate
4 [Harold Lloyd, Jobyna Ralston, Noah Young, Jim... For Heaven's Sake
embedding
0 [-0.009285838343203068, -0.005062104668468237,...
1 [-0.0024393785279244184, 0.02309592440724373, ...
2 [0.012204292230308056, -0.01145575474947691, -...
3 [0.004541348200291395, -0.0006100579630583525,...
4 [-0.0022256041411310434, 0.011567804962396622,...
.dataframe tbody tr th:only-of-type {
vertical-align: middle;
}
.dataframe tbody tr th {
vertical-align: top;
}
.dataframe thead th {
text-align: right;
}
| num_mflix_comments | genres | countries | directors | fullplot | writers | awards | runtime | type | rated | metacritic | poster | languages | imdb | plot | cast | title | embedding | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | [Action] | [USA] | [Louis J. Gasnier, Donald MacKenzie] | Young Pauline is left a lot of money when her ... | [Charles W. Goddard (screenplay), Basil Dickey... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 199.0 | movie | None | NaN | https://m.media-amazon.com/images/M/MV5BMzgxOD... | [English] | {'id': 4465, 'rating': 7.6, 'votes': 744} | Young Pauline is left a lot of money when her ... | [Pearl White, Crane Wilbur, Paul Panzer, Edwar... | The Perils of Pauline | [-0.009285838343203068, -0.005062104668468237,... |
| 1 | 0 | [Comedy, Short, Action] | [USA] | [Alfred J. Goulding, Hal Roach] | As a penniless man worries about how he will m... | [H.M. Walker (titles)] | {'nominations': 1, 'text': '1 nomination.', 'w... | 22.0 | movie | TV-G | NaN | https://m.media-amazon.com/images/M/MV5BNzE1OW... | [English] | {'id': 10146, 'rating': 7.0, 'votes': 639} | A penniless young man tries to save an heiress... | [Harold Lloyd, Mildred Davis, 'Snub' Pollard, ... | From Hand to Mouth | [-0.0024393785279244184, 0.02309592440724373, ... |
| 2 | 0 | [Action, Adventure, Drama] | [USA] | [Herbert Brenon] | Michael "Beau" Geste leaves England in disgrac... | [Herbert Brenon (adaptation), John Russell (ad... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 101.0 | movie | None | NaN | None | [English] | {'id': 16634, 'rating': 6.9, 'votes': 222} | Michael "Beau" Geste leaves England in disgrac... | [Ronald Colman, Neil Hamilton, Ralph Forbes, A... | Beau Geste | [0.012204292230308056, -0.01145575474947691, -... |
| 3 | 1 | [Adventure, Action] | [USA] | [Albert Parker] | A nobleman vows to avenge the death of his fat... | [Douglas Fairbanks (story), Jack Cunningham (a... | {'nominations': 0, 'text': '1 win.', 'wins': 1} | 88.0 | movie | None | NaN | https://m.media-amazon.com/images/M/MV5BMzU0ND... | None | {'id': 16654, 'rating': 7.2, 'votes': 1146} | Seeking revenge, an athletic young man joins t... | [Billie Dove, Tempe Pigott, Donald Crisp, Sam ... | The Black Pirate | [0.004541348200291395, -0.0006100579630583525,... |
| 4 | 0 | [Action, Comedy, Romance] | [USA] | [Sam Taylor] | The Uptown Boy, J. Harold Manners (Lloyd) is a... | [Ted Wilde (story), John Grey (story), Clyde B... | {'nominations': 1, 'text': '1 nomination.', 'w... | 58.0 | movie | PASSED | NaN | https://m.media-amazon.com/images/M/MV5BMTcxMT... | [English] | {'id': 16895, 'rating': 7.6, 'votes': 918} | An irresponsible young millionaire changes his... | [Harold Lloyd, Jobyna Ralston, Noah Young, Jim... | For Heaven's Sake | [-0.0022256041411310434, 0.011567804962396622,... |
.colab-df-container {
display:flex;
gap: 12px;
}
.colab-df-convert {
background-color: #E8F0FE;
border: none;
border-radius: 50%;
cursor: pointer;
display: none;
fill: #1967D2;
height: 32px;
padding: 0 0 0 0;
width: 32px;
}
.colab-df-convert:hover {
background-color: #E2EBFA;
box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);
fill: #174EA6;
}
.colab-df-buttons div {
margin-bottom: 4px;
}
[theme=dark] .colab-df-convert {
background-color: #3B4455;
fill: #D2E3FC;
}
[theme=dark] .colab-df-convert:hover {
background-color: #434B5C;
box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);
filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));
fill: #FFFFFF;
}
.colab-df-quickchart {
--bg-color: #E8F0FE;
--fill-color: #1967D2;
--hover-bg-color: #E2EBFA;
--hover-fill-color: #174EA6;
--disabled-fill-color: #AAA;
--disabled-bg-color: #DDD;
}
[theme=dark] .colab-df-quickchart {
--bg-color: #3B4455;
--fill-color: #D2E3FC;
--hover-bg-color: #434B5C;
--hover-fill-color: #FFFFFF;
--disabled-bg-color: #3B4455;
--disabled-fill-color: #666;
}
.colab-df-quickchart {
background-color: var(--bg-color);
border: none;
border-radius: 50%;
cursor: pointer;
display: none;
fill: var(--fill-color);
height: 32px;
padding: 0;
width: 32px;
}
.colab-df-quickchart:hover {
background-color: var(--hover-bg-color);
box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);
fill: var(--button-hover-fill-color);
}
.colab-df-quickchart-complete:disabled,
.colab-df-quickchart-complete:disabled:hover {
background-color: var(--disabled-bg-color);
fill: var(--disabled-fill-color);
box-shadow: none;
}
.colab-df-spinner {
border: 2px solid var(--fill-color);
border-color: transparent;
border-bottom-color: var(--fill-color);
animation:
spin 1s steps(1) infinite;
}
@keyframes spin {
0% {
border-color: transparent;
border-bottom-color: var(--fill-color);
border-left-color: var(--fill-color);
}
20% {
border-color: transparent;
border-left-color: var(--fill-color);
border-top-color: var(--fill-color);
}
30% {
border-color: transparent;
border-left-color: var(--fill-color);
border-top-color: var(--fill-color);
border-right-color: var(--fill-color);
}
40% {
border-color: transparent;
border-right-color: var(--fill-color);
border-top-color: var(--fill-color);
}
60% {
border-color: transparent;
border-right-color: var(--fill-color);
}
80% {
border-color: transparent;
border-right-color: var(--fill-color);
border-bottom-color: var(--fill-color);
}
90% {
border-color: transparent;
border-bottom-color: var(--fill-color);
}
}
Step 4: Database setup and connection
MongoDB acts as both an operational and a vector database. It offers a database solution that efficiently stores, queries and retrieves vector embeddings—the advantages of this lie in the simplicity of database maintenance, management and cost.
To create a new MongoDB database, set up a database cluster:
-
Head over to MongoDB official site and register for a free MongoDB Atlas account, or for existing users, sign into MongoDB Atlas.
-
Select the 'Database' option on the left-hand pane, which will navigate to the Database Deployment page, where there is a deployment specification of any existing cluster. Create a new database cluster by clicking on the "+Create" button.
-
Select all the applicable configurations for the database cluster. Once all the configuration options are selected, click the “Create Cluster” button to deploy the newly created cluster. MongoDB also enables the creation of free clusters on the “Shared Tab”.
Note: Don’t forget to whitelist the IP for the Python host or 0.0.0.0/0 for any IP when creating proof of concepts.
-
After successfully creating and deploying the cluster, the cluster becomes accessible on the ‘Database Deployment’ page.
-
Click on the “Connect” button of the cluster to view the option to set up a connection to the cluster via various language drivers.
-
This tutorial only requires the cluster's URI(unique resource identifier). Grab the URI and copy it into the Google Colabs Secrets environment in a variable named
MONGO_URIor place it in a .env file or equivalent.
4.1 Database and Collection Setup
Before moving forward, ensure the following prerequisites are met
- Database cluster set up on MongoDB Atlas
- Obtained the URI to your cluster
For assistance with database cluster setup and obtaining the URI, refer to our guide for setting up a MongoDB cluster and getting your connection string
Once you have created a cluster, create the database and collection within the MongoDB Atlas cluster by clicking + Create Database in the cluster overview page.
Here is a guide for creating a database and collection
The database will be named movies.
The collection will be named movie_collection_2.
Step 5: Create a Vector Search Index
At this point make sure that your vector index is created via MongoDB Atlas.
This next step is mandatory for conducting efficient and accurate vector-based searches based on the vector embeddings stored within the documents in the movie_collection_2 collection.
Creating a Vector Search Index enables the ability to traverse the documents efficiently to retrieve documents with embeddings that match the query embedding based on vector similarity.
Go here to read more about MongoDB Vector Search Index.
code
{
"fields": [{
"numDimensions": 1024,
"path": "embedding",
"similarity": "cosine",
"type": "vector"
}]
}The 1024 value of the numDimension field corresponds to the dimension of the vector generated by the gte-large embedding model. If you use the gte-base or gte-small embedding models, the numDimension value in the vector search index must be set to 768 and 384, respectively.
Step 6: Establish Data Connection
The code snippet below also utilises PyMongo to create a MongoDB client object, representing the connection to the cluster and enabling access to its databases and collections.
In [ ]python · cell 13
python
import pymongo
from google.colab import userdata
def get_mongo_client(mongo_uri):
"""Establish connection to the MongoDB."""
try:
client = pymongo.MongoClient(mongo_uri)
print("Connection to MongoDB successful")
return client
except pymongo.errors.ConnectionFailure as e:
print(f"Connection failed: {e}")
return None
mongo_uri = userdata.get("MONGO_URI")
if not mongo_uri:
print("MONGO_URI not set in environment variables")
mongo_client = get_mongo_client(mongo_uri)
# Ingest data into MongoDB
db = mongo_client["movies"]
collection = db["movie_collection_2"]Output
Connection to MongoDB successful
In [6]python · cell 14
python
# Delete any existing records in the collection
collection.delete_many({})Output
DeleteResult({'n': 1452, 'electionId': ObjectId('7fffffff000000000000000c'), 'opTime': {'ts': Timestamp(1708554945, 1452), 't': 12}, 'ok': 1.0, '$clusterTime': {'clusterTime': Timestamp(1708554945, 1452), 'signature': {'hash': b'\x99\x89\xc0\x00Cn!\xd6\xaf\xb3\x96\xdf\xc3\xda\x88\x11\xf5\t\xbd\xc0', 'keyId': 7320226449804230661}}, 'operationTime': Timestamp(1708554945, 1452)}, acknowledged=True)Ingesting data into a MongoDB collection from a pandas DataFrame is a straightforward process that can be efficiently accomplished by converting the DataFrame into dictionaries and then utilising the insert_many method on the collection to pass the converted dataset records.
In [7]python · cell 16
python
documents = dataset_df.to_dict("records")
collection.insert_many(documents)
print("Data ingestion into MongoDB completed")Output
Data ingestion into MongoDB completed
Step 7: Perform Vector Search on User Queries
The following step implements a function that returns a vector search result by generating a query embedding and defining a MongoDB aggregation pipeline.
The pipeline, consisting of the $vectorSearch and $project stages, executes queries using the generated vector and formats the results to include only the required information, such as plot, title, and genres while incorporating a search score for each result.
In [8]python · cell 18
python
def vector_search(user_query, collection):
"""
Perform a vector search in the MongoDB collection based on the user query.
Args:
user_query (str): The user's query string.
collection (MongoCollection): The MongoDB collection to search.
Returns:
list: A list of matching documents.
"""
# Generate embedding for the user query
query_embedding = get_embedding(user_query)
if query_embedding is None:
return "Invalid query or embedding generation failed."
# Define the vector search pipeline
pipeline = [
{
"$vectorSearch": {
"index": "vector_index",
"queryVector": query_embedding,
"path": "embedding",
"numCandidates": 150, # Number of candidate matches to consider
"limit": 4, # Return top 4 matches
}
},
{
"$project": {
"_id": 0, # Exclude the _id field
"fullplot": 1, # Include the plot field
"title": 1, # Include the title field
"genres": 1, # Include the genres field
"score": {"$meta": "vectorSearchScore"}, # Include the search score
}
},
]
# Execute the search
results = collection.aggregate(pipeline)
return list(results)Step 8: Handling user queries and loading Gemma
In [ ]python · cell 20
python
def get_search_result(query, collection):
get_knowledge = vector_search(query, collection)
search_result = ""
for result in get_knowledge:
search_result += f"Title: {result.get('title', 'N/A')}, Plot: {result.get('fullplot', 'N/A')}\n"
return search_resultIn [13]python · cell 21
python
# Conduct query with retrival of sources
query = "What is the best romantic movie to watch and why?"
source_information = get_search_result(query, collection)
combined_information = f"Query: {query}\nContinue to answer the query by using the Search Results:\n{source_information}."
print(combined_information)Output
Query: What is the best romantic movie to watch and why? Continue to answer the query by using the Search Results: Title: Shut Up and Kiss Me!, Plot: Ryan and Pete are 27-year old best friends in Miami, born on the same day and each searching for the perfect woman. Ryan is a rookie stockbroker living with his psychic Mom. Pete is a slick surfer dude yet to find commitment. Each meets the women of their dreams on the same day. Ryan knocks heads in an elevator with the gorgeous Jessica, passing out before getting her number. Pete falls for the insatiable Tiara, but Tiara's uncle is mob boss Vincent Bublione, charged with her protection. This high-energy romantic comedy asks to what extent will you go for true love? Title: Pearl Harbor, Plot: Pearl Harbor is a classic tale of romance set during a war that complicates everything. It all starts when childhood friends Rafe and Danny become Army Air Corps pilots and meet Evelyn, a Navy nurse. Rafe falls head over heels and next thing you know Evelyn and Rafe are hooking up. Then Rafe volunteers to go fight in Britain and Evelyn and Danny get transferred to Pearl Harbor. While Rafe is off fighting everything gets completely whack and next thing you know everybody is in the middle of an air raid we now know as "Pearl Harbor." Title: Titanic, Plot: The plot focuses on the romances of two couples upon the doomed ship's maiden voyage. Isabella Paradine (Catherine Zeta-Jones) is a wealthy woman mourning the loss of her aunt, who reignites a romance with former flame Wynn Park (Peter Gallagher). Meanwhile, a charming ne'er-do-well named Jamie Perse (Mike Doyle) steals a ticket for the ship, and falls for a sweet innocent Irish girl on board. But their romance is threatened by the villainous Simon Doonan (Tim Curry), who has discovered about the ticket and makes Jamie his unwilling accomplice, as well as having sinister plans for the girl. Title: China Girl, Plot: A modern day Romeo & Juliet story is told in New York when an Italian boy and a Chinese girl become lovers, causing a tragic conflict between ethnic gangs. .
In [ ]python · cell 22
python
from transformers import AutoTokenizer, AutoModelForCausalLM
tokenizer = AutoTokenizer.from_pretrained("google/gemma-2b-it")
# CPU Enabled uncomment below 👇🏽
# model = AutoModelForCausalLM.from_pretrained("google/gemma-2b-it")
# GPU Enabled use below 👇🏽
model = AutoModelForCausalLM.from_pretrained("google/gemma-2b-it", device_map="auto")In [16]python · cell 23
python
# Moving tensors to GPU
input_ids = tokenizer(combined_information, return_tensors="pt").to("cuda")
response = model.generate(**input_ids, max_new_tokens=500)
print(tokenizer.decode(response[0]))Output
<bos>Query: What is the best romantic movie to watch and why? Continue to answer the query by using the Search Results: Title: Shut Up and Kiss Me!, Plot: Ryan and Pete are 27-year old best friends in Miami, born on the same day and each searching for the perfect woman. Ryan is a rookie stockbroker living with his psychic Mom. Pete is a slick surfer dude yet to find commitment. Each meets the women of their dreams on the same day. Ryan knocks heads in an elevator with the gorgeous Jessica, passing out before getting her number. Pete falls for the insatiable Tiara, but Tiara's uncle is mob boss Vincent Bublione, charged with her protection. This high-energy romantic comedy asks to what extent will you go for true love? Title: Pearl Harbor, Plot: Pearl Harbor is a classic tale of romance set during a war that complicates everything. It all starts when childhood friends Rafe and Danny become Army Air Corps pilots and meet Evelyn, a Navy nurse. Rafe falls head over heels and next thing you know Evelyn and Rafe are hooking up. Then Rafe volunteers to go fight in Britain and Evelyn and Danny get transferred to Pearl Harbor. While Rafe is off fighting everything gets completely whack and next thing you know everybody is in the middle of an air raid we now know as "Pearl Harbor." Title: Titanic, Plot: The plot focuses on the romances of two couples upon the doomed ship's maiden voyage. Isabella Paradine (Catherine Zeta-Jones) is a wealthy woman mourning the loss of her aunt, who reignites a romance with former flame Wynn Park (Peter Gallagher). Meanwhile, a charming ne'er-do-well named Jamie Perse (Mike Doyle) steals a ticket for the ship, and falls for a sweet innocent Irish girl on board. But their romance is threatened by the villainous Simon Doonan (Tim Curry), who has discovered about the ticket and makes Jamie his unwilling accomplice, as well as having sinister plans for the girl. Title: China Girl, Plot: A modern day Romeo & Juliet story is told in New York when an Italian boy and a Chinese girl become lovers, causing a tragic conflict between ethnic gangs. . Based on the search results, the best romantic movie to watch is **Shut Up and Kiss Me!** because it is a romantic comedy that explores the complexities of love and relationships. The movie is funny, heartwarming, and thought-provoking.<eos>
In [12]python · cell 24
python