The error message means that the dataframe contains blank entries that default to na/NaN.
You can just add na=False in the synatx to fill value for missing values.
import csv
import os
import pandas as pd
os.chdir('C:\\Users\\khalha\\Desktop\\RealExcel')
filename = 'sales.csv'
Sales = pd.read_csv('sales.csv')
iFlowStatus = Sales[Sales['Product'].str.contains('iFlow', na=False)]['Status']
print(iFlowStatus)
Related Posts:
- IndexError: too many indices for array
- TypeError: list indices must be integers or slices, not str
- Does Python have a string ‘contains’ substring method?
- IndexError: too many indices for array
- IndexError: too many indices for array
- TypeError: a bytes-like object is required, not ‘str’ when writing to a file in Python3
- Writing a pandas DataFrame to CSV file
- Best way to convert string to bytes in Python 3?
- Pythonic way to create a long multi-line string
- Does Python have a string ‘contains’ substring method?
- TypeError: not all arguments converted during string formatting python
- ‘str’ object does not support item assignment
- How do I append one string to another in Python?
- Random string generation with upper case letters and digits
- Convert bytes to a string
- ValueError : I/O operation on closed file
- How to read a text file into a string variable and strip newlines?
- Python convert tuple to string
- Split a string into 2 in Python
- Best way to strip punctuation from a string
- How to check if the string is empty?
- How do I convert a list of ascii values to a string in python?
- Python TypeError: not enough arguments for format string
- How to add a string in a certain position?
- This can be done without regex:
- Python Error io.UnsupportedOperation: not readable
- How can I concatenate str and int objects?
- What does the ‘b’ character do in front of a string literal?
- Best way to replace multiple characters in a string?
- load csv into 2D matrix with numpy for plotting
- Convert columns to string in Pandas
- Dump a NumPy array into a csv file
- (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
- How to delete a character from a string using Python
- Remove the first character of a string
- Quoting backslashes in Python string literals
- Python string class like StringBuilder in C#?
- How to load a tsv file into a Pandas DataFrame?
- AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
- Difference between writerow() and writerows() methods of Python csv module
- Create a .csv file with values from a Python list
- Convert XML to CSV file
- Remove all special characters, punctuation and spaces from string
- How to check if a string is a substring of items in a list of strings?
- Best way to replace multiple characters in a string?
- How can I splice a string?
- Detect whether a Python string is a number or a letter
- Finding all possible permutations of a given string in python
- How do I append one string to another in Python?
- AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
- How can I open an Excel file in Python?
- How to convert string to binary?
- Converting from a string to boolean in Python?
- How to check if type of a variable is string?
- How do I format a string using a dictionary in python-3.x?
- Creating a dictionary from a csv file?
- Removing numbers from string
- How do I check if there are duplicates in a flat list?
- How to find char in string and get all the indexes?
- How can I print variable and string on same line in Python?
- Remove quotes from String in Python
- Convert hex string to int in Python
- How can I check if character in a string is a letter? (Python)
- How can I check if character in a string is a letter? (Python)
- OSError: Initializing from file failed on csv in Pandas
- ImportError: No module named win32com.client
- How to concatenate items in a list to a single string?
- AttributeError: ‘list’ object has no attribute ‘lower’ gensim
- Find the nth occurrence of substring in a string
- How to convert ‘binary string’ to normal string in Python3?
- Properly formatted multiplication table
- How to get a function name as a string?
- Pandas error “Can only use .str accessor with string values”
- Python: Converting string into decimal number
- Writing a dictionary to a csv file with one line for every ‘key: value’
- How to compare individual characters in two strings in Python 3
- How to repeat a string with spaces?
- Python CSV Error: sequence expected
- How to pad zeroes to a string?
- AttributeError: ‘float’ object has no attribute ‘split’4
- How to add pandas data to an existing csv file?
- How do I convert a string to a double in Python?
- _csv.Error: field larger than field limit (131072)
- How can I copy a Python string?
- Split string using a newline delimiter with Python
- Checking if a string can be converted to float in Python
- Remove specific characters from a string in Python
- How to get ° character in a string in python?
- Python cant convert ‘list’ object to str error [closed]
- Mutable strings in Python
- Writing Python lists to columns in csv
- How can I check if a string contains ANY letters from the alphabet?
- Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
- How to read a CSV file from a URL with Python?
- Find index of last occurrence of a substring in a string
- When to use %r instead of %s in Python? [duplicate]
- Python convert tuple to string
- Python – difference between two strings
- How to import a csv-file into a data array?
- TypeError: coercing to Unicode: need string or buffer