This is kind of an update to my previous post. I played a little more with the Instagram data. Similar to previous post, first of all we need data.
I downloaded the newest 5000 posts tagged with fountainpen. The following are the data column names.
We can duplicate data frame since it takes some time to download. It’s better to keep the original data while playing on data so you don’t mess up and download it again and again.
As seen from the colnames above we have lots of useful information in the data set. Let’s get the number of counts of images and videos in the latest 5000 posts.
Apparently, fpgeeks like pictures more than videos. There are 4940 images and 60 videos posted.
We can also count the filters used and find the favorite filter of fpgeeks.
Results show that the favorite filter is Normal. We can create a plot of filters.
Here is the plot of filters used. I removed Normal since it was huge compared to others.
We can also check the most liked post and the user that posted it.
Our most liked post is from @serrose and it is this one.
Similarly we can find the most commented post and the user posted it.
Our most commented post is from @gouletpens and it is this one.
In my previous post, I was searching for brand tags individually and this was creating some problems for brand comparisons. This time I only used the hashtags that fpgeeks used. I extracted the tags from the picture captions, combined, and ordered them.
This data show us that the most widely used tags with fountainpen tag. We can plot the data with the following command.
Here is the graph. There are some Chinese and Japanese tags which don’t show up in the graph. I didn’t try to fix those.
As seen from the graph, fpgeeks mostly use ink, pen, and lamy tags. So - probably, if I didn’t make any coding errors - the favorite brand of fountain pen community on Instagram is LAMY.