时间戳

首页 > 解决方案 > 导出到 CSV 时，stream-delim 出错

r - 导出到 CSV 时，stream-delim 出错

问题描述

我正在尝试将此 StatsBomb 数据写入 CSV，但我不断收到以下错误消息：

Error in stream_delim_(df, path, ..., bom = bom, quote_escape = quote_escape) : Don't know how to handle vector of type list.

我迷路了（尝试了多种方法），不确定我在这里做错了什么。这里有没有人知道如何解决这个问题？我在下面包含了我的代码。

library(StatsBombR)
library(tidyverse)

### Read in all free events and matches from the FAWSL
data <- StatsBombFreeEvents()
matches <- FreeMatches(Competitions = 72)

### Clean and separate all data loaded above
dataclean <- allclean(data)

### Filter event data to include only FAWSL data.
data1 <- dataclean %>% 
  filter(dataclean$competition_id == 72) 

### Join event and match data by "match_id"
data1 <- left_join(data1, matches, by = "match_id")


FullData <- data1 %>% 
  select(-c(related_events, tactics.lineup, shot.freeze_frame, location, pass.end_location, shot.end_location, goalkeeper.end_location))

setwd()
write_csv(FullData, "StatsBomb_FullData.csv")

标签： rcsv

解决方案

我有同样的问题。取消列出固定我的列。

df$listcolumn <- sapply(df$listcolumn, function(x) paste0(unlist(x), collapse = "\n"))

推荐阅读