Using Python DataFrame trying to extract all rows for columns starting with a certain number

Question

The code below doesn't work because AttributeError: 'Series' object has no attribute 'startswith'. How do I do get this code to work?

#Starts with account num and negative
negExpense = (df.Amount < float(0)) & \
            (df.loc[df['Account'].startswith(5)])
print(negExpense)
debits.to_excel(writer, 'Negative Expense')

its [pandas.Series.str.startswith](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.startswith.html) — Shijith, Dec 31 '19 at 07:05

score 0 · Answer 1 · answered Dec 31 '19 at 07:05

0

Try using Pandasql to use reg-exp. You can manipulate your dataframe using pandasql library and replacing the earlier df with new_df.

answered Dec 31 '19 at 07:05

saurabh deosarkar

9
1

score 0 · Answer 2 · answered Dec 31 '19 at 07:06

0

You can use df.str.startswith(5) instead of just startswith.

This link will help you out for further info - pandas select from Dataframe using startswith

answered Dec 31 '19 at 07:06

mohammed_ayaz

620
11
16

Gives me this: AttributeError: Can only use .str accessor with string values! – ShreddedScientist Jan 19 '20 at 04:46
@ShreddedScientist can you try converting the field to string by str() and the apply .str function? – mohammed_ayaz Jan 20 '20 at 06:13

Using Python DataFrame trying to extract all rows for columns starting with a certain number

2 Answers2