'type' object is not subscriptable

Question

import pandas as pd
import numpy as np

fruits = ["APPLE","BANANA","GRAPES","ORANGE"]
prices = [80,45,60,50]


fru_prices = pd.DataFrame[fruits,prices]

I am getting error while I am creating a Data Frame : 'type' object is not subscriptable

`pd.DataFrame` is not a list but a method. So add the brackets `pd.DataFrame([fruits,prices])` — Bharath M Shetty, Sep 23 '18 at 05:15
`pd.DataFrame` is a method and of type `'type'`. So, you are getting error as `'type' object is not subscriptable`. — Jagadeesh Dondeti, Sep 23 '18 at 05:20
But fruits names are in row wise how to make it column wise ? — sk jainmiah, Sep 23 '18 at 05:21
Pandas has a great tutorial for beginners . Do go through that http://nbviewer.jupyter.org/urls/bitbucket.org/hrojas/learn-pandas/raw/master/lessons/01%20-%20Lesson.ipynb and https://pandas.pydata.org/pandas-docs/stable/tutorials.html — Bharath M Shetty, Sep 23 '18 at 05:25

score 1 · Answer 1 · answered Sep 23 '18 at 05:24

1

pd.DataFrame is a method and of type 'type'. So, you are getting error as 'type' object is not subscriptable. So,

fru_prices = pd.DataFrame([fruits,prices])

answered Sep 23 '18 at 05:24

Jagadeesh Dondeti

374
2
13

But fruits names are in row wise how to make it column wise ? – sk jainmiah Sep 23 '18 at 05:25
@skjainmiah transpose the dataframe i.e `pd.DataFrame([fruits,prices]).T` – Bharath M Shetty Sep 23 '18 at 05:28

U13-Forward · Accepted Answer · 2018-09-23T05:36:51.263

1

You have to call DataFrame then as an argument do the list:

fru_prices=pd.DataFrame([fruits,prices])

And as you want to transpose do:

fru_prices=fru_prices.T

And need columns so:

fru_prices.columns=['fruits','prices']

Then fru_prices is what you want

Actually you can do this all in one-line:

fru_prices=pd.DataFrame([fruits,prices],index=['fruit','prices']).T

See:What does it mean to "call" a function in Python?

edited Sep 23 '18 at 05:36

answered Sep 23 '18 at 05:31

U13-Forward

69,221
14
89
114

1

Will it be faster when I execute it with lot of data ? – sk jainmiah Sep 23 '18 at 05:51
Yup it will, pandas is always fast – U13-Forward Sep 23 '18 at 05:52
1

Thank you sir, how to follow you ? – sk jainmiah Sep 23 '18 at 06:00
@skjainmiah Follow me, there's no way to do that on stackoverflow tho, but an accept and upvote makes me happy already :-), hahaha. – U13-Forward Sep 23 '18 at 06:02

score 1 · Answer 3 · answered Sep 23 '18 at 05:32

1

Use below code as: pd.DataFrame is a method. python : 3.6.2

import pandas as pd
import numpy as np

fruits = ["APPLE","BANANA","GRAPES","ORANGE"]
prices = [80,45,60,50]


fru_prices =pd.DataFrame([fruits,prices])
fru_prices = fru_prices.set_index(0).T ##This entry conver it into row to column
print(fru_prices)

OutPut:

0   APPLE  80
1  BANANA  45
2  GRAPES  60
3  ORANGE  50

Check this and let us know in case of this code works.

answered Sep 23 '18 at 05:32

Suresh

489
3
7

1

Thanks for your answer but Column Names are missing Sir. – sk jainmiah Sep 23 '18 at 05:36

score 1 · Answer 4 · edited Sep 14 '19 at 04:14

1

This error, i.e, 'type' object is not subscriptable, occurs when I am using square brackets. Using parenthesis solves the problem.

edited Sep 14 '19 at 04:14

Bhargav Rao

50,140
28
121
140

answered Sep 14 '19 at 03:44

surya morse

11
1

When your answer is too short, you can send it as a comment. – Saeid Amini Sep 14 '19 at 04:18

sk jainmiah · Answer 5 · 2018-09-23T05:46:19.210

0

    import pandas as pd
    import numpy as np

    fruits = ["APPLE","BANANA","GRAPES","ORANGE"]
    prices = [80,45,60,50]

    fru_prices = list(zip(fruits,prices))

    pd.DataFrame(data = fru_prices ,columns = ['fruits','prices'])

---------------------------------------------------------------------

    output :

    fruits  prices
 0  APPLE   80
 1  BANANA  45
 2  GRAPES  60
 3  ORANGE  50



> Python zip function takes iterable elements as input, and returns
> iterator. Now data will appear in column wise.

edited Sep 23 '18 at 05:46

answered Sep 23 '18 at 05:33

sk jainmiah

53
2
2
10

Why `zip` instead of pandas `T` method – U13-Forward Sep 23 '18 at 05:38
When Pandas T is used we can transpose the data but column headings are not printed, while zip clearly represent the column names. – sk jainmiah Sep 23 '18 at 05:42
Well but..., how about mine?, okay but then use `index` instead of `columns`, (all in mine) – U13-Forward Sep 23 '18 at 05:42
1

Thank you @U9-Forward . Your answer also works for me. – sk jainmiah Sep 23 '18 at 05:49
happy that i helped, – U13-Forward Sep 23 '18 at 05:52

'type' object is not subscriptable

5 Answers5