How to extract values from pandas Series without index

Question

I have the following when I print my data structure:

print(speed_tf)

44.0   -24.4
45.0   -12.2
46.0   -12.2
47.0   -12.2
48.0   -12.2
Name: Speed, dtype: float64

I believe this is a pandas Series but not sure

I do not want the first column at all I just want

-24.4
-12.2
-12.2
-12.2
-12.2

I tried speed_tf.reset_index()

  index  Speed
0 44.0   -24.4
1 45.0   -12.2
2 46.0   -12.2
3 47.0   -12.2
4 48.0   -12.2

How can I just get the Speed values with index starting at 0?

From your last line, you can go one more step: speed_tf.reset_index()["Speed"]... though I bet there's a nicer way. — Mateen Ulhaq
– Mateen Ulhaq, Commented May 29, 2020 at 13:07
"I believe this is a pandas Series but not sure" It's always nice to be sure. Try: print(type(speed_tf)) — Spike0xff
– Spike0xff, Commented Mar 15, 2022 at 19:06

Igor Rivin · Accepted Answer · 2020-05-29 13:07:56Z

33

speed_tf.values

Should do what you want.

answered May 29, 2020 at 13:07

Igor Rivin

4,8742 gold badges30 silver badges45 bronze badges

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

3 Comments

Cedric Zoppolo Over a year ago

This solution provides a list, whereas the other solution provides a DataFrame.

Igor Rivin Over a year ago

@CedricZoppolo First, this solution provides a numpy array, not a list, but secondly, I am not sure what to make of your comment. Do you view this as a good or a bad thing?

Cedric Zoppolo Over a year ago

You are right. values outputs an array type. I was just pointing out the difference of outputs between these two solutions. I believe none of them is better than the other. It depends on further implementation you may need.

Doc · Accepted Answer · 2023-03-02 19:19:18Z

6

To print only the Speed values, with no indices:

print(speed_tf.to_string(index=False))

edited Mar 2, 2023 at 19:19

answered Oct 1, 2022 at 12:22

Doc

1031 silver badge4 bronze badges

Comments

Shubham Sharma · Accepted Answer · 2020-05-29 13:20:11Z

5

Simply use Series.reset_index and Series.to_frame:

df = speed_tf.reset_index(drop=True).to_frame()

Result:

# print(df)

   Speed
0  -24.4
1  -12.2
2  -12.2
3  -12.2
4  -12.2

edited May 29, 2020 at 13:20

answered May 29, 2020 at 13:14

Shubham Sharma

71.8k6 gold badges26 silver badges58 bronze badges

1 Comment

avigt Feb 21 at 19:59

...what? This still has an index.

arilwan · Accepted Answer · 2023-11-15 17:06:13Z

1

This is for anyone willing to create a dataframe having 2 columns: series indices and series values.

# firstColumnName you choose to give
df = pd.DataFrame({'firstColumnName': speed_tf.index, 'Speed': speed_tf.values})

answered Nov 15, 2023 at 17:06

arilwan

4,1038 gold badges37 silver badges77 bronze badges

Collectives™ on Stack Overflow

How to extract values from pandas Series without index

4 Answers 4

3 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related