Column count doesn't match value count at row 1 code example

Example 1: 'Column count doesn't match value count at row 1

-- The error means that you are providing not as much data as the table wp_posts does contain 
-- columns. And now the DB engine does not know in which columns to put your data.
-- To overcome this you must provide the names of the columns you want to fill. Example:

insert into wp_posts (column_name1, column_name2)
values (1, 3)

Example 2: pandas count occurrences of certain value in row

print df
  col1 education
0    a       9th
1    b       9th
2    c       8th

print df.education == '9th'
0     True
1     True
2    False
Name: education, dtype: bool

print df[df.education == '9th']
  col1 education
0    a       9th
1    b       9th

print df[df.education == '9th'].shape[0]
2
print len(df[df['education'] == '9th'])
2

Example 3: Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"

In your database table not null columns created are less than the values that
you are passing in the insert query

Example : Assume Your database table has 35 columns
Then,
Where as the values you are passing are 34 columns

This mismatch of columns is giving you the error.
You must have forgot to pass the value for not null column. once you pass 
it error will be resolved