This tutorial shows how to reorder columns in dataframe using Pandas in Python. This tutorial includes 3 examples using the methods of reindex(), double brackets [[]], and pop(). Sample Dataframe The following is the sample dataframe in Python, which will be later in all examples in this tutorial. The following is the final sample dataframe. … Read more
This tutorial includes methods that you can select rows based a specific column value or a few column values by using loc() or query() in Python Pandas.
This tutorial shows how to apply correlation in real world. I will use the Peloton and covid example to illustrate this concept. In early 2021, a lot of consumers wanted to buy Peloton bikes but Peloton had difficulty meeting the demand. One year after in Jan. 2022 , Forbes instead reported that Peloton faced challenges … Read more
This short tutorial shows you how you can use melt() funtion in Pandas. It is often used when we need to change the format of dataframe to fit into a certain statistical functions. Example 1 of Using melt() City1 City2 City3 0 6 2 4 1 2 1 1 2 3 3 2 3 4 … Read more
This short tutorial shows how you can calculate mean in Python using NumPy. First, we generate the random data with mean of 5 and standard deviation (SD) of 1. Then, you can use the numpy is mean() function. As you can see, the mean of the sample is close to 5. 4.943504497663466 Regarding of how … Read more
Introduction Since we have covered the theoretical basics of t-test (see the tutorial here), it would be interesting to showcase how we can use t-test for a real-world application. In particular, we are going to use Financial well-being survey data to show how we can use independent t-test via Python. In particular, we could test how gender … Read more
This tutorial demonstrates how to save a dataframe as CSV and xlsx files in Python. Part 1: CSV Files We can first write a dictionary, then transform it into a dataframe. After that, we can use to_csv() save it as a CSV. brands models 0 Tesla Model 3 1 Toyota RAV4 The CSV file is … Read more