How do I load a excel file from my system in ScitKit for train and test

Question

How do I load a excel file from my system in SciKit for train and test.

I tried pandas for importing, i was able to import it using

data=pd.read_excel("IRIS.xlsx")

print(data.head()) but then am not able to perform this line X,y=data(return_X_y=True) giving me a dataframe error. what should i do or import before this line so i am able to carry out train and test successfully code and error

score 0 · Answer 1 · answered Feb 12 '23 at 12:11

data is a pandas Dataframe and it does not have any method return_X_y=True. This is only present in most sklearn load data functions e.g. `sklearn.datasets.load_XXX```.

In your case you load the data manually thus, you just need to slice and select the desired columns.

y = data["target"].values

# select all columns except the target
X = data.loc[:, data.columns != "target"].values

score 0 · Answer 2 · answered Feb 12 '23 at 12:25

0

Use .iloc:

data = pd.read_excel('IRIS.xlsx')
X, y = data.iloc[:, :-1], data.iloc[-1]

If you really want to use iris dataset, use sklearn directly:

from sklearn.datasets import load_iris

iris = load_iris()
X, y = iris['data'], iris['target']

answered Feb 12 '23 at 12:25

Corralien

109,409
8
28
52

More processing on this dataframe [here](https://stackoverflow.com/a/69822068/15239951) – Corralien Feb 12 '23 at 12:30
when I try to get the length of y it returns 5, instead of 150. I think it is a matter of slicing so can you help me with it? – HarshitMalhotra Feb 13 '23 at 12:22
Is it the same for `len(X)`? – Corralien Feb 13 '23 at 12:58
it gives a key error then for X – HarshitMalhotra Feb 14 '23 at 06:29
Do you use the method with `.iloc` or do you load dataset from `sklearn`? Please provide the output of `print(data.head())` – Corralien Feb 14 '23 at 07:21
I am using `.iloc`, it is returning the right data but for only 5 rows. – HarshitMalhotra Feb 14 '23 at 08:14
In your code above, do you have something like `data = data.head()`? – Corralien Feb 14 '23 at 08:25
no, but i added and it had no changes ,still the same thing. – HarshitMalhotra Feb 14 '23 at 15:51
Can you share your file? – Corralien Feb 14 '23 at 16:24

How do I load a excel file from my system in ScitKit for train and test

2 Answers2