How to convert a series of one value to float only?

Question

I have a series which has only one value and i want to get that value only. I ran a code to get t he value by index matching and i got a series like this:

(normal_sum['KWH'][(normal_sum['KWH'].index == date)])

Timestamp
2017-04-02    2934.93
Freq: D, Name: KWH, dtype: float64

But when i tried to convert it into a float by this:

float(normal_sum['KWH'][(normal_sum['KWH'].index == date)])

It is throwing an error:

TypeError: cannot convert the series to <type 'float'>

Expected output: 2934.93

Any help would be appreciated.

There is an edit:

I am facing another problem:

Suppose i get an empty series then how can i convert it to zero.

i did this:

(normal_sum['KWH'][(normal_sum['KWH'].index == date)])

Got a series like this:

Series([], Freq: D, Name: KWH, dtype: float64)

please help.

Answer 1

Use loc

normal_sum.loc[date, 'KWH']

---

See @MaxU's answer for at

---

Also get_value

normal_sum.get_value(date, 'KWH')

---

To return zero when date isn't in the index, you can

normal_sum.KWH.get(date, 0)

Answer 2

we can use Series.at[...] method for scalar lookup:

In [138]: normal_sum = pd.Series([1.234], index=['KWH'])

In [139]: normal_sum
Out[139]:
KWH    1.234
dtype: float64

In [140]: normal_sum.at['KWH']
Out[140]: 1.234