<jupyter_start><jupyter_text>1.	Import the pandas and load the two dataset(mark.csv and student.csv) into the pandas dataframe.<jupyter_code>import pandas as pd
df1 = pd.read_csv('https://raw.githubusercontent.com/TrainingByPackt/Data-Science-with-Python/master/Chapter01/Data/mark.csv',header = 0)
df2 = pd.read_csv('https://raw.githubusercontent.com/TrainingByPackt/Data-Science-with-Python/master/Chapter01/Data/student.csv',header = 0)<jupyter_output><empty_output><jupyter_text>2.	Print out the top 5 rows of df1<jupyter_code>df1.head()<jupyter_output><empty_output><jupyter_text>3.	Print out the top 5 rows of df2<jupyter_code>df2.head()<jupyter_output><empty_output><jupyter_text>4.	Perform data integration to both the dataframe with respect to the column ‘Student_id’ key word ‘pd.merge()’<jupyter_code>df = pd.merge(df1, df2, on = 'Student_id')<jupyter_output><empty_output><jupyter_text>5.	Print out the top 5 rows of df<jupyter_code>df.head()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.125, 'fraction_numerical': 0.022357723577235773, 'mean_word_length': 7.418803418803419, 'pattern_counts': {'":': 0, '<': 21, '<?xml version=': 0, '>': 21, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '5', 'dir': 'jupyter-structured-clean-dedup', 'id': '665135', 'license': 'MIT', 'n_tokens_mistral': 387, 'n_tokens_neox': 365, 'n_words': 68, 'path': 'Chapter01/Excercises/Excercise_05_Data _Integration_merge.ipynb', 'repo_name': 'TrainingByPackt/Master-Data-Science-with-Python-', 'size': '984'}