URL as a column about academictwitter HOT 4 CLOSED

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.

from academictwitter.

@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?

from academictwitter.

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

from academictwitter.

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

from academictwitter.