Argument is not numeric or logical: returning NAargument is not numeric or logical in R

Question

So I am using this code below. maindata is a table of players, their home towns, and their points per game. I am trying to make a new table that has the cities in one column, and the average points per game in the second (as shown in table A). I keep getting a table with the cities listed and the rows for AvgPoints all showing NA. I get this error "argument is not numeric or logical: returning NAargument is not numeric or logical", and it repeats itself hundreds of times. Main data has 3561 observations.

point <- maindata%>%
  group_by(City, State) %>%
    summarise(AvgPoints = mean(PTS.1, na.rm = TRUE))

Table A

   City            AvgPoints
----------------------------
New York City        19.9
Los Angeles          22.1
Boston               13.3

Answer 1

We convert the column to numeric first if it is not numeric and then do the group by operation

library(dplyr)
maindata %>%
      mutate(PTS.1 = as.numeric(as.character(PTS.1))) %>%
      group_by(City, State) %>%
      summarise(AvgPoints = mean(PTS.1, na.rm = TRUE), .groups = 'drop')