计算机语言pandas,(完整版)计算机语言python100道pandas(含答案)

1.Import pandas under the name pd .

In[1]:

import pandas as pd

import numpy as np

2.Print the version of pandas that has been imported.

In[2]:

pd.__version_

3.Print out all the version information of the libraries that are required by the pandas library In[3]:

pd.show_versions()

4.Create a DataFrame df from this dictionary data which has the index labels .

In[2]:

data = {'animal': ['cat', 'cat', 'snake', 'dog', 'dog', 'cat', 'snake', 'cat', 'dog

'age': [2.5, 3, 0.5, np.nan, 5, 2, 4.5, np.nan, 7, 3],

'visits': [1, 3, 2, 3, 2, 3, 1, 1, 2, 1],

'priority': ['yes', 'yes', 'no', 'yes', 'no', 'no', 'no', 'yes', 'no', 'no']

labels = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j']

df = pd.DataFrame(data, index=labels)

5. Display a summary of the basic information about this DataFrame and its data.

In[5]:

http://doc.wendoc.com()

# ...or...

df.describe()

6.Return the first 3 rows of the DataFrame df

In[6]:

df.iloc[:3]

# or equivalently

df.head(3)

7.Select just the 'animal' and 'age' columns from the DataFrame df .

In[7]:

df.loc[:, ['animal', 'age']]

# or

df[['animal', 'age']]

8.Select the data in rows [3, 4, 8] and in columns ['animal', 'age'] .

In[3]:

df.loc[df.index[[3, 4, 8]], ['animal', 'age']]

9.Select only the rows where the number of visits is greater than 3.

In[4]:

df[df['visits'] > 3]

10. Select the rows where the age is missing, i.e. is NaN .

In[5]:

df[df['age'].isnull()]

11. Select the rows where the animal is a cat and the age is less than 3.

In[6]: