07-pandas的DataFrame

 

 pandas的DataFrame

查看结果详细： https://www.cnblogs.com/aocn/articles/11006432.html

 

#!/usr/bin/env python
# coding: utf-8

# In[1]:


import numpy as np
import pandas as pd
from pandas import Series, DataFrame


# In[8]:


# 创建 DataFrame
import webbrowser

link = 'https://www.tiobe.com/tiobe-index'
webbrowser.open(link)

# 从网站上复制排行榜


# In[6]:


# 创建一个dataFrame

# 从粘贴板中解析

df = pd.read_clipboard()



# In[7]:


df


# In[9]:


type(df)


# In[10]:


df.columns


# In[11]:


df.Ratings


# In[12]:


df.Change


# In[13]:


# 操作 生成新的 dataFrame

df_new = DataFrame(df, columns = [ 'Programming Language','Jun 2018','Jun 2019','Ratings'])



# In[14]:


df_new


# In[15]:


df["Jun 2018"]


# In[16]:


type(df["Jun 2018"])


# In[17]:


df_new = DataFrame(df, columns = [ 'Programming Language','Jun 2018','Jun 2019','Rt'])


# In[18]:


df_new


# In[21]:


df_new["Rt"] = range(0,20)


# In[22]:


df_new


# In[23]:


df_new["RF"] = np.arange(0,20)


# In[24]:


df_new


# In[25]:


df_new["RFd"] =  pd.Series(np.arange(0,20))


# In[26]:


df_new


# In[31]:


df_new["RF"] = pd.Series([100,200], index=[18,19])


# In[32]:


df_new


# In[ ]: