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. TypeError: only integer scalar arrays can be converted to a scalar index with 1D numpy indices array
  11. How to install pip with Python 3?
  12. Import Error: No module named numpy
  13. How to deal with SettingWithCopyWarning in Pandas
  14. How to deal with SettingWithCopyWarning in Pandas
  15. How to iterate over rows in a DataFrame in Pandas
  16. TypeError: a bytes-like object is required, not ‘str’ when writing to a file in Python3
  17. Writing a pandas DataFrame to CSV file
  18. Relative imports in Python 3
  19. Best way to convert string to bytes in Python 3?
  20. TypeError: not all arguments converted during string formatting python
  21. ImportError: No module named pandas
  22. How to change the order of DataFrame columns?
  23. ImportError: No module named pandas. Pandas installed pip
  24. Using Python 3 in virtualenv
  25. “Series objects are mutable and cannot be hashed” error
  26. Local variable referenced before assignment?
  27. re.sub erroring with “Expected string or bytes-like object”
  28. How do I select rows from a DataFrame based on column values?
  29. DataFrame constructor not properly called! error
  30. AttributeError: ‘module’ object has no attribute ‘urlopen’
  31. Pandas group-by and sum
  32. Python pandas groupby aggregate on multiple columns, then pivot
  33. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  34. ‘method’ object is not subscriptable. Don’t know what’s wrong
  35. Python Pandas – Missing required dependencies [‘numpy’] 1
  36. error UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xff in position 0: invalid start byte
  37. Error: ” ‘dict’ object has no attribute ‘iteritems’ “
  38. pandas DataFrame “no numeric data to plot” error
  39. How to upgrade pip3?
  40. TypeError: Missing 1 required positional argument: ‘self’
  41. What is __pycache__?
  42. TypeError: can’t use a string pattern on a bytes-like object in re.findall()
  43. How to pass arguments to a Button command in Tkinter?
  44. How to remove specific substrings from a set of strings in Python?
  45. Get total of Pandas column
  46. Change figure size and figure format in matplotlib
  47. How can I concatenate str and int objects?
  48. error: Failed to load the native TensorFlow runtime
  49. ImportError: No module named ‘encodings’
  50. How to check whether a pandas DataFrame is empty?
  51. Convert columns to string in Pandas
  52. Shuffle DataFrame rows
  53. enumerate() for dictionary in python
  54. How to load a tsv file into a Pandas DataFrame?
  55. Converting between datetime and Pandas Timestamp objects
  56. Creating a Pandas DataFrame from a Numpy array: How do I specify the index column and column headers?
  57. Convert pandas data frame to series
  58. Converting int to bytes in Python 3
  59. How can I install Python’s pip3 on my Mac?
  60. How to get the current working directory using python 3?
  61. min() arg is an empty sequence
  62. Get first row value of a given column
  63. How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
  64. What is the meaning of ‘for _ in range()
  65. SettingWithCopyWarning even when using .loc[row_indexer,col_indexer] = value
  66. Python sockets error TypeError: a bytes-like object is required, not ‘str’ with send function
  67. Pipenv: Command Not Found
  68. Python: AttributeError: ‘_io.TextIOWrapper’ object has no attribute ‘split’
  69. OSError: Initializing from file failed on csv in Pandas
  70. Pip – Fatal error in launcher: Unable to create process using ‘”‘
  71. Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
  72. AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas
  73. Python Pandas ValueError Arrays Must be All Same Length
  74. ImportError: No module named ‘yaml’
  75. TypeError: ‘_io.TextIOWrapper’ object is not subscriptable
  76. How to print multiple lines of text with Python
  77. How to compare individual characters in two strings in Python 3
  78. Plotting multiple lines, in different colors, with pandas dataframe
  79. How do I run pip on python for windows?
  80. TypeError: cannot concatenate a non-NDFrame object
  81. Rename specific column(s) in pandas
  82. What does {0} mean in this Python string?
  83. Tab Error in Python
  84. Python 3.5.1 urllib has no attribute request
  85. python pandas remove duplicate columns
  86. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  87. Why do I get this error “TypeError: ‘method’ object is not iterable”?
  88. What is the purpose of dollar sign in this Python3 string formatting expression?
  89. What is the meaning of “int(a[::-1])” in Python?
  90. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  91. Python: Convert timedelta to int in a dataframe
  92. Calculate weighted average using a pandas/dataframe
  93. Got continuous is not supported error in RandomForestRegressor
  94. Getting a name error when trying to input a string [duplicate]
  95. How to install NumPy for Python 3.6
  96. ValueError: multiclass format is not supported
  97. Error loading MySQLdb module: No module named ‘MySQLdb’
  98. Undefined variable error in function
  99. Python 3 integer division [duplicate]
  100. Python – difference between two strings

Leave a Comment