- Create a Pandas’ DataFrame object.
- Find the average values from only the negative data values.
Hello and welcome back, since a few days ago I am not posting anything on this website because during these few days I am busy working on a new Blender project (below) for mine new game character. Besides that, I also surf Google and watch lots of Youtube videos. But starting from tomorrow I will start to work hard again for the next game project plus write more articles for this site, so stay tuned!
In this chapter we will continue to explore the Pandas’ DataFrame object plus introduce the new Series object with a simple python program.
We will create a new DataFrame object and then iterate through the data within the DataFrame table,
import pandas as pd import numpy as np df = pd.DataFrame(np.random.randn(6, 4), index=[0, 1, 2, 3, 4, 5], columns=['A', 'B', 'C', 'D']) print(df) sum = 0 count = 0 for label, index in df.items(): arr = index.values # Series object returns the array list for the data under column A B C and D for number in arr: if(number < 0): sum += number count+=1 print("Average Negative Values : ") print(sum/count)
There we go, the next article will be a long one and contains lots of information, so stay tuned!