'DataFrame' object has no attribute 'string_column'

Question

I am trying to count the delimiter from my CSV file using this piece of code:

import pandas as pd

df = pd.read_csv(path,sep=',')
df['comma_count'] = df.string_column.str.count(',')
print (df)

But I keep getting this error: 'DataFrame' object has no attribute 'string_column'. Trying to iterate through my dataframe had no avail.

I am trying to achieve this:

     id    val      new  comma_count
     id    val      new          2
0     a    2.0    234.0          2
1     a    5.0    432.0          2
2     a    4.0    234.0          2
3     a    2.0  23423.0          2
4     a    9.0    324.0          2
5     a    7.0      NaN          1
6   NaN  234.0      NaN          1
7     a    6.0      NaN          1
8     4    NaN      NaN          0

My file:

id,val,new
a,2,234
a,5,432
a,4,234
a,2,23423
a,9,324
a,7
,234
a,6,
4

Waht is print (df.columns) ? Error means there is no column string_column — jezrael
– jezrael, Commented Jun 17, 2021 at 11:55
Index(['id', 'val', 'new'], dtype='object') I am trying to count the delimiter over all columns (id, val and new) — Oliveira
– Oliveira, Commented Jun 17, 2021 at 11:58
well, you have 3 delimiters per row that are used to create your column with the sep=',' — nidabdella
– nidabdella, Commented Jun 17, 2021 at 11:59

jezrael · Accepted Answer · 2021-06-17 12:43:25Z

1

Use different separator with select first column and count:

df1 = pd.read_csv(path,sep='|')
df['dot_count'] = df1.iloc[:, 0].str.count(',')

edited Jun 17, 2021 at 12:43

answered Jun 17, 2021 at 11:59

jezrael

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

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

7 Comments

Oliveira Over a year ago

My output is not showing the count (It`s just 0 for all lines). Also, I want to count the delimiters in my header too.

jezrael Over a year ago

@Oliveira - Can you add small data sample with exepected ouput to question?

jezrael Over a year ago

@Oliveira - so need count dot ? Not comma? also why in first row are 2?

Oliveira Over a year ago

added a sample of my file. its comma. sorry

Oliveira Over a year ago

comma count still 0 though

|

Collectives™ on Stack Overflow

'DataFrame' object has no attribute 'string_column'

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related