AttributeError: ‘float’ object has no attribute ‘split’4

You are right, such errors mostly caused by NaN representing empty cells. It is common to filter out such data, before applying your further operations, using this idiom on your dataframe df:

df_new = df[df['ColumnName'].notnull()]

Alternatively, it may be more handy to use fillna() method to impute (to replace) null values with something default. E.g. all null or NaN‘s can be replaced with the average value for its column

housing['LotArea'] = housing['LotArea'].fillna(housing.mean()['LotArea'])

or can be replaced with a value like empty string “” or another default value

housing['GarageCond']=housing['GarageCond'].fillna("")

Related Posts:

  1. TypeError: list indices must be integers or slices, not str
  2. Writing a pandas DataFrame to CSV file
  3. Writing a pandas DataFrame to CSV file
  4. How can I split and parse a string in Python?
  5. How do I parse a string to a float or int?
  6. How to parse data in JSON format?
  7. IndexError: too many indices for array
  8. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  9. ValueError : I/O operation on closed file
  10. Pandas: ValueError: cannot convert float NaN to integer
  11. csv.Error: iterator should return strings, not bytes
  12. Python – Reading and writing csv files with utf-8 encoding
  13. convert nan value to zero
  14. Python Error io.UnsupportedOperation: not readable
  15. load csv into 2D matrix with numpy for plotting
  16. Dump a NumPy array into a csv file
  17. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  18. How to load a tsv file into a Pandas DataFrame?
  19. Python/Json:Expecting property name enclosed in double quotes
  20. Difference between writerow() and writerows() methods of Python csv module
  21. Create a .csv file with values from a Python list
  22. Convert XML to CSV file
  23. TypeError: list indices must be integers or slices, not str
  24. Convert from CSV to array in Python
  25. ValueError: cannot index with vector containing NA / NaN values
  26. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  27. Creating a dictionary from a csv file?
  28. Python import csv to list
  29. ValueError: x and y must be the same size
  30. OSError: Initializing from file failed on csv in Pandas
  31. append new row to old csv file python
  32. pandas DataFrame: replace nan values with average of columns
  33. Writing a dictionary to a csv file with one line for every ‘key: value’
  34. Python CSV error: line contains NULL byte
  35. Removing nan values from an array
  36. Python CSV Error: sequence expected
  37. How to add pandas data to an existing csv file?
  38. convert csv file to list of dictionaries
  39. _csv.Error: field larger than field limit (131072)
  40. CSV new-line character seen in unquoted field error
  41. Writing Python lists to columns in csv
  42. Python code to remove HTML tags from a string 
  43. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  44. How to read a CSV file from a URL with Python?
  45. How to import a csv-file into a data array?
  46. Why am I seeing “TypeError: string indices must be integers”?
  47. TypeError: only integer scalar arrays can be converted to a scalar index with 1D numpy indices array
  48. How to emulate a do-while loop?
  49. How to prettyprint a JSON file?
  50. How to install pip with Python 3?
  51. pip not recognised as an internal or external command
  52. Import Error: No module named numpy
  53. bash: pip: command not found
  54. Function for Factorial in Python
  55. TypeError: a bytes-like object is required, not ‘str’ when writing to a file in Python3
  56. Local variable referenced before assignment?
  57. Clickable link inside message discord.py
  58. DataFrame constructor not properly called! error
  59. OSError: [WinError 193] %1 is not a valid Win32 application
  60. How to download a file over HTTP?
  61. “ImportError: no module named ‘requests'” after installing with pip
  62. Append integer to beginning of list in Python
  63. Most efficient way to map function over numpy array
  64. List comprehension on a nested list?
  65. Get total of Pandas column
  66. How do you read from stdin?
  67. Union of two lists in Python
  68. Type error: cannot convert the series to
  69. How to deep copy a list?
  70. Pandas – DataFrame object is not callable
  71. Start with pyglet or pygame?
  72. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  73. Python error load JSON code of google API
  74. Convert categorical data in pandas dataframe
  75. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  76. Truncate to three decimals in Python
  77. Scatter plot colorbar – Matplotlib
  78. “SyntaxError: non-keyword arg after keyword arg” Error in Python when using requests.post()
  79. Flask Error: “Method Not Allowed The method is not allowed for the requested URL”
  80. Pandas error “Can only use .str accessor with string values”
  81. matplotlib: how to draw a rectangle on image
  82. How to install PyGame on Python 3.4?
  83. ImportError: No module named ‘cv2’ Python3
  84. bbox_to_anchor and loc in matplotlib
  85. Python 3.5.1 urllib has no attribute request
  86. Rotating a two-dimensional array in Python
  87. TypeError: sequence item 0: expected string, int found
  88. Why am I getting this unexpected keyword argument TypeError?
  89. Create numpy matrix filled with NaNs
  90. python pandas remove duplicate columns
  91. What is the difference between __str__ and __repr__?
  92. cmake error ‘the source does not appear to contain CMakeLists.txt’
  93. ubuntu /usr/bin/env: python: No such file or directory
  94. How to completely uninstall python 2.7.13 on Ubuntu 16.04
  95. Calculate weighted average using a pandas/dataframe
  96. Telling Python to save a .txt file to a certain directory on Windows and Mac
  97. Write a program that asks the user to enter five test scores. Correspond it to a letter grade
  98. Simplify Chained Comparison
  99. How to get POSTed JSON in Flask?
  100. How to fix SSL issue SSL_CTX_use_certificate : ca md too weak on Python Zeep

Leave a Comment