I followed your video and it work well, but I am trying to create heatmap instead of the table/data frame. import seaborn as sns plt.figure(figsize=(20,18)) #corr = Tablematrix[cor_col] sns.heatmap(dataset.correlation.corr(), cmap= 'viridis', vmax=1.0,vmin=-1.0, linewidths=1, annot=False,annot_kws={"size":1}, square=True); plt.set_xticklabels(plt.get_xticklabels(), rotation=30) plt.xlabel("X-Axis") plt.ylabel("Y-Axis") plt.show() how can I do this without Pandas?
Hello, it's very easy to create using seaborn. In notebook where I finish coding below that insert a new cell and just copy pase the below line of code and you will be able to plot in 1 minute >import seaborn as sns >sns.heatmap(corrmatrix, xticklabels=df_corr.columns, yticklabels=df_corr.columns, annot=True)
Hi Amir, in colab the following line is giving error: matrix = Correlation.corr(df_vector, vector_col).collect()[0][0] I have taken your house_price.csv dataset. Till then everything executed properly.
Ok, you are getting this error because there are missing values in your data frame. First, you need to either remove missing values or impute them mean or median
How do you create a csv file of your final data frame correlation results? Excellent video by the way, great job!
Thank you. You can convert it to pandas dataframe and then write as a csv file.
I followed your video and it work well, but I am trying to create heatmap instead of the table/data frame.
import seaborn as sns
plt.figure(figsize=(20,18))
#corr = Tablematrix[cor_col]
sns.heatmap(dataset.correlation.corr(),
cmap= 'viridis', vmax=1.0,vmin=-1.0, linewidths=1,
annot=False,annot_kws={"size":1}, square=True);
plt.set_xticklabels(plt.get_xticklabels(), rotation=30)
plt.xlabel("X-Axis")
plt.ylabel("Y-Axis")
plt.show()
how can I do this without Pandas?
Hello, it's very easy to create using seaborn. In notebook where I finish coding below that insert a new cell and just copy pase the below line of code and you will be able to plot in 1 minute
>import seaborn as sns
>sns.heatmap(corrmatrix, xticklabels=df_corr.columns,
yticklabels=df_corr.columns, annot=True)
Hi Amir, in colab the following line is giving error:
matrix = Correlation.corr(df_vector, vector_col).collect()[0][0]
I have taken your house_price.csv dataset.
Till then everything executed properly.
Can you paste the error message here
Ok, you are getting this error because there are missing values in your data frame. First, you need to either remove missing values or impute them mean or median
@@StatsWire Great I will try it, but I used the "house_price.csv" from your gitub. Thanks a lot I will do the same.
@@pritishbanerjee5517 I might have edited that CSV. I will check and reply to you. Sorry for the inconvenience Pritish
Could you please send me the dataset house.csv link ?
Hi, please find the dataset link: github.com/siddiquiamir/Data
Nice
Thank you
bro why 9 unavailable videos are hidden
I have scheduled them, they will come one by one