Convert index number to int (Python)

Question

EDIT: The .mean() function works just right:

renda['age'].mean()

I'm still not sure why the errors mentioned below and in the answers happened, but this helps as a shortcut.

I got a DataFrame renda in which there's a column age and I need to get the mean of the ages. I wrote

t_age = renda['age'].sum()
renda.index = renda.index.map(int) #intended solution
last_id = renda.iloc(-1)
print(t_age/last_id)

Trying to adapt the answers from here. It still doesn't work though and this error is raised:

TypeError: unsupported operand type(s) for /: 'int' and '_iLocIndexer'

What can I do to solve this? Thank you!

@ScottBoston:

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in na_op(x, y)
    657             result = expressions.evaluate(op, str_rep, x, y,
--> 658                                           raise_on_error=True, **eval_kwargs)
    659         except TypeError:

/opt/conda/lib/python3.6/site-packages/pandas/core/computation/expressions.py in evaluate(op, op_str, a, b, raise_on_error, use_numexpr, **eval_kwargs)
    210         return _evaluate(op, op_str, a, b, raise_on_error=raise_on_error,
--> 211                          **eval_kwargs)
    212     return _evaluate_standard(op, op_str, a, b, raise_on_error=raise_on_error)

/opt/conda/lib/python3.6/site-packages/pandas/core/computation/expressions.py in _evaluate_numexpr(op, op_str, a, b, raise_on_error, truediv, reversed, **eval_kwargs)
    121     if result is None:
--> 122         result = _evaluate_standard(op, op_str, a, b, raise_on_error)
    123 

/opt/conda/lib/python3.6/site-packages/pandas/core/computation/expressions.py in _evaluate_standard(op, op_str, a, b, raise_on_error, **eval_kwargs)
     63     with np.errstate(all='ignore'):
---> 64         return op(a, b)
     65 

/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in <lambda>(x, y)
     96                           default_axis=default_axis, reversed=True),
---> 97         rtruediv=arith_method(lambda x, y: operator.truediv(y, x),
     98                               names('rtruediv'), op('/'), truediv=True,

TypeError: unsupported operand type(s) for /: 'int' and 'str'

During handling of the above exception, another exception occurred:

TypeError                                 Traceback (most recent call last)
/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in safe_na_op(lvalues, rvalues)
    681             with np.errstate(all='ignore'):
--> 682                 return na_op(lvalues, rvalues)
    683         except Exception:

/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in na_op(x, y)
    667                 mask = notnull(x)
--> 668                 result[mask] = op(x[mask], y)
    669             else:

/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in <lambda>(x, y)
     96                           default_axis=default_axis, reversed=True),
---> 97         rtruediv=arith_method(lambda x, y: operator.truediv(y, x),
     98                               names('rtruediv'), op('/'), truediv=True,

TypeError: unsupported operand type(s) for /: 'int' and 'str'

During handling of the above exception, another exception occurred:

TypeError                                 Traceback (most recent call last)
<ipython-input-71-d5969a714aff> in <module>()
      3 renda.index = renda.index.astype(int) #use astype to convert to int
      4 last_id = renda.iloc[-1] #Square brackets
----> 5 print(t_age/last_id)

/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in wrapper(left, right, name, na_op)
    719                 lvalues = lvalues.values
    720 
--> 721         result = wrap_results(safe_na_op(lvalues, rvalues))
    722         return construct_result(
    723             left,

/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in safe_na_op(lvalues, rvalues)
    690                 if is_object_dtype(lvalues):
    691                     return libalgos.arrmap_object(lvalues,
--> 692                                                   lambda x: op(x, rvalues))
    693             raise
    694 

pandas/_libs/algos_common_helper.pxi in pandas._libs.algos.arrmap_object (pandas/_libs/algos.c:31954)()

/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in <lambda>(x)
    690                 if is_object_dtype(lvalues):
    691                     return libalgos.arrmap_object(lvalues,
--> 692                                                   lambda x: op(x, rvalues))
    693             raise
    694 

/opt/conda/lib/python3.6/site-packages/pandas/core/ops.py in <lambda>(x, y)
     95         rsub=arith_method(lambda x, y: y - x, names('rsub'), op('-'),
     96                           default_axis=default_axis, reversed=True),
---> 97         rtruediv=arith_method(lambda x, y: operator.truediv(y, x),
     98                               names('rtruediv'), op('/'), truediv=True,
     99                               fill_zeros=np.inf, default_axis=default_axis,

TypeError: ufunc 'true_divide' not supported for the input types, and the inputs could not be safely coerced to any supported types according to the casting rule ''safe''

@juanpa.arrivillaga:

Please provide a minimal reproducible example

juanpa.arrivillaga
– juanpa.arrivillaga

2018-01-30 18:56:04 +00:00
Commented Jan 30, 2018 at 18:56 — juanpa.arrivillaga
– juanpa.arrivillaga, Commented Jan 30, 2018 at 18:56

Scott Boston · Accepted Answer · 2018-01-31 18:34:25Z

12

I think you need this:

t_age = renda['age'].astype(int).sum()
renda.index = renda.index.astype(int) #use astype to convert to int
last_id = renda.iloc[-1] #Square brackets
print(t_age/last_id)

edited Jan 31, 2018 at 18:34

answered Jan 30, 2018 at 18:45

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Scott Boston Over a year ago

@RenanAndrade I don't see any syntax errors in your image.

juanpa.arrivillaga Over a year ago

@RenanAndrade what errors? Please provide full error messages as formatted text in the question itself.

Renan Andrade Over a year ago

Sorry, I didn't know which errors were relevant, so I thought creating that file would be better. I didn't type it here because it exceeded the max of characteres (and not in the question because the errors I referenced just above were about this answer).

Scott Boston Over a year ago

@RenanAndrade your link above just has this in it: {"success":false,"error":404,"message":"Not Found"}

Renan Andrade Over a year ago

I'll try pasting it in the question, then. I also found out about the mean() function and I believe it might work.

|

Pang · Accepted Answer · 2018-02-07 05:21:35Z

3

Convert index to column and then, you will be able to take mean of column using the code below.

   render=render.reset_index(level=['age'])# Convert index to column
   render['age']=render.age.astype(str)
   age_mean=render['age'].mean()

edited Feb 7, 2018 at 5:21

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Jan 30, 2018 at 18:50

user15051990

1,9454 gold badges29 silver badges47 bronze badges

1 Comment

Renan Andrade Over a year ago

I tried reseting renda to render and I get KeyError: 'Level age must be same as name (None)'. If I keep renda it says render isn't defined.

juanpa.arrivillaga · Accepted Answer · 2018-01-30 18:59:41Z

2

Your fundamental probelm is that iloc is suppose to be used with __getitem__ not with __call__, in other words:

last_id = renda.iloc(-1)

Should be:

last_id = renda.iloc[-1]

The former creates an indexer object, which is not what you want. You want to index.

answered Jan 30, 2018 at 18:59

juanpa.arrivillaga

97.6k14 gold badges141 silver badges190 bronze badges

Comments

ltd9938 · Accepted Answer · 2018-01-30 18:38:57Z

1

Cast last_id as an int.

print(t_age/int(last_id))

answered Jan 30, 2018 at 18:38

ltd9938

1,4541 gold badge17 silver badges29 bronze badges

1 Comment

Renan Andrade Over a year ago

With and without the intended solution, this error is now raised: TypeError: int() argument must be a string, a bytes-like object or a number, not '_iLocIndexer'

Renan Andrade · Accepted Answer · 2018-02-01 02:01:07Z

1

I finally got it. I put comments on the code below in case someone is having the same issue and also for possible future reference:

t_age = renda['age'].sum() #gives total age. count() seems to work too
t_age_num = pd.to_numeric(t_age) #assures t_age is numeric
last_id = renda.iloc[-1] #finds the last row 
last_id_num = last_id.name #stores the last row's name

print(t_age_num/last_id_num)

A nice shortcut is:

renda['age'].mean()

edited Feb 1, 2018 at 2:01

answered Feb 1, 2018 at 1:55

Renan Andrade

1891 gold badge2 silver badges11 bronze badges

Collectives™ on Stack Overflow

Convert index number to int (Python)

5 Answers 5

8 Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

8 Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related