Browsed by
Category: Data Science

Predicting Intermediate Data Points with Linear Interpolation in Excel and R

Predicting Intermediate Data Points with Linear Interpolation in Excel and R

Comments 0 Comment

Today, I’ll explain the interpolation technique used to predict in-between data points. For example, when collecting field data, we might not be able to gather information every day, so we establish our own interval (e.g., weekly or bi-weekly). However, when presenting the data, it might be necessary to show it on a daily basis. As another example, consider investigating yield differences in response to varying continuous variables, such as nitrogen at levels of 0, 30, 60, 120. What if we…

Read More Read More

[Meta-Analysis] Mining Academic Papers from SCOPUS with Pybliometrics in Python

[Meta-Analysis] Mining Academic Papers from SCOPUS with Pybliometrics in Python

Comments 0 Comment

SCOPUS is one of the largest abstract and citation databases, providing access to a wide range of peer-reviewed literature across various disciplines. It ensures researchers have access to high-quality, up-to-date academic papers, conference proceedings, and other scholarly materials. Pybliometrics is a Python library that streamlines the retrieval of bibliometric data from SCOPUS. It simplifies accessing and manipulating large datasets, saving researchers time and effort compared to manual data collection. Using Pybliometrics to mine academic papers from SCOPUS enables efficient data…

Read More Read More

[Data article] How many times do we need to compare each other according to group numbers ?

[Data article] How many times do we need to compare each other according to group numbers ?

Comments 0 Comment

All of a sudden, I became curious about this question, How many time do we need to compare each other according to group numbers?” and searched for the answer on a website, but I couldn’t find a clear answer. Therefore, I calculated it myself. For example, when there are two groups, we will compare them only once. When there are three groups, we need to compare each group with every other group, resulting in three comparisons. With four groups, we…

Read More Read More

Simplifying Data Manipulation: Transposing Columns into Rows with Ease

Simplifying Data Manipulation: Transposing Columns into Rows with Ease

Comments 0 Comment

Sometimes, I see many people managing their data as columns like the example below. It seems convenient because we can see our data all at once. However, this data format is problematic for data analysis, which fundamentally relies on variables, namely independent and dependent variables. Download data file (.csv) https://github.com/agronomy4future/raw_data_practice/blob/main/yield_per_location.csv In the given data format, each level for the independent variable (i.e., location) was not combined in one column, and therefore we need to rearrange the data format. If the…

Read More Read More