Skip to content

Instantly share code, notes, and snippets.

@tanaikech
Created October 7, 2020 04:55
Show Gist options
  • Save tanaikech/fa8e7002678a377748ae35a33fa5b6eb to your computer and use it in GitHub Desktop.
Save tanaikech/fa8e7002678a377748ae35a33fa5b6eb to your computer and use it in GitHub Desktop.
Statistical Analysis of Duplicated Questions for google-apps-script tag in Stackoverflow

Statistical Analysis of Duplicated Questions for google-apps-script tag in Stackoverflow

Introduction

At Stackoverflow, a lot of people post the questions and answer to the questions every day. By this, there are a lot of important information in Stackoverflow. I have already reported "Trend of google-apps-script Tag on Stackoverflow" using the data retrieved from Stackoverflow. Ref. 1 It is found that the important statistical result can be obtained by analyzing the data on Stackoverflow. In this report, I would like to introduce the statistical analysis of duplicated questions for the google-apps-script tag in Stackoverflow. When the duplicated question is analyzed, it is considered that the important issues for users can be known. As the result, it was found that there are the trend that the duplicated questions related to Javascript, Google Spreadsheet , the process cost and the cooperation with HTML and Javascript are posted.

Experimental procedure

When the history of Stackoverflow and Google Apps Script is confirmed, the following list can be shown.

  1. 2008-09-15: Stackoverflow was launched. Ref. 2
  2. 2009-08-19: Google Apps Script was released. Ref. 3
  3. 2011-08-29: Tag of "google-apps-script" was created in Stackoverflow. Ref. 4

This list indicates that the history of Stackoverflow is older than that of Google Apps Script, and also the tag of "google-apps-script" at Stackoverflow is introduced by the Google's official document. This also indicates that a lot of information about the history of Google Apps Script can be obtained from all questions with tag of "google-apps-script" in Stackoverflow.

All questions and the related data can be retrieved by a tag using Stackexchange API. Ref. 5 In this report, "google-apps-script" was used as the base tag. And all duplicated questions including the "google-apps-script" tag were retrieved and statistically analyzed. At Stackoverflow, when the issue of the posted question has already been posted before, it is flagged as the duplicated question by linking to the old questions. When a question is used as the origin of the duplicated question from several newer questions, it is considered that the original question has the important information as the issue that many users have. The data was retrieved from 2008-01-01 to 2020-10-06. At Stackoverflow, users can edit the old questions and answers. So please be careful that the data which introduce in this report is the data when was retrieved. The data used in this report was retrieved at 2020-10-06.

Results and discussions

The duplicated questions including google-apps-script tag are introduced.

Fig. 1. Year vs. number of duplicated questions. This data is at October 6, 2020.


Fig. 2. Year vs. Total questions, answered, solved and closed questions. These all questions include the tag of "google-apps-script" in the tags. This data is at October 6, 2020.


Figure 1 shows years vs. number of duplicated questions. This figure shows that the duplicated questions are increased with year. At Fig. 2, the number of duplicated questions is about 5 % of the total questions. And, when the ratio of increase of posted questions at 2019 and 2020 (at 2020-10-06), the ratio of 2020 is lower than that of 2019. From the changing from 2019 to 2020 at Figs. 1 and 2, it is considered the following 2 points. It indicates that the existing questions are useful for users. And also, it is considered that the result due to the active users at Stackoverflow is included.


Table 1. Table that the number of duplicated questions are summarized. "Number of duplicated questions" means the number which was used as the duplicated question. All data from 2008-01-01 to 2020-10-06 were summarized.

Ranking Number of duplicated questions title
1 10 Google Apps Script to open a URL
1 10 How can I test a trigger function in GAS?
2 9 Google app script timeout ~ 5 minutes?
3 8 Compare two dates with JavaScript
4 7 Long processing time likely due to getValue and cell inserts
4 7 "Sign in with Google temporarily disabled for this app" error when trying to authorize a script
5 6 How to protect the Apps Script code in a Google spreadsheet?
5 6 How do you resolve a "The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues" error
6 5 No permission to call msgBox in Google Apps Scripting
6 5 In javascript == vs =?
6 5 Moving google apps script to v8 file upload stopped working from sidebar
7 4 Refresh data retrieved by a custom function in Google Sheet
7 4 Determining the last row in a single column
7 4 Why do regex constructors need to be double escaped?
7 4 Executing Google Apps Script Functions from Mobile App
7 4 Why do we use SpreadsheetApp.flush();?

From Table 1, it is found that there are the trend that the duplicated questions related to Javascript, Google Spreadsheet , the process cost and the cooperation with HTML and Javascript are posted.

Summary

In this report, the following results were obtained by analyzing the duplicated questions with google-apps-script tag in Stackoverflow.

  • Duplicated questions are increased with year.

  • It was found that there are the trend that the duplicated questions related to Javascript, Google Spreadsheet , the process cost and the cooperation with HTML and Javascript are posted.

I think that to publish the sample scripts educate by considering these results will be more useful for a lot of users. I would like to continue to investigate this statistics.

References

  1. Trend of Google Apps Script
  2. Stack Overflow was launched at 2008-09-15
  3. Initial release of Google Apps Script at 2009-08-19
  4. Tag of "google-apps-script" was created at 2011-08-29
  5. Stack Exchange API

Appendix

I think that this method introduced in this report can be used for various tags. Here, as appendix, 2 sample data are shown.

For google-sheets tag without google-apps-script tag

This is the ranking for the duplicated questions with google-sheets tag without google-apps-script tag. In this case, the data from "2008-01-01" to "2020-10-06" was used for analyzing.

Ranking Number of duplicated questions title
1 5 Reference - What does this regex mean?
2 3 How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets?
3 2 My regex is matching too much. How do I make it stop?
3 2 What special characters must be escaped in regular expressions?
3 2 find & replace commas with newline on Google Spreadsheet
3 2 Escape column name in query (to avoid conflict with reserved words)
3 2 Apps Script: how to get hyperlink from a cell where there is no formula
3 2 Google Sheets importXML Returns Empty Value

For javascript tag

This is the ranking for the duplicated questions with javascript tag. In this case, the data from "2008-01-01" to "2020-10-06" was used for analyzing.

Ranking Number of duplicated questions title
1 3836 How do I return the response from an asynchronous call?
2 1121 JavaScript closure inside loops – simple practical example
3 980 How to access the correct this inside a callback?
4 956 Event binding on dynamically created elements?
5 829 Why is my variable unaltered after I modify it inside of a function? - Asynchronous code reference
6 615 Why does jQuery or a DOM method such as getElementById not find the element?
7 492 How can I access and process nested objects, arrays or JSON?
8 468 Dynamically access object property using variable
9 410 What is the difference between client-side and server-side programming?
10 388 What do querySelectorAll and getElementsBy* methods return?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment