爬虫

 

123.py
import pandas as pd

df=pd.read_csv('./123.csv')

打印某一列;判断某一列是否有空值
print(df['NUM_BEDROOMS'])
print(df['NUM_BEDROOMS'].isnull())
dropna()中写inplace=True修改源数据
df2=df.dropna()
指定的列的某一行有空值的话就删除那一行数据

df3=df.dropna(subset=['ST_NUM']) 
替换脏数据为666 
df4=df.fillna('666') 
替换某一列的所有空值为12345 
df['PID'].fillna(12345,inplace=True) 
print(df) 
平均数填充空值,中位数填充空值,众数填充空值 
avg=df['ST_NUM'].mean() 
zhongwei=df['ST_NUM'].median() 
zhong=df['ST_NUM'].mode 
df.fillna(zhong,inplace=True) 
print(df)

 

123.csv

PID,ST_NUM,ST_NAME,OWN_OCCUPIED,NUM_BEDROOMS,NUM_BATH,SQ_FT
100001000,104,PUTNAM,Y,3,1,1000
100002000,197,LEXINGTON,N,3,1.5,--
100003000,,LEXINGTON,N,n/a,1,850
100004000,201,BERKELEY,12,1,NaN,700
,203,BERKELEY,Y,3,2,1600
100006000,207,BERKELEY,Y,NA,1,800
100007000,NA,WASHINGTON,,2,HURLEY,950
100008000,213,TREMONT,Y,1,1,
100009000,215,TREMONT,Y,na,2,1800

 

data.py
import pandas as pd

data={
        "Date":['2020/12/01','2020/12/02','20201226'],
        "duration":[50,40,45]
}
df=pd.DataFrame(data,index=['day1','day2','day3'])
df['Date']=pd.to_datetime(df['Date'])
可以写df也可以写df.to_string()
print(df.to_string())

 

json2.py
import pandas as pd

url='https://static.runoob.com/download/sites.json'
df = pd.read_json(url)
print(df)

 

import pandas as pd

df=pd.read_csv('./nba.csv',encoding='GBK')nba.csv在桌面上则写绝对路径,现在该文件在本项目下
print(df)
df.to_csv('./nba2.csv',encoding='utf-8') 生成nba2.csv,添加了序号
定义三个列表
nme=["Google","Runoob","Taobao","Wiki"]
st["www.google.com","www.runoob.com","www.taobao.com","www.wikipedia.org"]
ag=[90,40,80,98]
将列表转变为字典
dict={'name':nme,'site':st,'age':ag}
df = pd.DataFrame(dict)
保存 dataframe 到site.csv
df.to_csv('site.csv')

 

site.csv

,name,site,age
0,Google,www.google.com,90
1,Runoob,www.runoob.com,40
2,Taobao,www.taobao.com,80
3,Wiki,www.wikipedia.org,98

 

nba2.py
import pandas as pd

读取csv文件到Dataframe
df=pd.read_csv('./nba2.csv')
打印前10行
print(df.head(10))
打印后10行
print(df.tail(10))
返回基本信息 显示所有列名以及列名的数据类型等等信息
print(df.info)

 

nba2.csv

,Name,Team,Number,Position,Age,Height,Weight,College,Salary
0,Avery Bradley,Boston Celtics,0,PG,25,6月2日,180,Texas,7730337.0
1,Jae Crowder,Boston Celtics,99,SF,25,6月6日,235,Marquette,6796117.0
2,John Holland,Boston Celtics,30,SG,27,6月5日,205,Boston University,
3,R.J. Hunter,Boston Celtics,28,SG,22,6月5日,185,Georgia State,1148640.0
4,Jonas Jerebko,Boston Celtics,8,PF,29,6月10日,231,,5000000.0
5,Amir Johnson,Boston Celtics,90,PF,29,6月9日,240,,12000000.0
6,Jordan Mickey,Boston Celtics,55,PF,21,6月8日,235,LSU,1170960.0
7,Kelly Olynyk,Boston Celtics,41,C,25,7-0,238,Gonzaga,2165160.0
8,Terry Rozier,Boston Celtics,12,PG,22,6月2日,190,Louisville,1824360.0
9,Marcus Smart,Boston Celtics,36,PG,22,6月4日,220,Oklahoma State,3431040.0
10,Jared Sullinger,Boston Celtics,7,C,24,6月9日,260,Ohio State,2569260.0
11,Isaiah Thomas,Boston Celtics,4,PG,27,5月9日,185,Washington,6912869.0
12,Evan Turner,Boston Celtics,11,SG,27,6月7日,220,Ohio State,3425510.0
13,James Young,Boston Celtics,13,SG,20,6月6日,215,Kentucky,1749840.0
14,Tyler Zeller,Boston Celtics,44,C,26,7-0,253,North Carolina,2616975.0
15,Bojan Bogdanovic,Brooklyn Nets,44,SG,27,6月8日,216,,3425510.0
16,Markel Brown,Brooklyn Nets,22,SG,24,6月3日,190,Oklahoma State,845059.0
17,Wayne Ellington,Brooklyn Nets,21,SG,28,6月4日,200,North Carolina,1500000.0
18,Rondae Hollis-Jefferson,Brooklyn Nets,24,SG,21,6月7日,220,Arizona,1335480.0
19,Jarrett Jack,Brooklyn Nets,2,PG,32,6月3日,200,Georgia Tech,6300000.0
20,Sergey Karasev,Brooklyn Nets,10,SG,22,6月7日,208,,1599840.0
21,Sean Kilpatrick,Brooklyn Nets,6,SG,26,6月4日,219,Cincinnati,134215.0
22,Shane Larkin,Brooklyn Nets,0,PG,23,5月11日,175,Miami (FL),1500000.0
23,Brook Lopez,Brooklyn Nets,11,C,28,7-0,275,Stanford,19689000.0
24,Chris McCullough,Brooklyn Nets,1,PF,21,6月11日,200,Syracuse,1140240.0
25,Willie Reed,Brooklyn Nets,33,PF,26,6月10日,220,Saint Louis,947276.0
26,Thomas Robinson,Brooklyn Nets,41,PF,25,6月10日,237,Kansas,981348.0
27,Henry Sims,Brooklyn Nets,14,C,26,6月10日,248,Georgetown,947276.0
28,Donald Sloan,Brooklyn Nets,15,PG,28,6月3日,205,Texas A&M,947276.0
29,Thaddeus Young,Brooklyn Nets,30,PF,27,6月8日,221,Georgia Tech,11235955.0
30,Arron Afflalo,New York Knicks,4,SG,30,6月5日,210,UCLA,8000000.0
31,Lou Amundson,New York Knicks,17,PF,33,6月9日,220,UNLV,1635476.0
32,Thanasis Antetokounmpo,New York Knicks,43,SF,23,6月7日,205,,30888.0
33,Carmelo Anthony,New York Knicks,7,SF,32,6月8日,240,Syracuse,22875000.0
34,Jose Calderon,New York Knicks,3,PG,34,6月3日,200,,7402812.0
35,Cleanthony Early,New York Knicks,11,SF,25,6月8日,210,Wichita State,845059.0
36,Langston Galloway,New York Knicks,2,SG,24,6月2日,200,Saint Joseph's,845059.0
37,Jerian Grant,New York Knicks,13,PG,23,6月4日,195,Notre Dame,1572360.0
38,Robin Lopez,New York Knicks,8,C,28,7-0,255,Stanford,12650000.0
39,Kyle O'Quinn,New York Knicks,9,PF,26,6月10日,250,Norfolk State,3750000.0
40,Kristaps Porzingis,New York Knicks,6,PF,20,7月3日,240,,4131720.0
41,Kevin Seraphin,New York Knicks,1,C,26,6月10日,278,,2814000.0
42,Lance Thomas,New York Knicks,42,SF,28,6月8日,235,Duke,1636842.0
43,Sasha Vujacic,New York Knicks,18,SG,32,6月7日,195,,947276.0
44,Derrick Williams,New York Knicks,23,PF,25,6月8日,240,Arizona,4000000.0
45,Tony Wroten,New York Knicks,5,SG,23,6月6日,205,Washington,167406.0
46,Elton Brand,Philadelphia 76ers,42,PF,37,6月9日,254,Duke,
47,Isaiah Canaan,Philadelphia 76ers,0,PG,25,6-0,201,Murray State,947276.0
48,Robert Covington,Philadelphia 76ers,33,SF,25,6月9日,215,Tennessee State,1000000.0
49,Joel Embiid,Philadelphia 76ers,21,C,22,7-0,250,Kansas,4626960.0
50,Jerami Grant,Philadelphia 76ers,39,SF,22,6月8日,210,Syracuse,845059.0
51,Richaun Holmes,Philadelphia 76ers,22,PF,22,6月10日,245,Bowling Green,1074169.0
52,Carl Landry,Philadelphia 76ers,7,PF,32,6月9日,248,Purdue,6500000.0
53,Kendall Marshall,Philadelphia 76ers,5,PG,24,6月4日,200,North Carolina,2144772.0
54,T.J. McConnell,Philadelphia 76ers,12,PG,24,6月2日,200,Arizona,525093.0
55,Nerlens Noel,Philadelphia 76ers,4,PF,22,6月11日,228,Kentucky,3457800.0
56,Jahlil Okafor,Philadelphia 76ers,8,C,20,6月11日,275,Duke,4582680.0
57,Ish Smith,Philadelphia 76ers,1,PG,27,6-0,175,Wake Forest,947276.0
58,Nik Stauskas,Philadelphia 76ers,11,SG,22,6月6日,205,Michigan,2869440.0
59,Hollis Thompson,Philadelphia 76ers,31,SG,25,6月8日,206,Georgetown,947276.0
60,Christian Wood,Philadelphia 76ers,35,PF,20,6月11日,220,UNLV,525093.0
61,Bismack Biyombo,Toronto Raptors,8,C,23,6月9日,245,,2814000.0
62,Bruno Caboclo,Toronto Raptors,20,SF,20,6月9日,205,,1524000.0
63,DeMarre Carroll,Toronto Raptors,5,SF,29,6月8日,212,Missouri,13600000.0
64,DeMar DeRozan,Toronto Raptors,10,SG,26,6月7日,220,USC,10050000.0
65,James Johnson,Toronto Raptors,3,PF,29,6月9日,250,Wake Forest,2500000.0
66,Cory Joseph,Toronto Raptors,6,PG,24,6月3日,190,Texas,7000000.0
67,Kyle Lowry,Toronto Raptors,7,PG,30,6-0,205,Villanova,12000000.0
68,Lucas Nogueira,Toronto Raptors,92,C,23,7-0,220,,1842000.0
69,Patrick Patterson,Toronto Raptors,54,PF,27,6月9日,235,Kentucky,6268675.0
70,Norman Powell,Toronto Raptors,24,SG,23,6月4日,215,UCLA,650000.0
71,Terrence Ross,Toronto Raptors,31,SF,25,6月7日,195,Washington,3553917.0
72,Luis Scola,Toronto Raptors,4,PF,36,6月9日,240,,2900000.0
73,Jason Thompson,Toronto Raptors,1,PF,29,6月11日,250,Rider,245177.0
74,Jonas Valanciunas,Toronto Raptors,17,C,24,7-0,255,,4660482.0
75,Delon Wright,Toronto Raptors,55,PG,24,6月5日,190,Utah,1509360.0
76,Leandro Barbosa,Golden State Warriors,19,SG,33,6月3日,194,,2500000.0
77,Harrison Barnes,Golden State Warriors,40,SF,24,6月8日,225,North Carolina,3873398.0
78,Andrew Bogut,Golden State Warriors,12,C,31,7-0,260,Utah,13800000.0
79,Ian Clark,Golden State Warriors,21,SG,25,6月3日,175,Belmont,947276.0
80,Stephen Curry,Golden State Warriors,30,PG,28,6月3日,190,Davidson,11370786.0
81,Festus Ezeli,Golden State Warriors,31,C,26,6月11日,265,Vanderbilt,2008748.0
82,Draymond Green,Golden State Warriors,23,PF,26,6月7日,230,Michigan State,14260870.0
83,Andre Iguodala,Golden State Warriors,9,SF,32,6月6日,215,Arizona,11710456.0
84,Shaun Livingston,Golden State Warriors,34,PG,30,6月7日,192,,5543725.0
85,Kevon Looney,Golden State Warriors,36,SF,20,6月9日,220,UCLA,1131960.0
86,James Michael McAdoo,Golden State Warriors,20,SF,23,6月9日,240,North Carolina,845059.0
87,Brandon Rush,Golden State Warriors,4,SF,30,6月6日,220,Kansas,1270964.0
88,Marreese Speights,Golden State Warriors,5,C,28,6月10日,255,Florida,3815000.0
89,Klay Thompson,Golden State Warriors,11,SG,26,6月7日,215,Washington State,15501000.0
90,Anderson Varejao,Golden State Warriors,18,PF,33,6月11日,273,,289755.0
91,Cole Aldrich,Los Angeles Clippers,45,C,27,6月11日,250,Kansas,1100602.0
92,Jeff Ayres,Los Angeles Clippers,19,PF,29,6月9日,250,Arizona State,111444.0
93,Jamal Crawford,Los Angeles Clippers,11,SG,36,6月5日,195,Michigan,5675000.0
94,Branden Dawson,Los Angeles Clippers,22,SF,23,6月6日,225,Michigan State,525093.0
95,Jeff Green,Los Angeles Clippers,8,SF,29,6月9日,235,Georgetown,9650000.0
96,Blake Griffin,Los Angeles Clippers,32,PF,27,6月10日,251,Oklahoma,18907726.0
97,Wesley Johnson,Los Angeles Clippers,33,SF,28,6月7日,215,Syracuse,1100602.0
98,DeAndre Jordan,Los Angeles Clippers,6,C,27,6月11日,265,Texas A&M,19689000.0
99,Luc Richard Mbah a Moute,Los Angeles Clippers,12,PF,29,6月8日,230,UCLA,947276.0
100,Chris Paul,Los Angeles Clippers,3,PG,31,6-0,175,Wake Forest,21468695.0
101,Paul Pierce,Los Angeles Clippers,34,SF,38,6月7日,235,Kansas,3376000.0
102,Pablo Prigioni,Los Angeles Clippers,9,PG,39,6月3日,185,,947726.0
103,JJ Redick,Los Angeles Clippers,4,SG,31,6月4日,190,Duke,7085000.0
104,Austin Rivers,Los Angeles Clippers,25,PG,23,6月4日,200,Duke,3110796.0
105,C.J. Wilcox,Los Angeles Clippers,30,SG,25,6月5日,195,Washington,1159680.0
106,Brandon Bass,Los Angeles Lakers,2,PF,31,6月8日,250,LSU,3000000.0
107,Tarik Black,Los Angeles Lakers,28,C,24,6月9日,250,Kansas,845059.0
108,Anthony Brown,Los Angeles Lakers,3,SF,23,6月7日,210,Stanford,700000.0
109,Kobe Bryant,Los Angeles Lakers,24,SF,37,6月6日,212,,25000000.0
110,Jordan Clarkson,Los Angeles Lakers,6,PG,24,6月5日,194,Missouri,845059.0
111,Roy Hibbert,Los Angeles Lakers,17,C,29,7月2日,270,Georgetown,15592217.0
112,Marcelo Huertas,Los Angeles Lakers,9,PG,33,6月3日,200,,525093.0
113,Ryan Kelly,Los Angeles Lakers,4,PF,25,6月11日,230,Duke,1724250.0
114,Larry Nance Jr.,Los Angeles Lakers,7,PF,23,6月9日,230,Wyoming,1155600.0
115,Julius Randle,Los Angeles Lakers,30,PF,21,6月9日,250,Kentucky,3132240.0
116,D'Angelo Russell,Los Angeles Lakers,1,PG,20,6月5日,195,Ohio State,5103120.0
117,Robert Sacre,Los Angeles Lakers,50,C,27,7-0,270,Gonzaga,981348.0
118,Louis Williams,Los Angeles Lakers,23,SG,29,6月1日,175,,7000000.0
119,Metta World Peace,Los Angeles Lakers,37,SF,36,6月7日,260,St. John's,947276.0
120,Nick Young,Los Angeles Lakers,0,SF,31,6月7日,210,USC,5219169.0
121,Eric Bledsoe,Phoenix Suns,2,PG,26,6月1日,190,Kentucky,13500000.0
122,Devin Booker,Phoenix Suns,1,SG,19,6月6日,206,Kentucky,2127840.0
123,Chase Budinger,Phoenix Suns,10,SF,28,6月7日,209,Arizona,206192.0
124,Tyson Chandler,Phoenix Suns,4,C,33,7月1日,240,,13000000.0
125,Archie Goodwin,Phoenix Suns,20,SG,21,6月5日,200,Kentucky,1160160.0
126,John Jenkins,Phoenix Suns,23,SG,25,6月4日,215,Vanderbilt,981348.0
127,Brandon Knight,Phoenix Suns,3,PG,24,6月3日,189,Kentucky,13500000.0
128,Alex Len,Phoenix Suns,21,C,22,7月1日,260,Maryland,3807120.0
129,Jon Leuer,Phoenix Suns,30,PF,27,6月10日,228,Wisconsin,1035000.0
130,Phil Pressey,Phoenix Suns,25,PG,25,5月11日,175,Missouri,55722.0
131,Ronnie Price,Phoenix Suns,14,PG,32,6月2日,190,Utah Valley,947276.0
132,Mirza Teletovic,Phoenix Suns,35,PF,30,6月9日,242,,5500000.0
133,P.J. Tucker,Phoenix Suns,17,SF,31,6月6日,245,Texas,5500000.0
134,T.J. Warren,Phoenix Suns,12,SF,22,6月8日,230,North Carolina State,2041080.0
135,Alan Williams,Phoenix Suns,15,C,23,6月8日,260,UC Santa Barbara,83397.0
136,Quincy Acy,Sacramento Kings,13,SF,25,6月7日,240,Baylor,981348.0
137,James Anderson,Sacramento Kings,5,SG,27,6月6日,213,Oklahoma State,1015421.0
138,Marco Belinelli,Sacramento Kings,3,SG,30,6月5日,210,,6060606.0
139,Caron Butler,Sacramento Kings,31,SF,36,6月7日,228,Connecticut,1449187.0
140,Omri Casspi,Sacramento Kings,18,SF,27,6月9日,225,,2836186.0
141,Willie Cauley-Stein,Sacramento Kings,0,C,22,7-0,240,Kentucky,3398280.0
142,Darren Collison,Sacramento Kings,7,PG,28,6-0,175,UCLA,5013559.0
143,DeMarcus Cousins,Sacramento Kings,15,C,25,6月11日,270,Kentucky,15851950.0
144,Seth Curry,Sacramento Kings,30,SG,25,6月2日,185,Duke,947276.0
145,Duje Dukan,Sacramento Kings,26,PF,24,6月9日,220,Wisconsin,525093.0
146,Rudy Gay,Sacramento Kings,8,SF,29,6月8日,230,Connecticut,12403101.0
147,Kosta Koufos,Sacramento Kings,41,C,27,7-0,265,Ohio State,7700000.0
148,Ben McLemore,Sacramento Kings,23,SG,23,6月5日,195,Kansas,3156600.0
149,Eric Moreland,Sacramento Kings,25,PF,24,6月10日,238,Oregon State,845059.0
150,Rajon Rondo,Sacramento Kings,9,PG,30,6月1日,186,Kentucky,9500000.0
151,Cameron Bairstow,Chicago Bulls,41,PF,25,6月9日,250,New Mexico,845059.0
152,Aaron Brooks,Chicago Bulls,0,PG,31,6-0,161,Oregon,2250000.0
153,Jimmy Butler,Chicago Bulls,21,SG,26,6月7日,220,Marquette,16407500.0
154,Mike Dunleavy,Chicago Bulls,34,SG,35,6月9日,230,Duke,4500000.0
155,Cristiano Felicio,Chicago Bulls,6,PF,23,6月10日,275,,525093.0
156,Pau Gasol,Chicago Bulls,16,C,35,7-0,250,,7448760.0
157,Taj Gibson,Chicago Bulls,22,PF,30,6月9日,225,USC,8500000.0
158,Justin Holiday,Chicago Bulls,7,SG,27,6月6日,185,Washington,947276.0
159,Doug McDermott,Chicago Bulls,3,SF,24,6月8日,225,Creighton,2380440.0
160,Nikola Mirotic,Chicago Bulls,44,PF,25,6月10日,220,,5543725.0
161,E'Twaun Moore,Chicago Bulls,55,SG,27,6月4日,191,Purdue,1015421.0
162,Joakim Noah,Chicago Bulls,13,C,31,6月11日,232,Florida,13400000.0
163,Bobby Portis,Chicago Bulls,5,PF,21,6月11日,230,Arkansas,1391160.0
164,Derrick Rose,Chicago Bulls,1,PG,27,6月3日,190,Memphis,20093064.0
165,Tony Snell,Chicago Bulls,20,SF,24,6月7日,200,New Mexico,1535880.0
166,Matthew Dellavedova,Cleveland Cavaliers,8,PG,25,6月4日,198,Saint Mary's,1147276.0
167,Channing Frye,Cleveland Cavaliers,9,PF,33,6月11日,255,Arizona,8193029.0
168,Kyrie Irving,Cleveland Cavaliers,2,PG,24,6月3日,193,Duke,16407501.0
169,LeBron James,Cleveland Cavaliers,23,SF,31,6月8日,250,,22970500.0
170,Richard Jefferson,Cleveland Cavaliers,24,SF,35,6月7日,233,Arizona,947276.0
171,Dahntay Jones,Cleveland Cavaliers,30,SG,35,6月6日,225,Duke,
172,James Jones,Cleveland Cavaliers,1,SG,35,6月8日,218,Miami (FL),947276.0
173,Sasha Kaun,Cleveland Cavaliers,14,C,31,6月11日,260,Kansas,1276000.0
174,Kevin Love,Cleveland Cavaliers,0,PF,27,6月10日,251,UCLA,19689000.0
175,Jordan McRae,Cleveland Cavaliers,12,SG,25,6月5日,179,Tennessee,111196.0
176,Timofey Mozgov,Cleveland Cavaliers,20,C,29,7月1日,275,,4950000.0
177,Iman Shumpert,Cleveland Cavaliers,4,SG,25,6月5日,220,Georgia Tech,8988765.0
178,J.R. Smith,Cleveland Cavaliers,5,SG,30,6月6日,225,,5000000.0
179,Tristan Thompson,Cleveland Cavaliers,13,C,25,6月9日,238,Texas,14260870.0
180,Mo Williams,Cleveland Cavaliers,52,PG,33,6月1日,198,Alabama,2100000.0
181,Joel Anthony,Detroit Pistons,50,C,33,6月9日,245,UNLV,2500000.0
182,Aron Baynes,Detroit Pistons,12,C,29,6月10日,260,Washington State,6500000.0
183,Steve Blake,Detroit Pistons,22,PG,36,6月3日,172,Maryland,2170465.0
184,Lorenzo Brown,Detroit Pistons,17,PG,25,6月5日,189,North Carolina State,111444.0
185,Reggie Bullock,Detroit Pistons,25,SF,25,6月7日,205,North Carolina,1252440.0
186,Kentavious Caldwell-Pope,Detroit Pistons,5,SG,23,6月5日,205,Georgia,2891760.0
187,Spencer Dinwiddie,Detroit Pistons,8,PG,23,6月6日,200,Colorado,845059.0
188,Andre Drummond,Detroit Pistons,0,C,22,6月11日,279,Connecticut,3272091.0
189,Tobias Harris,Detroit Pistons,34,SF,23,6月9日,235,Tennessee,16000000.0
190,Darrun Hilliard,Detroit Pistons,6,SF,23,6月6日,205,Villanova,600000.0
191,Reggie Jackson,Detroit Pistons,1,PG,26,6月3日,208,Boston College,13913044.0
192,Stanley Johnson,Detroit Pistons,3,SF,20,6月7日,245,Arizona,2841960.0
193,Jodie Meeks,Detroit Pistons,20,SG,28,6月4日,210,Kentucky,6270000.0
194,Marcus Morris,Detroit Pistons,13,PF,26,6月9日,235,Kansas,5000000.0
195,Anthony Tolliver,Detroit Pistons,43,PF,31,6月8日,240,Creighton,3000000.0
196,Lavoy Allen,Indiana Pacers,5,PF,27,6月9日,255,Temple,4050000.0
197,Rakeem Christmas,Indiana Pacers,25,PF,24,6月9日,250,Syracuse,1007026.0
198,Monta Ellis,Indiana Pacers,11,SG,30,6月3日,185,,10300000.0
199,Paul George,Indiana Pacers,13,SF,26,6月9日,220,Fresno State,17120106.0
200,George Hill,Indiana Pacers,3,PG,30,6月3日,188,IUPUI,8000000.0
201,Jordan Hill,Indiana Pacers,27,C,28,6月10日,235,Arizona,4000000.0
202,Solomon Hill,Indiana Pacers,44,SF,25,6月7日,225,Arizona,1358880.0
203,Ty Lawson,Indiana Pacers,10,PG,28,5月11日,195,North Carolina,211744.0
204,Ian Mahinmi,Indiana Pacers,28,C,29,6月11日,250,,4000000.0
205,C.J. Miles,Indiana Pacers,0,SF,29,6月6日,231,,4394225.0
206,Glenn Robinson III,Indiana Pacers,40,SG,22,6月7日,222,Michigan,1100000.0
207,Rodney Stuckey,Indiana Pacers,2,PG,30,6月5日,205,Eastern Washington,7000000.0
208,Myles Turner,Indiana Pacers,33,PF,20,6月11日,243,Texas,2357760.0
209,Shayne Whittington,Indiana Pacers,42,PF,25,6月11日,250,Western Michigan,845059.0
210,Joe Young,Indiana Pacers,1,PG,23,6月2日,180,Oregon,1007026.0
211,Giannis Antetokounmpo,Milwaukee Bucks,34,SF,21,6月11日,222,,1953960.0
212,Jerryd Bayless,Milwaukee Bucks,19,PG,27,6月3日,200,Arizona,3000000.0
213,Michael Carter-Williams,Milwaukee Bucks,5,PG,24,6月6日,190,Syracuse,2399040.0
214,Jared Cunningham,Milwaukee Bucks,9,SG,25,6月4日,195,Oregon State,947276.0
215,Tyler Ennis,Milwaukee Bucks,11,PG,21,6月3日,194,Syracuse,1662360.0
216,John Henson,Milwaukee Bucks,31,PF,25,6月11日,229,North Carolina,2943221.0
217,Damien Inglis,Milwaukee Bucks,17,SF,21,6月8日,246,,855000.0
218,O.J. Mayo,Milwaukee Bucks,3,SG,28,6月5日,210,USC,8000000.0
219,Khris Middleton,Milwaukee Bucks,22,SG,24,6月8日,234,Texas A&M,14700000.0
220,Greg Monroe,Milwaukee Bucks,15,C,26,6月11日,265,Georgetown,16407500.0
221,Steve Novak,Milwaukee Bucks,6,SF,32,6月10日,225,Marquette,295327.0
222,Johnny O'Bryant III,Milwaukee Bucks,77,PF,23,6月9日,257,LSU,845059.0
223,Jabari Parker,Milwaukee Bucks,12,PF,21,6月8日,250,Duke,5152440.0
224,Miles Plumlee,Milwaukee Bucks,18,C,27,6月11日,249,Duke,2109294.0
225,Greivis Vasquez,Milwaukee Bucks,21,PG,29,6月6日,217,Maryland,6600000.0
226,Rashad Vaughn,Milwaukee Bucks,20,SG,19,6月6日,202,UNLV,1733040.0
227,Justin Anderson,Dallas Mavericks,1,SG,22,6月6日,228,Virginia,1449000.0
228,J.J. Barea,Dallas Mavericks,5,PG,31,6-0,185,Northeastern,4290000.0
229,Jeremy Evans,Dallas Mavericks,21,SF,28,6月9日,200,Western Kentucky,1100602.0
230,Raymond Felton,Dallas Mavericks,2,PG,31,6月1日,205,North Carolina,3950313.0
231,Devin Harris,Dallas Mavericks,34,PG,33,6月3日,185,Wisconsin,4053446.0
232,David Lee,Dallas Mavericks,42,PF,33,6月9日,245,Florida,2085671.0
233,Wesley Matthews,Dallas Mavericks,23,SG,29,6月5日,220,Marquette,16407500.0
234,JaVale McGee,Dallas Mavericks,11,C,28,7-0,270,Nevada,1270964.0
235,Salah Mejri,Dallas Mavericks,50,C,29,7月2日,245,,525093.0
236,Dirk Nowitzki,Dallas Mavericks,41,PF,37,7-0,245,,8333334.0
237,Zaza Pachulia,Dallas Mavericks,27,C,32,6月11日,275,,5200000.0
238,Chandler Parsons,Dallas Mavericks,25,SF,27,6月10日,230,Florida,15361500.0
239,Dwight Powell,Dallas Mavericks,7,PF,24,6月11日,240,Stanford,845059.0
240,Charlie Villanueva,Dallas Mavericks,3,PF,31,6月11日,232,Connecticut,947276.0
241,Deron Williams,Dallas Mavericks,8,PG,31,6月3日,200,Illinois,5378974.0
242,Trevor Ariza,Houston Rockets,1,SF,30,6月8日,215,UCLA,8193030.0
243,Michael Beasley,Houston Rockets,8,SF,27,6月10日,235,Kansas State,306527.0
244,Patrick Beverley,Houston Rockets,2,PG,27,6月1日,185,Arkansas,6486486.0
245,Corey Brewer,Houston Rockets,33,SG,30,6月9日,186,Florida,8229375.0
246,Clint Capela,Houston Rockets,15,PF,22,6月10日,240,,1242720.0
247,Sam Dekker,Houston Rockets,7,SF,22,6月9日,230,Wisconsin,1646400.0
248,Andrew Goudelock,Houston Rockets,0,PG,27,6月3日,200,Charleston,200600.0
249,James Harden,Houston Rockets,13,SG,26,6月5日,220,Arizona State,15756438.0
250,Montrezl Harrell,Houston Rockets,35,PF,22,6月8日,240,Louisville,1000000.0
251,Dwight Howard,Houston Rockets,12,C,30,6月11日,265,,22359364.0
252,Terrence Jones,Houston Rockets,6,PF,24,6月9日,252,Kentucky,2489530.0
253,K.J. McDaniels,Houston Rockets,32,SG,23,6月6日,205,Clemson,3189794.0
254,Donatas Motiejunas,Houston Rockets,20,PF,25,7-0,222,,2288205.0
255,Josh Smith,Houston Rockets,5,C,30,6月9日,225,,947276.0
256,Jason Terry,Houston Rockets,31,SG,38,6月2日,185,Arizona,947276.0
257,Jordan Adams,Memphis Grizzlies,3,SG,21,6月5日,209,UCLA,1404600.0
258,Tony Allen,Memphis Grizzlies,9,SG,34,6月4日,213,Oklahoma State,5158539.0
259,Chris Andersen,Memphis Grizzlies,7,PF,37,6月10日,245,Blinn College,5000000.0
260,Matt Barnes,Memphis Grizzlies,22,SF,36,6月7日,226,UCLA,3542500.0
261,Vince Carter,Memphis Grizzlies,15,SG,39,6月6日,220,North Carolina,4088019.0
262,Mike Conley,Memphis Grizzlies,11,PG,28,6月1日,175,Ohio State,9588426.0
263,Bryce Cotton,Memphis Grizzlies,8,PG,23,6月1日,165,Providence,700902.0
264,Jordan Farmar,Memphis Grizzlies,4,PG,29,6月2日,180,UCLA,
265,Marc Gasol,Memphis Grizzlies,33,C,31,7月1日,255,,19688000.0
266,JaMychal Green,Memphis Grizzlies,0,PF,25,6月9日,227,Alabama,845059.0
267,P.J. Hairston,Memphis Grizzlies,19,SF,23,6月6日,230,North Carolina,1201440.0
268,Jarell Martin,Memphis Grizzlies,10,PF,22,6月10日,239,LSU,1230840.0
269,Ray McCallum,Memphis Grizzlies,5,PG,24,6月3日,190,Detroit,
270,Xavier Munford,Memphis Grizzlies,14,PG,24,6月3日,180,Rhode Island,
271,Zach Randolph,Memphis Grizzlies,50,PF,34,6月9日,260,Michigan State,9638555.0
272,Lance Stephenson,Memphis Grizzlies,1,SF,25,6月5日,230,Cincinnati,9000000.0
273,Alex Stepheson,Memphis Grizzlies,35,PF,28,6月10日,270,USC,
274,Brandan Wright,Memphis Grizzlies,34,PF,28,6月10日,210,North Carolina,5464000.0
275,Alexis Ajinca,New Orleans Pelicans,42,C,28,7月2日,248,,4389607.0
276,Ryan Anderson,New Orleans Pelicans,33,PF,28,6月10日,240,California,8500000.0
277,Omer Asik,New Orleans Pelicans,3,C,29,7-0,255,,9213483.0
278,Luke Babbitt,New Orleans Pelicans,8,SF,26,6月9日,225,Nevada,1100602.0
279,Norris Cole,New Orleans Pelicans,30,PG,27,6月2日,175,Cleveland State,3036927.0
280,Dante Cunningham,New Orleans Pelicans,44,PF,29,6月8日,230,Villanova,2850000.0
281,Anthony Davis,New Orleans Pelicans,23,PF,23,6月10日,253,Kentucky,7070730.0
282,Bryce Dejean-Jones,New Orleans Pelicans,31,SG,23,6月6日,203,Iowa State,169883.0
283,Toney Douglas,New Orleans Pelicans,16,PG,30,6月2日,195,Florida State,1164858.0
284,James Ennis,New Orleans Pelicans,4,SF,25,6月7日,210,Long Beach State,845059.0
285,Tyreke Evans,New Orleans Pelicans,1,SG,26,6月6日,220,Memphis,10734586.0
286,Tim Frazier,New Orleans Pelicans,2,PG,25,6月1日,170,Penn State,845059.0
287,Alonzo Gee,New Orleans Pelicans,15,SF,29,6月6日,225,Alabama,1320000.0
288,Eric Gordon,New Orleans Pelicans,10,SG,27,6月4日,215,Indiana,15514031.0
289,Jordan Hamilton,New Orleans Pelicans,25,SG,25,6月7日,220,Texas,1015421.0
290,Jrue Holiday,New Orleans Pelicans,11,PG,25,6月4日,205,UCLA,10595507.0
291,Orlando Johnson,New Orleans Pelicans,0,SG,27,6月5日,220,UC Santa Barbara,55722.0
292,Kendrick Perkins,New Orleans Pelicans,5,C,31,6月10日,270,,947276.0
293,Quincy Pondexter,New Orleans Pelicans,20,SF,28,6月7日,220,Washington,3382023.0
294,LaMarcus Aldridge,San Antonio Spurs,12,PF,30,6月11日,240,Texas,19689000.0
295,Kyle Anderson,San Antonio Spurs,1,SF,22,6月9日,230,UCLA,1142880.0
296,Matt Bonner,San Antonio Spurs,15,C,36,6月10日,235,Florida,947276.0
297,Boris Diaw,San Antonio Spurs,33,C,34,6月8日,250,,7500000.0
298,Tim Duncan,San Antonio Spurs,21,C,40,6月11日,250,Wake Forest,5250000.0
299,Manu Ginobili,San Antonio Spurs,20,SG,38,6月6日,205,,2814000.0
300,Danny Green,San Antonio Spurs,14,SG,28,6月6日,215,North Carolina,10000000.0
301,Kawhi Leonard,San Antonio Spurs,2,SF,24,6月7日,230,San Diego State,16407500.0
302,Boban Marjanovic,San Antonio Spurs,40,C,27,7月3日,290,,1200000.0
303,Kevin Martin,San Antonio Spurs,23,SG,33,6月7日,199,Western Carolina,200600.0
304,Andre Miller,San Antonio Spurs,24,PG,40,6月3日,200,Utah,250750.0
305,Patty Mills,San Antonio Spurs,8,PG,27,6-0,185,Saint Mary's,3578947.0
306,Tony Parker,San Antonio Spurs,9,PG,34,6月2日,185,,13437500.0
307,Jonathon Simmons,San Antonio Spurs,17,SG,26,6月6日,195,Houston,525093.0
308,David West,San Antonio Spurs,30,PF,35,6月9日,250,Xavier,1499187.0
309,Kent Bazemore,Atlanta Hawks,24,SF,26,6月5日,201,Old Dominion,2000000.0
310,Tim Hardaway Jr.,Atlanta Hawks,10,SG,24,6月6日,205,Michigan,1304520.0
311,Kirk Hinrich,Atlanta Hawks,12,SG,35,6月4日,190,Kansas,2854940.0
312,Al Horford,Atlanta Hawks,15,C,30,6月10日,245,Florida,12000000.0
313,Kris Humphries,Atlanta Hawks,43,PF,31,6月9日,235,Minnesota,1000000.0
314,Kyle Korver,Atlanta Hawks,26,SG,35,6月7日,212,Creighton,5746479.0
315,Paul Millsap,Atlanta Hawks,4,PF,31,6月8日,246,Louisiana Tech,18671659.0
316,Mike Muscala,Atlanta Hawks,31,PF,24,6月11日,240,Bucknell,947276.0
317,Lamar Patterson,Atlanta Hawks,13,SG,24,6月5日,225,Pittsburgh,525093.0
318,Dennis Schroder,Atlanta Hawks,17,PG,22,6月1日,172,,1763400.0
319,Mike Scott,Atlanta Hawks,32,PF,27,6月8日,237,Virginia,3333333.0
320,Thabo Sefolosha,Atlanta Hawks,25,SF,32,6月7日,220,,4000000.0
321,Tiago Splitter,Atlanta Hawks,11,C,31,6月11日,245,,9756250.0
322,Walter Tavares,Atlanta Hawks,22,C,24,7月3日,260,,1000000.0
323,Jeff Teague,Atlanta Hawks,0,PG,27,6月2日,186,Wake Forest,8000000.0
324,Nicolas Batum,Charlotte Hornets,5,SG,27,6月8日,200,,13125306.0
325,Troy Daniels,Charlotte Hornets,30,SG,24,6月4日,205,Virginia Commonwealth,947276.0
326,Jorge Gutierrez,Charlotte Hornets,12,PG,27,6月3日,189,California,189455.0
327,Tyler Hansbrough,Charlotte Hornets,50,PF,30,6月9日,250,North Carolina,947276.0
328,Aaron Harrison,Charlotte Hornets,9,SG,21,6月6日,210,Kentucky,525093.0
329,Spencer Hawes,Charlotte Hornets,0,PF,28,7月1日,245,Washington,6110034.0
330,Al Jefferson,Charlotte Hornets,25,C,31,6月10日,289,,13500000.0
331,Frank Kaminsky III,Charlotte Hornets,44,C,23,7-0,240,Wisconsin,2612520.0
332,Michael Kidd-Gilchrist,Charlotte Hornets,14,SF,22,6月7日,232,Kentucky,6331404.0
333,Jeremy Lamb,Charlotte Hornets,3,SG,24,6月5日,185,Connecticut,3034356.0
334,Courtney Lee,Charlotte Hornets,1,SG,30,6月5日,200,Western Kentucky,5675000.0
335,Jeremy Lin,Charlotte Hornets,7,PG,27,6月3日,200,Harvard,2139000.0
336,Kemba Walker,Charlotte Hornets,15,PG,26,6月1日,184,Connecticut,12000000.0
337,Marvin Williams,Charlotte Hornets,2,PF,29,6月9日,237,North Carolina,7000000.0
338,Cody Zeller,Charlotte Hornets,40,C,23,7-0,240,Indiana,4204200.0
339,Chris Bosh,Miami Heat,1,PF,32,6月11日,235,Georgia Tech,22192730.0
340,Luol Deng,Miami Heat,9,SF,31,6月9日,220,Duke,10151612.0
341,Goran Dragic,Miami Heat,7,PG,30,6月3日,190,,14783000.0
342,Gerald Green,Miami Heat,14,SF,30,6月7日,205,,947276.0
343,Udonis Haslem,Miami Heat,40,PF,36,6月8日,235,Florida,2854940.0
344,Joe Johnson,Miami Heat,2,SF,34,6月7日,240,Arkansas,261894.0
345,Tyler Johnson,Miami Heat,8,SG,24,6月4日,186,Fresno State,845059.0
346,Josh McRoberts,Miami Heat,4,PF,29,6月10日,240,Duke,5543725.0
347,Josh Richardson,Miami Heat,0,SG,22,6月6日,200,Tennessee,525093.0
348,Amar'e Stoudemire,Miami Heat,5,PF,33,6月10日,245,,947276.0
349,Dwyane Wade,Miami Heat,3,SG,34,6月4日,220,Marquette,20000000.0
350,Briante Weber,Miami Heat,12,PG,23,6月2日,165,Virginia Commonwealth,
351,Hassan Whiteside,Miami Heat,21,C,26,7-0,265,Marshall,981348.0
352,Justise Winslow,Miami Heat,20,SF,20,6月7日,225,Duke,2481720.0
353,Dorell Wright,Miami Heat,11,SF,30,6月9日,205,,
354,Dewayne Dedmon,Orlando Magic,3,C,26,7-0,245,USC,947276.0
355,Evan Fournier,Orlando Magic,10,SG,23,6月7日,205,,2288205.0
356,Aaron Gordon,Orlando Magic,0,PF,20,6月9日,220,Arizona,4171680.0
357,Mario Hezonja,Orlando Magic,23,SG,21,6月8日,218,,3741480.0
358,Ersan Ilyasova,Orlando Magic,7,PF,29,6月10日,235,,7900000.0
359,Brandon Jennings,Orlando Magic,55,PG,26,6月1日,169,,8344497.0
360,Devyn Marble,Orlando Magic,11,SF,23,6月6日,200,Iowa,845059.0
361,Shabazz Napier,Orlando Magic,13,PG,24,6月1日,175,Connecticut,1294440.0
362,Andrew Nicholson,Orlando Magic,44,PF,26,6月9日,250,St. Bonaventure,2380593.0
363,Victor Oladipo,Orlando Magic,5,SG,24,6月4日,210,Indiana,5192520.0
364,Elfrid Payton,Orlando Magic,4,PG,22,6月4日,185,Louisiana-Lafayette,2505720.0
365,Jason Smith,Orlando Magic,14,PF,30,7-0,240,Colorado State,4300000.0
366,Nikola Vucevic,Orlando Magic,9,C,25,7-0,260,USC,11250000.0
367,C.J. Watson,Orlando Magic,32,PG,32,6月2日,175,Tennessee,5000000.0
368,Alan Anderson,Washington Wizards,6,SG,33,6月6日,220,Michigan State,4000000.0
369,Bradley Beal,Washington Wizards,3,SG,22,6月5日,207,Florida,5694674.0
370,Jared Dudley,Washington Wizards,1,SF,30,6月7日,225,Boston College,4375000.0
371,Jarell Eddie,Washington Wizards,8,SG,24,6月7日,218,Virginia Tech,561716.0
372,Drew Gooden,Washington Wizards,90,PF,34,6月10日,250,Kansas,3300000.0
373,Marcin Gortat,Washington Wizards,13,C,32,6月11日,240,,11217391.0
374,JJ Hickson,Washington Wizards,21,C,27,6月9日,242,North Carolina State,273038.0
375,Nene Hilario,Washington Wizards,42,C,33,6月11日,250,,13000000.0
376,Markieff Morris,Washington Wizards,5,PF,26,6月10日,245,Kansas,8000000.0
377,Kelly Oubre Jr.,Washington Wizards,12,SF,20,6月7日,205,Kansas,1920240.0
378,Otto Porter Jr.,Washington Wizards,22,SF,23,6月8日,198,Georgetown,4662960.0
379,Ramon Sessions,Washington Wizards,7,PG,30,6月3日,190,Nevada,2170465.0
380,Garrett Temple,Washington Wizards,17,SG,30,6月6日,195,LSU,1100602.0
381,Marcus Thornton,Washington Wizards,15,SF,29,6月4日,205,LSU,200600.0
382,John Wall,Washington Wizards,2,PG,25,6月4日,195,Kentucky,15851950.0
383,Darrell Arthur,Denver Nuggets,0,PF,28,6月9日,235,Kansas,2814000.0
384,D.J. Augustin,Denver Nuggets,12,PG,28,6-0,183,Texas,3000000.0
385,Will Barton,Denver Nuggets,5,SF,25,6月6日,175,Memphis,3533333.0
386,Wilson Chandler,Denver Nuggets,21,SF,29,6月8日,225,DePaul,10449438.0
387,Kenneth Faried,Denver Nuggets,35,PF,26,6月8日,228,Morehead State,11235955.0
388,Danilo Gallinari,Denver Nuggets,8,SF,27,6月10日,225,,14000000.0
389,Gary Harris,Denver Nuggets,14,SG,21,6月4日,210,Michigan State,1584480.0
390,Nikola Jokic,Denver Nuggets,15,C,21,6月10日,250,,1300000.0
391,Joffrey Lauvergne,Denver Nuggets,77,C,24,6月11日,220,,1709719.0
392,Mike Miller,Denver Nuggets,3,SG,36,6月8日,218,Florida,947276.0
393,Emmanuel Mudiay,Denver Nuggets,0,PG,20,6月5日,200,,3102240.0
394,Jameer Nelson,Denver Nuggets,1,PG,34,6-0,190,Saint Joseph's,4345000.0
395,Jusuf Nurkic,Denver Nuggets,23,C,21,7-0,280,,1842000.0
396,JaKarr Sampson,Denver Nuggets,9,SG,23,6月9日,214,St. John's,258489.0
397,Axel Toupane,Denver Nuggets,6,SG,23,6月7日,210,,
398,Nemanja Bjelica,Minnesota Timberwolves,88,PF,28,6月10日,240,,3950001.0
399,Gorgui Dieng,Minnesota Timberwolves,5,C,26,6月11日,241,Louisville,1474440.0
400,Kevin Garnett,Minnesota Timberwolves,21,PF,40,6月11日,240,,8500000.0
401,Tyus Jones,Minnesota Timberwolves,1,PG,20,6月2日,195,Duke,1282080.0
402,Zach LaVine,Minnesota Timberwolves,8,PG,21,6月5日,189,UCLA,2148360.0
403,Shabazz Muhammad,Minnesota Timberwolves,15,SF,23,6月6日,223,UCLA,2056920.0
404,Adreian Payne,Minnesota Timberwolves,33,PF,25,6月10日,237,Michigan State,1938840.0
405,Nikola Pekovic,Minnesota Timberwolves,14,C,30,6月11日,307,,12100000.0
406,Tayshaun Prince,Minnesota Timberwolves,12,SF,36,6月9日,212,Kentucky,947276.0
407,Ricky Rubio,Minnesota Timberwolves,9,PG,25,6月4日,194,,12700000.0
408,Damjan Rudez,Minnesota Timberwolves,10,SF,29,6月9日,230,,1149500.0
409,Greg Smith,Minnesota Timberwolves,4,PF,25,6月10日,250,Fresno State,
410,Karl-Anthony Towns,Minnesota Timberwolves,32,C,20,7-0,244,Kentucky,5703600.0
411,Andrew Wiggins,Minnesota Timberwolves,22,SG,21,6月8日,199,Kansas,5758680.0
412,Steven Adams,Oklahoma City Thunder,12,C,22,7-0,255,Pittsburgh,2279040.0
413,Nick Collison,Oklahoma City Thunder,4,PF,35,6月10日,255,Kansas,3750000.0
414,Kevin Durant,Oklahoma City Thunder,35,SF,27,6月9日,240,Texas,20158622.0
415,Randy Foye,Oklahoma City Thunder,6,SG,32,6月4日,213,Villanova,3135000.0
416,Josh Huestis,Oklahoma City Thunder,34,SF,24,6月7日,230,Stanford,1140240.0
417,Serge Ibaka,Oklahoma City Thunder,9,PF,26,6月10日,245,,12250000.0
418,Enes Kanter,Oklahoma City Thunder,11,C,24,6月11日,245,Kentucky,16407500.0
419,Mitch McGary,Oklahoma City Thunder,33,PF,24,6月10日,255,Michigan,1463040.0
420,Nazr Mohammed,Oklahoma City Thunder,13,C,38,6月10日,250,Kentucky,222888.0
421,Anthony Morrow,Oklahoma City Thunder,2,SG,30,6月5日,210,Georgia Tech,3344000.0
422,Cameron Payne,Oklahoma City Thunder,22,PG,21,6月3日,185,Murray State,2021520.0
423,Andre Roberson,Oklahoma City Thunder,21,SG,24,6月7日,210,Colorado,1210800.0
424,Kyle Singler,Oklahoma City Thunder,5,SF,28,6月8日,228,Duke,4500000.0
425,Dion Waiters,Oklahoma City Thunder,3,SG,24,6月4日,220,Syracuse,5138430.0
426,Russell Westbrook,Oklahoma City Thunder,0,PG,27,6月3日,200,UCLA,16744218.0
427,Cliff Alexander,Portland Trail Blazers,34,PF,20,6月8日,240,Kansas,525093.0
428,Al-Farouq Aminu,Portland Trail Blazers,8,SF,25,6月9日,215,Wake Forest,8042895.0
429,Pat Connaughton,Portland Trail Blazers,5,SG,23,6月5日,206,Notre Dame,625093.0
430,Allen Crabbe,Portland Trail Blazers,23,SG,24,6月6日,210,California,947276.0
431,Ed Davis,Portland Trail Blazers,17,C,27,6月10日,240,North Carolina,6980802.0
432,Maurice Harkless,Portland Trail Blazers,4,SF,23,6月9日,215,St. John's,2894059.0
433,Gerald Henderson,Portland Trail Blazers,9,SG,28,6月5日,215,Duke,6000000.0
434,Chris Kaman,Portland Trail Blazers,35,C,34,7-0,265,Central Michigan,5016000.0
435,Meyers Leonard,Portland Trail Blazers,11,PF,24,7月1日,245,Illinois,3075880.0
436,Damian Lillard,Portland Trail Blazers,0,PG,25,6月3日,195,Weber State,4236287.0
437,C.J. McCollum,Portland Trail Blazers,3,SG,24,6月4日,200,Lehigh,2525160.0
438,Luis Montero,Portland Trail Blazers,44,SG,23,6月7日,185,Westchester CC,525093.0
439,Mason Plumlee,Portland Trail Blazers,24,C,26,6月11日,235,Duke,1415520.0
440,Brian Roberts,Portland Trail Blazers,2,PG,30,6月1日,173,Dayton,2854940.0
441,Noah Vonleh,Portland Trail Blazers,21,PF,20,6月9日,240,Indiana,2637720.0
442,Trevor Booker,Utah Jazz,33,PF,28,6月8日,228,Clemson,4775000.0
443,Trey Burke,Utah Jazz,3,PG,23,6月1日,191,Michigan,2658240.0
444,Alec Burks,Utah Jazz,10,SG,24,6月6日,214,Colorado,9463484.0
445,Dante Exum,Utah Jazz,11,PG,20,6月6日,190,,3777720.0
446,Derrick Favors,Utah Jazz,15,PF,24,6月10日,265,Georgia Tech,12000000.0
447,Rudy Gobert,Utah Jazz,27,C,23,7月1日,245,,1175880.0
448,Gordon Hayward,Utah Jazz,20,SF,26,6月8日,226,Butler,15409570.0
449,Rodney Hood,Utah Jazz,5,SG,23,6月8日,206,Duke,1348440.0
450,Joe Ingles,Utah Jazz,2,SF,28,6月8日,226,,2050000.0
451,Chris Johnson,Utah Jazz,23,SF,26,6月6日,206,Dayton,981348.0
452,Trey Lyles,Utah Jazz,41,PF,20,6月10日,234,Kentucky,2239800.0
453,Shelvin Mack,Utah Jazz,8,PG,26,6月3日,203,Butler,2433333.0
454,Raul Neto,Utah Jazz,25,PG,24,6月1日,179,,900000.0
455,Tibor Pleiss,Utah Jazz,21,C,26,7月3日,256,,2900000.0
456,Jeff Withey,Utah Jazz,24,C,26,7-0,231,Kansas,947276.0

 

sites.py
import pandas as pd

读取json文件到dataframe   读取sites.json文件
json=pd.read_json('./sites.json')
print(json)
将数据保存为json文件 保存到data.json文件
data=[
    {
      "id": "A001",
      "name": "菜鸟教程",
      "url": "www.runoob.com",
      "likes": 61
    },
    {
      "id": "A002",
      "name": "Google",
      "url": "www.google.com",
      "likes": 124
    },
    {
      "id": "A003",
      "name": "淘宝",
      "url": "www.taobao.com",
      "likes": 45
    }
  ]
df=pd.DataFrame(data)
df.to_json('data.json')

 

toDataFramemy1.py

 

import pandas as pd
打印pandas的版本
print(__pd.version__)
定义字典制定series的索引
mydataset = {
    'sites':["Google","Runoob","Wiki"],
    'number':[1,2,3]
}
将字典转换为DataFrame,才能处理
mydf=pd.DataFrame(mydataset)
print(mydf)
将列表转换为series
a=[1,2,3]
给Series命名,默认name=None
mysr=pd.Series(a,name="number")
打印转换后的样子,其中显示了数据类型和自定义的列名
print(mysr)
根据索引1获取值(0开头)
print(mysr[1])
制定series的索引值  1
a = ["Google","Runoob","Wiki"]
myvar=pd.Series(a,index=["x","y","z"])
print(myvar["z"])
根据字典中的主键制定series的索引值  2
sites = {1:"Google",2:"Runoob",3:"Wiki"}
myvar2=pd.Series(sites)
print(myvar2[1])
给Series添加索引,不添加则默认索引为0开头
sites = {1:"Google",2:"Runoob",3:"Wiki"}
myvar3=pd.Series(sites,index=[1,2])
print(myvar3)
定义二维列表
data = [['Google',10],['Runoob',12],['Wiki',13]]
将列表转换为DataFrame,添加了列名
mydf=pd.DataFrame(data,columns=["name","age"])  单双引号都可以
将字典转换为DataFrame
data = {"Site":['Google','Runoob','Wike'],'Age':[10,12,13]}
mydf2=pd.DataFrame(data)
print(mydf2)
将列表转换为DataFrame
data = [{'a':1,'b':2},{'a':5,'b':10,'c':20}]
mydf3=pd.DataFrame(data)
print(mydf3)
将字典转换为DataFrame
data = {
    "calories":[420,380,390],
    "duration":[50,40,45]
}
mydf4=pd.dataFrame(data)
print(mydf4)
显示索引为1的值(0开头),并显示了索引和数据类型
print(mydf4.loc[[1,2]])
data = {
    "calories":[420,380,390],
    "duration":[50,40,45]
}
mydf5=pd.DataFrame(data,index=['row1','row2','row3'])
print("输出")
print(mydf5)
print("根据索引输出,并显示了索引和数据类型")
print(mydf5.loc['row1'])