text_plain_output_1.png
import matplotlib.pyplot as plt

import pandas as pd

import seaborn as sns

url = '../input/dataquest2020/energy_train.csv'
df_training = pd.read_csv(url)

url = '../input/dataquest2020/energy_test.csv'
df_testing = pd.read_csv(url)

df_training['source'] = 'train'
df_testing['source'] = 'test'

df = pd.concat([df_training, df_testing], axis=0, ignore_index=True)
df

df.isnull().sum().sort_values(ascending=False)

df.apply(lambda x: len(x.unique()))

corr = df.corr().round(2)
corr