PandasPedia - Master the Cells

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