Python Data Preprocessing: Practice

Python Data Preprocessing: Practice

Before diving into in-depth data analysis, a crucial step is data preprocessing. This essential process not only ensures better data quality but also significantly improves the efficiency of your analysis. In this guide, I will introduce a range of powerful Python methods for data preprocessing, equipping you with the tools to optimize your data for more accurate and insightful analysis. I use Goolge Colab when using Python because it’s more user friendly. Please refer how to setup Google Colab in…

Read More Read More

The Science of Apical Dominance: Why Topping is Critical for Hemp Plants?

The Science of Apical Dominance: Why Topping is Critical for Hemp Plants?

In hemp cultivation, “topping” refers to the process of selectively cutting off the upper portion of the plant during its vegetative (growth) phase. This practice holds a central and essential role in plant training, as it encourages horizontal growth and optimizes light utilization, resulting in increased yields. When a plant is topped, the two auxiliary buds located just below the cut site develop into full-fledged branches, often taking on a Y-shaped structure. These secondary branches can also be subjected to…

Read More Read More

Calculating Predicted Values for Each Group in Basic Modeling

Calculating Predicted Values for Each Group in Basic Modeling

□ The Best Linear Unbiased Estimator (BLUE): Step-by-Step Guide using R (with AllInOne Package) In my previous post, I explained how to estimate dependent values from fitting models. Now I’ll explain how to add this predicted value to the original data using R. First, let’s upload data to R. Now, I’ll predict yield using the model. I believe that ‘row’ represents a random factor for each treatment, so I’d like to adjust the residuals using BLUP (Best Linear Unbiased Predictor),…

Read More Read More

How to calculate responsiveness in response to control using R?

How to calculate responsiveness in response to control using R?

In my previous post, I explained how to quantify phenotypic plasticity and introduced the concept of ‘responsiveness.’ □ Quantifying Phenotypic Plasticity of Crops I introduced a formula to calculate responsiveness as (Treatment – Control) / Control. Genotype Control Treatment Responsiveness A 100 90 -10.0% B 120 70 -41.7% C 115 90 -21.7% D 95 85 -10.5% E 110 105 -4.5% However, when analyzing data, the format may not always be the same as above. Mostly, treatments (independent variable) are arranged in…

Read More Read More

Creating an Azure SQL Database: A step-by-step guide

Creating an Azure SQL Database: A step-by-step guide

When you use SQL, it’s about managing your data in the database. However, you might also expect that you can access your database from wherever you are. If you use SQL programs, you would primarily achieve the former, but it’s less relevant to the latter. SQL is a powerful language for managing data in a database; however, it is not specifically designed for remote access. What we want is both a database and a cloud platform so that I can…

Read More Read More

Azure SQL Code: Summary

Azure SQL Code: Summary

Let’s practice Azure SQL codes. The data you can practice can be downloaded below. https://github.com/agronomy4future/raw_data_practice/blob/main/micronutrients.csv If you download the data, first you can upload data to Azure SQL server. The method to upload data to Azure SQL server is explained in the below post. 1) Create database First, let’s create Database to upload external data in Azure Data Studio. and upload the data in the link I provided. The method to upload external data is explained in the below post….

Read More Read More

Early Hemp Growth: A Vertical and Horizontal Stacking of Leaves

Early Hemp Growth: A Vertical and Horizontal Stacking of Leaves

In the early stages of growth, hemp plants tend to exhibit a pattern of stacked leaves, both horizontally and vertically. This growth pattern is characterized by leaves arranged in pairs at regular intervals along the stem, and as the plant grows, these pairs of leaves may be found at different vertical levels on the stem. This phenomenon is a typical part of the plant’s vegetative growth phase, where it is actively developing its leaves and stems. As the plant matures,…

Read More Read More

MySQL Queries: Selecting Specific Columns

MySQL Queries: Selecting Specific Columns

I have created a data table. If you copy and paste the code below into your MySQL window, you can obtain the same data table. □ Select all data column □ Select specific data column □ Select specific data column within specific variable

How To Calculates Different Values Based On Different Variables In MySQL?

How To Calculates Different Values Based On Different Variables In MySQL?

□ Creating Data Tables in MySQL: A Step-by-Step Guide If you followed my previous post, you can manually create a Data Table. If you copy and paste the code below into your MySQL window and then run it with Ctrl+Shift+Enter, you will see the below data table. ■ How to calculate new values? Now, I’d like to calculate new values. For example, I’ve discovered that the yield data was overestimated, and I want to subtract 20 from each value. ID…

Read More Read More

Creating Data Tables in MySQL: A Step-by-Step Guide

Creating Data Tables in MySQL: A Step-by-Step Guide

□ A Step-by-Step Guide to Importing Excel Data into MySQL If you followed my previous post, you can easily create a Data Table when importing external data. In this post, I will introduce how to create a Data Table manually. First, let’s create a database named ‘test_data.’ Within this database, I’ll create a Data Table. I aim to create a Data Table like the one shown below. ID Reps Variable Yield 1 1 Control 116.08 2 2 Control 132.85 3…

Read More Read More

A Step-by-Step Guide to Importing Excel Data into MySQL

A Step-by-Step Guide to Importing Excel Data into MySQL

[Step 1] Database Setup for Importing Excel Data into MySQL The first step is to create a database for importing external data. The code for this step is as follows: After creating a database, refresh the page to display the newly created database. [Step 2] Setting Up the Table Data In the database you created, right click on the Tables, and select Table Data Import Wizard. Then, you can choose the file pathway where your file is located. Let’s create…

Read More Read More

A Step-by-Step Guide to Installing MySQL Workbench on Your Computer

A Step-by-Step Guide to Installing MySQL Workbench on Your Computer

This is the process to install MySQL Workbench on your PC. First, please go to the link and download the latest version of MySQL. https://dev.mysql.com/downloads/workbench/ The next page will ask you to log in to your Oracle web account or sign up, or you can choose to skip this step and start the download. The choice is yours. You need to choose a Setup Type, and I’ll choose Custom. Next choose the latest both MySQL Server and MySQL Workbench From…

Read More Read More

Powdery mildew in hemp

Powdery mildew in hemp

Powdery mildew in hemp is a common fungal disease that can affect the health and yield of hemp plants. It’s caused by various species of fungi, with Podosphaera xanthii and Golovinomyces cichoracearum being common culprits. Powdery mildew typically appears as white or grayish, powdery spots or patches on the leaves, stems, and even flowers of hemp plants. Infected leaves may curl, become distorted, or die prematurely. As the disease progresses, the powdery spots can merge, covering larger areas of the…

Read More Read More

[Crop Note] Soybean harvest (10 Oct 2023) at Champaign in IL, USA

[Crop Note] Soybean harvest (10 Oct 2023) at Champaign in IL, USA

The soybean harvesting phase usually commences when the soybean plants have achieved complete maturity, and the beans are primed for collection. The precise timing of the harvest may fluctuate, contingent on variables such as the soybean variety, environmental conditions, and geographical region. Nevertheless, there are common indicators to observe: ■ Pod Color: The first indicator of soybean maturity is the color of the pods. As the soybeans mature, the green pods turn yellow or brown, and they may start to…

Read More Read More

Exploring THC and CBD Concentrations in Hemp Plants: A Focus on Female Flowers and Resinous Trichomes

Exploring THC and CBD Concentrations in Hemp Plants: A Focus on Female Flowers and Resinous Trichomes

In hemp plants (Cannabis sativa), the highest concentrations of THC (Tetrahydrocannabinol) and CBD (Cannabidiol) are typically found in the female flowers, especially in the resinous trichomes that cover the flowers and leaves. These trichomes produce the cannabinoids, including THC and CBD, as well as other compounds such as terpenes, which contribute to the plant’s aroma and flavor. Hemp plants are typically grown for their industrial uses, including the production of fiber, seeds, and oil. In many hemp cultivars, the THC…

Read More Read More

Beet Curly Top Virus (BCTV) in hemp

Beet Curly Top Virus (BCTV) in hemp

Beet curly top virus (BCTV) is a destructive plant virus that primarily affects plants such as sugar beets, tomatoes. It is primarily transmitted by the beet leafhopper (Circulifer tenellus), which feeds on plant sap and can carry the virus from infected plants to healthy ones. Symptoms of Beet Curly Top Virus on leaves and plants typically include leaf curling. Leaves of infected plants often exhibit severe curling, puckering, and distortion. This is one of the most characteristic symptoms and gives…

Read More Read More

Hemp seed coat is the outer protective layer of a hemp seed

Hemp seed coat is the outer protective layer of a hemp seed

Hemp (or industrial hemp) is Cannabis sativa which is a member of the Cannabaceae family. Actually, Cannabis sativa and Cannabis indica are two of the primary subspecies or varieties of the Cannabis plant, each with its own set of characteristics. It’s important to note that while hemp is a variety of Cannabis sativa, not all cannabis is hemp. The name “cannabis” refers to a genus of flowering plants in the family Cannabaceae, which includes both hemp and marijuana. While both…

Read More Read More

How to customize the title format in facet_wrap()?

How to customize the title format in facet_wrap()?

□ Graph Partitioning Using facet_wrap() in R Studio By following my previous post, you can understand how to obtain the figure below. If you copy and paste the code above into your R console, you can obtain the same figure as shown above. Now, I’d like to change the title format by removing the title border. Next, I’d like to draw a line in the title. Please refer to the code below. full code: https://github.com/agronomy4future/r_code/blob/main/How_to_customize_the_title_format_in_facet_wrap().ipynb © 2022 – 2023 https://agronomy4future.com

Understanding Multiple Linear Regression Easily (Part 2: Calculating the Coefficient of Determination Manually)

Understanding Multiple Linear Regression Easily (Part 2: Calculating the Coefficient of Determination Manually)

□ Understanding Multiple Linear Regression Easily (Part 1: Calculating the Regression Equation Manually) In the previous post, we explained how to manually calculate the regression equation in multiple linear regression analysis. Now, in this post, I will explain how to calculate the coefficient of determination (R2) in multiple linear regression analysis. No. Yield (yi) Time (xi1) Moisture (xi2) 1 4.3 4 0.2 2 5.5 5 0.2 3 6.8 6 0.2 4 8.0 7 0.2 5 4.0 4 0.3 6 5.2…

Read More Read More

Understanding Multiple Linear Regression Easily (Part 1: Calculating the Regression Equation Manually)

Understanding Multiple Linear Regression Easily (Part 1: Calculating the Regression Equation Manually)

In my previous posts, I explained the simple linear regression model as five categories. I recommend reading the following posts first. □ Simple linear regression (1/5)- correlation and covariance□ Simple linear regression (2/5)- slope and intercept of linear regression model□ Simple linear regression (3/5)- standard error of slope and intercept□ Simple linear regression (4/5)- t value on the slope and intercept    □ Simple linear regression (5/5)- R_squared In this session, I will explain multiple regression analysis. Multiple regression analysis refers to…

Read More Read More

[Crop Note] current corn stage, R6 (12 Sep 2023) at Champaign in IL, USA

[Crop Note] current corn stage, R6 (12 Sep 2023) at Champaign in IL, USA

Now, corn is progressing toward maturity, currently at the R6 stage, known as Physiological Maturity. This marks the final stage of kernel development, and the corn growth stages are indicated as follows: [Note 1] Corn growth stageR1 – Silking Stage:This stage marks the beginning of reproductive growth. The tassel at the top of the corn plant releases pollen and silks emerge from the ear shoot and catch the pollen to facilitate fertilization. Silks turn brown and dry as fertilization occurs.R2…

Read More Read More

Solar Farm 2.0 SCAPES Crops Research

Solar Farm 2.0 SCAPES Crops Research

This is one of the research projects called ‘Agrivoltaic’ in which I’m currently involved. Ideally, ground-level solar panels help keep the soil moist, while also keeping the crops cool during the day and warm at night. In turn, the plants assist the panels in transferring water from the soil into the atmosphere. The plants keep the panels cool—and efficient—during the day, resulting in more energy production. However, crops underneath solar panels could have a confounding effect due to shading. Shading…

Read More Read More

Soybean growth stage: R6 (full seed)

Soybean growth stage: R6 (full seed)

When pods contain green seeds that fills the pod at one of the four uppermost nodes on the main stem, it is usually called R6 (full seed). At R6 (full seed), seeds reach their maximum size in one or more pods on at least one of the four uppermost nodes. By mid-R6 (~R6.5), approximately 80% of the seed’s dry weight has accumulated. Subsequently, a few leaves may begin to turn, and some pods may appear lighter in color. ■ [Crop…

Read More Read More

[Crop Note] current soybean stage (12 Sep 2023) at Champaign in IL, USA

[Crop Note] current soybean stage (12 Sep 2023) at Champaign in IL, USA

Agronomy note □ Sowing date: 2023/05/18 □ V4: 2023/6/28 □ Flowering: 2023/08/01 □ R6: 2023/09/12 Three weeks ago, there was an insect problem on soybean leaves caused by Japanese beetles. After flowering, applying insecticide may not be advisable, and therefore I expressed my objection to such applications among several groups sharing the same field. Unless pods are damaged, it is less likely to affect grain yield at around R5. The current growth stage is R6 (full seed), and now I…

Read More Read More

Combining Multiple Excel Files into One Using RDBMerge

Combining Multiple Excel Files into One Using RDBMerge

When you need to consolidate specific data from dozens of Excel files into a single dataset, manually opening and copying from each file (Ctrl + C, Ctrl + V) not only takes a lot of time but also increases the risk of data errors due to momentary lapses in concentration. To address these issues, I introduce a feature that allows you to merge numerous Excel files into one seamlessly. 1. Install the program; ‘RDBMerge’ into the Excel file. downloadhttp://www.rondebruin.nl/win/addins/rdbmerge.htm Visit…

Read More Read More

Understanding Source-Sink Dynamics in Wheat

Understanding Source-Sink Dynamics in Wheat

Wheat is generally known as sink-limitation during the grain-filling period. First, let’s explore the definition of source-sink limitation. The source-sink relationship and the regulation of carbon allocation are determining factors in crop yield. The growth of crops can be restricted by the assimilate availability in specific crop organs or by the ability of those organs to utilize assimilates. In the former case, we refer to it as source-limitation, and in the latter case, it is known as sink-limitation. The causes…

Read More Read More

Step-by-Step Guide: Uploading Data and Conducting Statistical Analysis in SAS Studio

Step-by-Step Guide: Uploading Data and Conducting Statistical Analysis in SAS Studio

SAS Studio is a web version of the SAS program, and it can be used for free. As my current license for the statistical program I’ve been using is about to expire, I was searching for alternatives. Upon discovering SAS Studio, I decided to give it a try. Although I have never used SAS before, I’ve decided to take this opportunity to learn. I will now summarize the very basic learning materials I have covered up to this point. First,…

Read More Read More