import numpy as np
import pandas as pd
from pandas import Series,DataFrame
生成DataFrame
import webbrowser
link ="https://www.tiobe.com/tiobe-index/"
webbrowser.open(link) #打开一个网站,并从该网站中复制数据
True
df = pd.read_clipboard() #从粘贴板中获取数据并解析,转换成个dataframe
df
Aug 2020 | Aug 2019 | Change | Programming Language | Ratings | Change.1 | |
---|---|---|---|---|---|---|
0 | 1 | 2 | C | 16.98% | +1.83% | |
1 | 2 | 1 | Java | 14.43% | -1.60% | |
2 | 3 | 3 | NaN | Python | 9.69% | -0.33% |
3 | 4 | 4 | NaN | C++ | 6.84% | +0.78% |
4 | 5 | 5 | NaN | C# | 4.68% | +0.83% |
5 | 6 | 6 | NaN | Visual Basic | 4.66% | +0.97% |
6 | 7 | 7 | NaN | JavaScript | 2.87% | +0.62% |
7 | 8 | 20 | R | 2.79% | +1.97% | |
8 | 9 | 8 | PHP | 2.24% | +0.17% |