convert series to list in python

Question

here is my s, first column is my INDEX(I replace index with column ) not column and second is column

s =              value
      time            
12-3 19:60:00   0.42724
22-4 20:30:00   0.58799
52-4 21:50:00   0.64879
62-5 22:10:00   0.64090
62-4 23:20:00   0.75934

type of this s is pandas.core.series.Series now I want to convert it to the list like this -:

[['12-3 19:60:00', 0.42724],
['22-4 20:30:00', 0.58799],
['52-4 21:50:00', 0.64879],
['62-5 22:10:00', 0.64090],
['62-4 23:20:00', 0.75934]]`

i have done this but not directly first i convert it into Dataframe then I applied this-:

s.reset_index().values.tolist()

if I convert it directly it gives me a result like :

 [[Timestamp('12-3 19:60:00'), 0.42724],
 [Timestamp('22-4 20:30:00'), 0.58799]...]

jezrael · Accepted Answer · 2019-02-14 09:23:14Z

4

Convert index to Series first:

s.index = s.index.astype(str)
L = s.reset_index().values.tolist()

Or if dont need modify index of Series:

L = s.rename_axis('a').reset_index().assign(a = lambda x: x.a.astype(str)).values.tolist()

Sample:

print (s)
time
2015-12-03 19:40:00    0.42724
2015-04-22 20:30:00    0.58799
Name: value, dtype: float64

s.index = s.index.astype(str)
L = s.reset_index().values.tolist()
print (L)
[['2015-12-03 19:40:00', 0.42723999999999995], ['2015-04-22 20:30:00', 0.58799]]

L = s.rename_axis('a').reset_index().assign(a = lambda x: x.a.astype(str)).values.tolist()
print (L)
[['2015-12-03 19:40:00', 0.42723999999999995], ['2015-04-22 20:30:00', 0.58799]]

edited Feb 14, 2019 at 9:23

answered Feb 14, 2019 at 9:18

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

convert series to list in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related