Is that any way that I can get first element of Seires without have information on index.
For example,We have a Series
import pandas as pd key='MCS096' SUBJECTS=pd.DataFrame({'ID':Series([146],index=[145]),\ 'study':Series(['MCS'],index=[145]),\ 'center':Series(['Mag'],index=[145]),\ 'initials':Series(['MCS096'],index=[145]) })
prints out SUBJECTS:
print (SUBJECTS[SUBJECTS.initials==key]['ID']) 145 146 Name: ID, dtype: int64
How can I get the value here 146 without using index 145?
Thank you very much
Accessing the First Element The first element is at the index 0 position. So it is accessed by mentioning the index value in the series. We can use both 0 or the custom index to fetch the value.
Pandas DataFrame first() Method The first() method returns the first n rows, based on the specified value. The index have to be dates for this method to work as expected.
Use iloc to access by position (rather than label):
In [11]: df = pd.DataFrame([[1, 2], [3, 4]], ['a', 'b'], ['A', 'B']) In [12]: df Out[12]: A B a 1 2 b 3 4 In [13]: df.iloc[0] # first row in a DataFrame Out[13]: A 1 B 2 Name: a, dtype: int64 In [14]: df['A'].iloc[0] # first item in a Series (Column) Out[14]: 1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With