如何处理嵌套数据框

发布于 2025-01-10 22:50:10 字数 1280 浏览 0 评论 0 原文

我在如何获取数据框中每一行的特定值时遇到问题。更准确地说，它是关于变量entities.urls，其值再次由变量

Dataframe

entities.urls 由以下变量组成：start、end、url、expanded_url 和 display_url 等。 entities.url 中的变量：

我需要获取原始数据帧中每一行嵌入在Entity.urls 变量中的expanded_url 变量的第二个条目。给你一些背景信息：我想获取每条推文的扩展网址。

我还没有找到任何方法来解决这个问题，我将非常感谢任何帮助。

我的数据框的结构如下：

glimpse(data2)

[Output]: 
Rows: 66
Columns: 28
$ entities.urls                  <list> [<data.frame[2 x 5]>], [<data.frame[2 x 5]>], [<data.fram~
$ id                             <chr> "1498290646406340615", "1498234776737792000", "14982113720~ ....

Entity.urls 数据框由以下内容组成：

str(entities_urls)

[Output]
List of 66
 $ :'data.frame':   2 obs. of  5 variables:
  ..$ start       : int [1:2] 240 264
  ..$ end         : int [1:2] 263 287
  ..$ url         : chr [1:2] "shortened url not allowed" "shortened url not allowed"
  ..$ expanded_url: chr [1:2] "shortened url not allowed" **"https://twitter.com/Agilent/status/1498290646406340615/photo/1**"
  ..$ display_url : chr [1:2] "bit.ly/3qDpMxH" "pic.twitter.com/Re4DtJ7U2z"

原文

I am having a problem on how to get a certain value for each row in my dataframe. More precisely, it is about the variable entities.urls whose values again consist of variables

Dataframe

entities.urls consists of the following variables: start, end, url, expanded_url and display_url etc. Variables within entities.url:

I need to get the second entry of the expanded_url variable that is embedded in the entities.urls variable for each row in my original dataframe. To give you some context: I want to get the expanded url for each tweet.

I have not figured out any way to solve this issue and I would highly appreciate any help.

The structure of my dataframe is the following:

glimpse(data2)

[Output]: 
Rows: 66
Columns: 28
$ entities.urls                  <list> [<data.frame[2 x 5]>], [<data.frame[2 x 5]>], [<data.fram~
$ id                             <chr> "1498290646406340615", "1498234776737792000", "14982113720~ ....

The entities.urls dataframe consists of the following:

str(entities_urls)

[Output]
List of 66
 $ :'data.frame':   2 obs. of  5 variables:
  ..$ start       : int [1:2] 240 264
  ..$ end         : int [1:2] 263 287
  ..$ url         : chr [1:2] "shortened url not allowed" "shortened url not allowed"
  ..$ expanded_url: chr [1:2] "shortened url not allowed" **"https://twitter.com/Agilent/status/1498290646406340615/photo/1**"
  ..$ display_url : chr [1:2] "bit.ly/3qDpMxH" "pic.twitter.com/Re4DtJ7U2z"

分享到QQ

分享到微博