Type error: cannot convert the series to

The problem is quite trivial,

  1. You’re using a Pandas.DataFrame. Now when you slice it rep_points['lat'], you get a Pandas.Series.
  2. The gmplot.scatter() is expecting an iterable of floats not a series of floats.
  3. Now if you convert your Pandas.Series to a list by using rep_points['lat'].tolist() It’ll start working

Below is your updated code:

rep_points = pd.read_csv(r'C:\Users\carrot\Desktop\ss.csv', dtype=float)
latitude_collection = rep_points['lat'].tolist()
longitude_collection = rep_points['long'].tolist()

gmap = gmplot.GoogleMapPlotter(latitude_collection[0], longitude_collection[0], 11)
gmap.plot(min(latitude_collection), min(longitude_collection).lng)
gmap.scatter(latitude_collection,longitude_collection,c='aquamarine')
gmap.circle(latitude_collection,longitude_collection, 100, color='yellow')  
gmap.draw("user001_clus_time.html")

Other things that helped to point it out:

  1. type(rep_points['lat']) is a Pandas.Series
  2. type(rep_points['lat'][0]) is a Numpy.Float
  3. to iterate over a Pandas.Series you need to use iteritems

Related Posts:

  1. pandas: merge (join) two data frames on multiple columns
  2. How to Read .txt in Pandas
  3. JSON to pandas DataFrame
  4. AttributeError: ‘Series’ object has no attribute ‘reshape’
  5. ImportError: No module named ‘xlrd’
  6. Moving Average Pandas
  7. matplotlib: plot multiple columns of pandas data frame on the bar chart
  8. How to print a specific row of a pandas DataFrame?
  9. SyntaxError: unexpected EOF while parsing
  10. How to use filter, map, and reduce in Python 3
  11. Use Gif Logo For Loading Screen In Kivy
  12. Praw & Discord.py: The bot keep sending the same meme. I want the bot to send different meme whenever it is asked
  13. How can I make a time delay in Python? [duplicate]
  14. Python – TypeError: ‘int’ object is not iterable
  15. how to sort pandas dataframe from one column
  16. TypeError: only integer scalar arrays can be converted to a scalar index with 1D numpy indices array
  17. How to open a file using the open with statement
  18. Microsoft Visual C++ 14.0 is required (Unable to find vcvarsall.bat)
  19. How to install pip with Python 3?
  20. What is the difference between rw+ and r+
  21. Renaming column names in Pandas
  22. How to reset index in a pandas dataframe? [duplicate]
  23. Delete a column from a Pandas DataFrame
  24. Python – TypeError: ‘int’ object is not iterable
  25. Import Error: No module named numpy
  26. How to deal with SettingWithCopyWarning in Pandas
  27. How to deal with SettingWithCopyWarning in Pandas
  28. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  29. How to iterate over rows in a DataFrame in Pandas
  30. pandas read_json: “If using all scalar values, you must pass an index”
  31. How to iterate over rows in a DataFrame in Pandas
  32. Python: ‘ModuleNotFoundError’ when trying to import module from imported package
  33. Relative imports – ModuleNotFoundError: No module named x
  34. TypeError: a bytes-like object is required, not ‘str’ when writing to a file in Python3
  35. Writing a pandas DataFrame to CSV file
  36. How to uninstall a package installed with pip install –user
  37. Relative imports in Python 3
  38. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  39. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  40. Writing a pandas DataFrame to CSV file
  41. Best way to convert string to bytes in Python 3?
  42. Best way to convert string to bytes in Python 3?
  43. What does the list() function do in Python?
  44. TypeError: not all arguments converted during string formatting python
  45. Adding new column to existing DataFrame in Python pandas
  46. Modifing data while using iterrows() does not work
  47. PermissionError: [Errno 13] Permission denied
  48. ImportError: No module named pandas
  49. What is setup.py?
  50. How is Anaconda related to Python?
  51. How to change the order of DataFrame columns?
  52. FileNotFoundError: [WinError 2] The system cannot find the file specified:
  53. How to change the order of DataFrame columns?
  54. Invalid character in identifier
  55. ImportError: No module named pandas. Pandas installed pip
  56. What does `ValueError: cannot reindex from a duplicate axis` mean?
  57. Pandas DataFrame Groupby two columns and get counts
  58. How can I use the apply() function for a single column?
  59. How to show all columns’ names on a large pandas dataframe?
  60. Convenient way to deal with ValueError: cannot reindex from a duplicate axis
  61. ValueError: Unknown label type: ‘continuous’
  62. How to groupby based on two columns in pandas?
  63. Using Python 3 in virtualenv
  64. How to fix IndexError: invalid index to scalar variable
  65. How to correct TypeError: Unicode-objects must be encoded before hashing?
  66. “Series objects are mutable and cannot be hashed” error
  67. How to remove EOFError: EOF when reading a line?
  68. How to deal with SettingWithCopyWarning in Pandas
  69. WinError 2 The system cannot find the file specified (Python)
  70. Merging dataframes on index with pandas
  71. ImportError: No module named pandas
  72. hashlib.md5() TypeError: Unicode-objects must be encoded before hashing
  73. TypeError: ‘Series’ objects are mutable, thus they cannot be hashed problemwith column
  74. TypeError: cannot unpack non-iterable NoneType object
  75. Is there a ‘foreach’ function in Python 3?
  76. Create a Pandas Dataframe by appending one row at a time
  77. Python inline if statement
  78. How to install python3 version of package via pip on Ubuntu?
  79. Updating a dictionary in python
  80. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  81. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  82. Could not find a version that satisfies the requirement tensorflow
  83. Convert bytes to a string
  84. How to copy a dictionary and only edit the copy
  85. Convert Python dict into a dataframe
  86. How to print like printf in Python3?
  87. Could not find a version that satisfies the requirement tensorflow
  88. Local variable referenced before assignment?
  89. re.sub erroring with “Expected string or bytes-like object”
  90. Creating an empty Pandas DataFrame, then filling it?
  91. How do I select rows from a DataFrame based on column values?
  92. How do I select rows from a DataFrame based on column values?
  93. DataFrame constructor not properly called! error
  94. AttributeError: ‘module’ object has no attribute ‘urlopen’
  95. Pandas group-by and sum
  96. How do I get the row count of a Pandas DataFrame?
  97. Python pandas groupby aggregate on multiple columns, then pivot
  98. Python Error: AttributeError: __enter__ [duplicate]
  99. Python Pandas Counting the Occurrences of a Specific value
  100. Convert pandas dataframe to NumPy array

Leave a Comment