'colab getting crashed while running the python script

i'm using the following code for merging two excel files which has around 800k rows in each, is there any other way to merge the files in same fashion or any solution?

import pandas as pd
df=pd.read_csv("master file.csv")
df1=pd.read_csv("onto_diseas.csv")
df4=pd.merge(df, df1, left_on = 'extId', right_on = 'extId', how = 'inner')
df4

Solution 1:^[1]

Try use dask or drill for merging or specify datatypes demanding less memory while (float16 instead float64 & so forth) creating dataframes. I could show this in code if you provide links to your files.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Vovin

'colab getting crashed while running the python script

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]