PandasPedia - Master the Cells

Let's say you have a DataFrame of 3 animals like below. The codes below create the DataFrame. import pandas as pd dict_zoo = {'Name' : ['Panda', 'Rabbit', 'Lion'], 'Food' : ['Bamboo', 'Carrot', 'Meat'], 'Age' : [5,2,7], 'Species' : ['Mammals', 'Mammals', 'Mammals']} df_zoo = pd.DataFrame(dict_zoo) If you want to delete the 1st row from the DataFrame, use .drop() method like below. df_zoo.drop(1,..

카테고리 없음 2022. 11. 21. 04:04

0. How to append a row to a DataFrame? 1. Make a DataFrame to be Appended Let's say you have a DataFrame of 3-year history of exam scores. The codes below create the DataFrame. import pandas as pd dict_scores = {'Year' : [2019, 2020, 2021], 'Math' : [80, 70, 90], 'History' : [60, 40, 70], 'Science' : [70, 80, 60]} df_scores = pd.DataFrame(dict_scores) One year passed, so you need to update 1 row..

카테고리 없음 2022. 11. 20. 05:28

1. Calculate the columns directly to add a new column There is a DataFrame scores of different subject from 2019 to 2022. You can do various calculations directly by the columns. Below is the codes for the DataFrame. dict_scores = {'Year' : [2019, 2020, 2021, 2022], 'Math' : [80, 70, 90, 100], 'History' : [60, 40, 70, 60], 'Science' : [70, 80, 60, 90]} df_scores = pd.DataFrame(dict_scores) 2. Su..

카테고리 없음 2022. 11. 15. 05:56

0. How to select rows from a DataFrame? 1. Select a Single Column Let's say you have a DataFrame of 4 animals like below. The codes below create the DataFrame. import pandas as pd dict_zoo = {'Name' : ['Panda', 'Rabbit', 'Lion', 'Duck'], 'Food' : ['Carrot', 'Bamboo', 'Meat', 'Fish'], 'Age' : [5, 2, 7, 3], 'Species' : ['Mammals', 'Mammals', 'Mammals', 'Birds']} df_zoo = pd.DataFrame(dict_zoo) You..

카테고리 없음 2022. 11. 12. 16:39

0. How to select a row of a DataFrame? 1. Select using .iloc[] There is a DataFrame of 4 animals as above. Below is the codes for the DataFrame. import pandas as pd dict_zoo = {'Name' : ['Panda', 'Rabbit', 'Lion', 'Duck'], 'Food' : ['Carrot', 'Bamboo', 'Meat', 'Fish'], 'Age' : [5, 2, 7, 3], 'Species' : ['Mammals', 'Mammals', 'Mammals', 'Birds']} df_zoo = pd.DataFrame(dict_zoo) Each row is equiva..

카테고리 없음 2022. 11. 11. 00:48

There are 3 animals in a zoo. Their information is organized in a 2-dimensional table of rows and columns. We call this DataFrame. Let's make it using Pandas library. Import the library. import pandas as pd The headers(Name, Food, Age) are column names. You are going to make each column one by one, and then combine them together. That's our plan. Make a list with Panda, Rabbit, Lion. All the ele..

카테고리 없음 2022. 11. 10. 01:17