Linear regression doubt - Urgent

[kumarants]

Please clarify below error and support me to resolve this

My code is:

import pandas as pd
import numpy as np
from sklearn import linear_model
import statsmodels.api as sm
from sklearn.metrics import mean_squared_error
data=pd.read_excel('C:/Users/Kumaran TS/Desktop/Jupyter prg/Tensile.xlsx')
data
x=data['Hardness'].values.reshape(-1,1)
y=data['Tensile strength'].values.reshape(-1,1)
x_train,x_test,y_train,y_test = train_test_spilt(x,y,test_size=0.2,random_state=80)

Error is:

Error:
---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-6-ce5307eca8bb> in <module>
      1 x=data['Hardness'].values.reshape(-1,1)
      2 y=data['Tensile strength'].values.reshape(-1,1)
----> 3 x_train,x_test,y_train,y_test = train_test_spilt(x,y,test_size=0.2,random_state=80)

NameError: name 'train_test_spilt' is not defined

[buran]

the error is clear. name train_test_spilt is not defined. Where does it supposedly come from? It looks like you need to import it from sklearn.model_selection

[kumarants]

Sorry buran...next time I will follow your instruction post queries in right way.

Yes. to answer your question. It is called from this command. I had missed out in my posting.

from sklearn.model_selection import train_test_split

Still it is not working

[buran]

Still it is not working

that's not very helpful. post the full traceback you get, in error tags

[kumarants]

Please find the below full program with error. Please support to fix it

import pandas as pd
import numpy as np
from sklearn import linear_model
import statsmodels.api as sm
from sklearn.metrics import mean_squared_error
data=pd.read_excel('C:/Users/Kumaran TS/Desktop/Jupyter prg/Tensile.xlsx')
from sklearn.model_selection import train_test_split
x=data['Hardness'].values.reshape(-1,1)
y=data['Tensile strength'].values.reshape(-1,1)
x_train,x_test,y_train,y_test = train_test_spilt(x,y,test_size=0.2,random_state=80)

Error:
---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-12-70b6210ad150> in <module>
      8 x=data['Hardness'].values.reshape(-1,1)
      9 y=data['Tensile strength'].values.reshape(-1,1)
---> 10 x_train,x_test,y_train,y_test = train_test_spilt(x,y,test_size=0.2,random_state=80)

NameError: name 'train_test_spilt' is not defined

[buran]

you have a typo train_test_spilt

[kumarants]

Thanks a lot...simple typo mistake...and really thanks for your timely swift support.

I am basically hardcore mechanical engg...heading India Region LEAN & 6Sigma function in an automotive company.Just start exploring data science and Industry 4.0 learning during this lock-down period.making step by step progress...once again thanks for quick response.