URL as a column

[husainakareem]

Describe the solution you'd like

I've been trying to get the URL column that I can use to retrieve media files (image, video, GIF, etc.) attached to the tweets. There is a column (expanded_url) hidden in the 'entities.urls' column. Often it contains multiple rows (a large list when separated from the downloaded dataframe), which created issues with I tried to convert it into a dataframe and attach it to the original dataframe. It'll be a lot simpler if there is a dedicated column representing the tweet URL.

Thank you.

Anything else?

No response

[cssetupman]

I've been trying the similar things. Couldn't find the solutions yet.

1. There are multiple variables hidden in the 'entities.urls' column and 'referened_tweets' column. I wonder how I can convert them into separate individual columns. See below.
   

2. I use "write_xlsx". Some columns in data frame didn't transfer to the excel file. For example, "public metrics.retweet_count" didn't transfer to the excel file.
   Thank you for your help.

[cssetupman]

@cjbarrie I am sorry to call you here. I haven't solved the issue yet. Could you take a look the issue above? When I open .RData file, I can see multiple variables hidden in a column. When I export it into excel or csv, I can't find the multiple variables. How can I convert those hidden variables into an excel file?

[cjbarrie]

Hi @cssetupman, are you binding the data using bind_tweets()? See here. Please follow advice of providing reprex aso we can properly comment

[cssetupman]

@cjbarrie Thank you so much. The document helps a lot. Now I can see 30 columns including URLs.