This problem will happen because the function corr() cannot calculate the correlation for the columns that are declared as non-numerical data, in this example the Date column has type object. I've solved the problem by following the below step-by-step: # checking which columns contain numerical data print(gold_data.dtypes) # select only the columns with numerical values numerical_data = gold_data.select_dtypes(include=['float64', 'int64']) # calculate the correlation correlation = numerical_data.corr() print(correlation) # constructing a heatmap to understand the correlation plt.figure(figsize=(8,8)) sns.heatmap(correlation, cbar=True, square=True, fmt='.1f', annot=True, annot_kws={'size':8}, cmap='Blues')
Maybe this problem is specific to me but the correlation method is returning an error which mentions that date is a string. I worked around it by dropping the date column and then finding the correlation. Not sure if it's the right way to go about it though...!
Hi thanks for your wonderful content I just have a problem, in 16:12 i get an error : ValueError : could not convert string to float : '1/2/2008', Could you please help me to solve it?
Yeah. This is because the corr() function while calculating correlation does not accept Strings(dates are strings in the dataset). So, u can solve this issue by dropping the Date column from the dataset before running that line. Add this cell before that line: gold_data = gold_data.drop('Date',axis=1) and execute again. Now the error will go away
Why are the project not in serial order and few are missing !! also i feel few projects are taken from other youtube channels, sorry if offended but have strong step to step copy paste !!
Can I use this project as a mini project for college coz iam a beginner and doing this project in 2 year of studying Can u help me How to do the project
Sir I have a doubt like the dates are also important during the prediction of the gold price how should we make our model to take the date variable too. And sir similar in the case of the car price prediction we have dropped the car brand and the name of the car there also . And these things also important in the prediction of the prices of the car Regards
hi! you can try a time series prediction kind of an approach for gold price prediction. for car price prediction, you can definitely add the brands as feature for training. my goal while making the videos will be to clearly explain the implementation and the process in it. I may miss a thing or two. so you can definitely improvise a lot.
Monet12 Thank you for a wonderful and thorough explanation. When are you gonna make a project in forecasting stock prices so i can become a billionaire?
It's very easy to understand. thanks What is the reason behind in R square error to use is there any other functions we can use?.. can you explain more on this please.
Might be. It is in us dollars. I am not sure what is the specific metric. You can refer this for details about the dataset: www.kaggle.com/altruistdelhite04/gold-price-data
U explains everything in simple way. Amazing n simplest videos for beginners.
Hmmm... this is a time series prediction. When doing train test split, we can't do random split. It is not right.
one of the most amazing and simplest courses ever!
Correlation is impossible
ValueError: could not convert string to float: '1/2/2008'
yeah
This problem will happen because the function corr() cannot calculate the correlation for the columns that are declared as non-numerical data, in this example the Date column has type object. I've solved the problem by following the below step-by-step:
# checking which columns contain numerical data
print(gold_data.dtypes)
# select only the columns with numerical values
numerical_data = gold_data.select_dtypes(include=['float64', 'int64'])
# calculate the correlation
correlation = numerical_data.corr()
print(correlation)
# constructing a heatmap to understand the correlation
plt.figure(figsize=(8,8))
sns.heatmap(correlation, cbar=True, square=True, fmt='.1f', annot=True, annot_kws={'size':8}, cmap='Blues')
@@thiagoalves4080 you also try with drop the date column
correlation = gold_data.corr(numeric_only=True) # just copy paste this...
1.48k to 48.1k, many congratulations Siddharthan !
I am enjoying your ML projects series very much. TQ!
Glad you like them!😇
Excellent. Conceptually an Awesome drive to perfection. Hats Off Mr. Siddhardhan.
Maybe this problem is specific to me but the correlation method is returning an error which mentions that date is a string. I worked around it by dropping the date column and then finding the correlation.
Not sure if it's the right way to go about it though...!
I am also facing the same problem
correlation = gold_data.corr(numeric_only=True) # just copy paste this...
very high quality content man you deserve a gold play button
AT the correlation part i have got value error '' string can not be chnaged to float '' how to fix it
Just drop the date column and then run correlation. correlation = df.drop(['Date'],axis=1).corr()
its a great video.. Can you please make one more detailed video on the correlation matrix
Hi thanks for your wonderful content I just have a problem, in 16:12 i get an error : ValueError : could not convert string to float : '1/2/2008', Could you please help me to solve it?
import datetime
gold_data['Date'] = pd.to_datetime(gold_data['Date']) use this code
Yeah. This is because the corr() function while calculating correlation does not accept Strings(dates are strings in the dataset). So, u can solve this issue by dropping the Date column from the dataset before running that line. Add this cell before that line: gold_data = gold_data.drop('Date',axis=1) and execute again. Now the error will go away
Bro you removed date as one of the features - can you explain why you did so ?
Cause date of when gold prices are predicted is also one of the factors
this doesnt make sense in order to predict gold we need future value of other stocks? how will that be feasible in actual life?
Hi Sir,Nice explanation.Don't we have to Scale these values using standard scaler??
ya excellent question, maybe we have to not sure though
Bro how to know which type of regression is used for a particular data set
Thanks really helped me. Can you suggest how anyone will go to the job field with machine learning? what other things to learn?
sir should we drop the date column before plotiing heatmap ?beacuse i have an error related to date data type while plottin ?
Great man 👍🏻. Can you please make a video on end to end project deployment on herouku or AWS ?
hi! deployment will be covered after deep learning course
it's great but how can i predict for future , 5 weekd a head or 1 week ahead
you can use forecasting models like LSTM
@@Siddhardhan i tried that but i only get graph i want actual values
Hi. What is the accuracy level of the project? Please tell me
how to predict the present price
it is helpful for the begginers like me
Thank u
my pleasure 😇
Hi Sir can you please tell why we did Y_test = list(Y_test) at last while when we did scatter plot in Car prediction code we didn't do it.
Why are the project not in serial order and few are missing !! also i feel few projects are taken from other youtube channels, sorry if offended but have strong step to step copy paste !!
Sir can you make a video of github regarding how to upload this project we have just finished kindly... Thanks
Can I get the dataset and code for future goldprice prediction?Using LSTM like methods
Please do videos on forecasting..😥
Can I use this project as a mini project for college coz iam a beginner and doing this project in 2 year of studying
Can u help me
How to do the project
need front end code for end to end model
this model is predicting the future value of gold or what ?
Sir could you please make video on driver drowsiness detection using dlib
sir, this project can done in AI too ?
if yes i need your guide lines, please sir.
Which algorithm u used in this project
Can you please make tutorial on how to deploy ML model in Heroku, AWS, GCP
I'll work on that after completing this machine learning course.
could you please predict the gold price using decision tree with the closing price and all?
Sir, How to Connect Front End to this Project.
Do you have any Front End to this Project
Send this code bro
Your video was very helpful in my assessment. Keep up the good work. Cheers
finished watching
So what is the prediction for the next 10 years?
Sir how to check overfitting
Can You please tell methodology of this project.
Why did we use random forest only and not any other algorithms? Can we use any other algorithms?
yes, also random forest is used as classifier i think regression is more suitable here. Yes?
20:46 even spx is positively correlated right why we are not considering spx?
yeah, but the value is very low... that means there is not a significant correlation...
Sir I have a doubt like the dates are also important during the prediction of the gold price how should we make our model to take the date variable too.
And sir similar in the case of the car price prediction we have dropped the car brand and the name of the car there also . And these things also important in the prediction of the prices of the car
Regards
hi! you can try a time series prediction kind of an approach for gold price prediction.
for car price prediction, you can definitely add the brands as feature for training. my goal while making the videos will be to clearly explain the implementation and the process in it. I may miss a thing or two. so you can definitely improvise a lot.
@@Siddhardhan Thanks a lot sir for your reply
Bro ...ipd naane sonthama project pannanumna enna panrathu...enga irunthu start panrathu learning ku
After correlation, I am getting value error ...!like pass 2-d input wt to do sir??
hi! mail your error with screenshot and your Google colab link to datascience2323@gmail.com
correlation part not executing...
How can I show output of this to web ?
Sir in what basis you have predicted the price of gold ?
I want report of GOLD PRICE PREDICTION PROJECT...
How can I get?
did you get it ?
From where I can get this data set.
I have given the link for the dataset in the description of this video.
You can also search for it in Kaggle
Monet12
Thank you for a wonderful and thorough explanation. When are you gonna make a project in forecasting stock prices so i can become a billionaire?
thanks! may be in the future 😄
Sir I am a fresher can I add this project to my resume for campus placement ?
if you completely understand the Project, if you practice the code by yourself, then you can add.
How can I know the accuracy value of this algorithm?
you can calculate mean absolute error and other metrics.
@@Siddhardhan can you make a video on stock price prediction with rnn lstm and other complex algorithms
pronostic model?
how to find new predicted gold price based on new row
hi! refer my other project videos to learn how to make a predictive system.
@@Siddhardhan thanks got it
At 29:43 i am getting an error
finished coding
It's very easy to understand. thanks
What is the reason behind in R square error to use is there any other functions we can use?.. can you explain more on this please.
you can use mean Absolute error as well. these are metrics for Regression problems
Can we use XGBRegressor?
Yes, you can
What does each feature signifies in the data set ?
Hi! I have explained it in the video. Kindly check. They are silver price, currency pair value, etc.
@@Siddhardhan Does the data mean that gold price is around 120 in 2018?
Might be. It is in us dollars. I am not sure what is the specific metric. You can refer this for details about the dataset: www.kaggle.com/altruistdelhite04/gold-price-data
Give me the abstract please
hi! I have given the Kaggle link for this project in the description of this video... you can get more information there... kindly check.
Can we use same data set for prediction using RNN as dates mentioned in data set are not continuous ?
Hi! this dataset is very small.. it won't be suitable to do with RNN. but yes. u can definitely try.
Can I using Linear Regression to solve this task sir?
hi! you can definitely try.
sir i want to follow you in kaggle
pls give your link
sir i want to follow you on kaggle
ls give your link
sir i want to follow you in kaggle
pls give your link
sir i want to follow you in kaggle
pls give your link
sir i want to follow you in kaggle
pls give your link
hi! I am not that active in Kaggle recently