Btukfyl

name,age

something

tom,20

df = pd.read_csv('file', header=None)



     0           1

1    name        age

2    something   NaN

3    tom         20

# in pseudocode

df['_count_separators'] = len(df.raw_value.count(','))



     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

name,age

something

tom,20

df = pd.read_csv('file', header=None)



     0           1

1    name        age

2    something   NaN

3    tom         20

# in pseudocode

df['_count_separators'] = len(df.raw_value.count(','))



     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

name,age

something

tom,20

df = pd.read_csv('file', header=None)



     0           1

1    name        age

2    something   NaN

3    tom         20

# in pseudocode

df['_count_separators'] = len(df.raw_value.count(','))



     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

name,age

something

tom,20

df = pd.read_csv('file', header=None)



     0           1

1    name        age

2    something   NaN

3    tom         20

# in pseudocode

df['_count_separators'] = len(df.raw_value.count(','))



     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

active

oldest

votes

df = pd.read_csv('file', header=None)

df2 = pd.read_csv('file', header=None,sep='|') # using another sep for read your csv again 



df2['0'].str.findall(',').str.len() # then one row into one cell , using str find 

0    1

1    0

2    1

3    5

Name: 0, dtype: int64



df['_count_separators']=df2['0'].str.findall(',').str.len()

name,age

something

tom,20

something,,,,,somethingelse

df = pd.read_csv('file', header=None)

df2 = pd.read_csv('file', header=None,sep='|') # using another sep for read your csv again 



df2['0'].str.findall(',').str.len() # then one row into one cell , using str find 

0    1

1    0

2    1

3    5

Name: 0, dtype: int64



df['_count_separators']=df2['0'].str.findall(',').str.len()

name,age

something

tom,20

something,,,,,somethingelse

df = pd.read_csv('file', header=None)

df2 = pd.read_csv('file', header=None,sep='|') # using another sep for read your csv again 



df2['0'].str.findall(',').str.len() # then one row into one cell , using str find 

0    1

1    0

2    1

3    5

Name: 0, dtype: int64



df['_count_separators']=df2['0'].str.findall(',').str.len()

name,age

something

tom,20

something,,,,,somethingelse

df = pd.read_csv('file', header=None)

df2 = pd.read_csv('file', header=None,sep='|') # using another sep for read your csv again 



df2['0'].str.findall(',').str.len() # then one row into one cell , using str find 

0    1

1    0

2    1

3    5

Name: 0, dtype: int64



df['_count_separators']=df2['0'].str.findall(',').str.len()

name,age

something

tom,20

something,,,,,somethingelse

add a comment | 

# s = pd.read_csv(pd.compat.StringIO(text), sep=r'|', squeeze=True, header=None)

s = pd.read_csv('/path/to/file.csv', sep=r'|', squeeze=True, header=None)

df = pd.concat([

       s.str.split(',', expand=True), 

       s.str.count(',').rename('_count_sep')

    ], axis=1)



df

           0     1  _count_sep

0       name   age           1

1  something  None           0

2        tom    20           1

# s = pd.read_csv(pd.compat.StringIO(text), sep=r'|', squeeze=True, header=None)

s = pd.read_csv('/path/to/file.csv', sep=r'|', squeeze=True, header=None)

df = pd.concat([

       s.str.split(',', expand=True), 

       s.str.count(',').rename('_count_sep')

    ], axis=1)



df

           0     1  _count_sep

0       name   age           1

1  something  None           0

2        tom    20           1

# s = pd.read_csv(pd.compat.StringIO(text), sep=r'|', squeeze=True, header=None)

s = pd.read_csv('/path/to/file.csv', sep=r'|', squeeze=True, header=None)

df = pd.concat([

       s.str.split(',', expand=True), 

       s.str.count(',').rename('_count_sep')

    ], axis=1)



df

           0     1  _count_sep

0       name   age           1

1  something  None           0

2        tom    20           1

# s = pd.read_csv(pd.compat.StringIO(text), sep=r'|', squeeze=True, header=None)

s = pd.read_csv('/path/to/file.csv', sep=r'|', squeeze=True, header=None)

df = pd.concat([

       s.str.split(',', expand=True), 

       s.str.count(',').rename('_count_sep')

    ], axis=1)



df

           0     1  _count_sep

0       name   age           1

1  something  None           0

2        tom    20           1

add a comment | 

df = pd.read_csv('file', header=None)

df['_count_separators'] = df.count(axis='columns')

print(df)

output: 

     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

df = pd.read_csv('file', header=None)

df['_count_separators'] = df.count(axis='columns')

print(df)

output: 

     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

df = pd.read_csv('file', header=None)

df['_count_separators'] = df.count(axis='columns')

print(df)

output: 

     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

df = pd.read_csv('file', header=None)

df['_count_separators'] = df.count(axis='columns')

print(df)

output: 

     0           1      _count_separators

1    name        age   1

2    something   NaN   0

3    tom         20    1

add a comment | 

add a comment |