CODEWITHSUNDEEP
pandasdataframe
ANum
ANum

Reputation: 117

How would I access individual elements of this pandas dataFrame?

How would I access the individual elements of the dataFrame below?

More specifically, how would I retrieve/extract the string "CN112396173" in the index 2 of the dataFrame?

enter image description here

Thanks

Upvotes: 0

Views: 234

Answers (1)

kuropan
kuropan

Reputation: 896

A more accurate description of your problem would be: "Getting all first words of string column in pandas"

You can use data["PN"].str.split(expand=True)[0]. See the docs.

>>> import pandas as pd
>>> df = pd.DataFrame({"column": ["asdf abc cdf"]})
>>> series = df["column"].str.split(expand=True)[0]
>>> series
0    asdf
Name: 0, dtype: object
>>> series.to_list()
["asdf"]

dtype: object is actually normal (in pandas, strings are 'objects').

Upvotes: 1

Related Questions