pandas

import pandas as pd

import numpy as np

import matplotlib.pyplot as plt

mac_info = pd.read_csv('MacDB.dat')

print(mac_info.dtypes)

 

 

 

price        float64
title         object
detail        object
url           object
seller_id     object
dtype: object

 

mac_info.head(5)

 

 

	price	title	detail	url	seller_id
0	4300.0	现货可面交 全新MacBook Air VM2/CH 11.6寸	实力---现货200台苹果笔记本MacBookAirVM2/CH11.6寸,全新国行牛皮纸原...	//2.taobao.com/item.htm?id=562834898284	没侑爱...
1	4580.0	MacBook Air	银色，8+128g全套都在，盒子箱说保卡都在，去年8月在万象城官网价买的！成色99新！外观无...	//2.taobao.com/item.htm?id=560631743622	zj庞志...
2	4299.0	Macbook Air 8G内存	15年夏天买的，外壳有一点磕碰，完美主义者勿喷。顺丰或西安当面交易。接受小刀	//2.taobao.com/item.htm?id=540607495605	diana_...
3	6188.0	mac 苹果 macbook pro air 笔记本 retina 视网膜屏13寸	有13到15款视网膜屏a1502mf839等几台国行成色好.完美屏.电池完好.充电循环100...	//2.taobao.com/item.htm?id=562061895422	qq9981...
4	5000.0	macbook air	苹果笔记本电脑macbookair2015款gf213寸i5-1.6/8g/128固态原装苹...	//2.taobao.com/item.htm?id=563321529956	姗珊jz...

 

mac_info.tail(4)

 

	price	title	detail	url	seller_id
3996	4299.0	17寸超大屏幕MacBook Pro	17寸大屏幕MacBookProMD311配置i7-2.4G-4G-750G-HD6770独...	//2.taobao.com/item.htm?id=563118262968	qingsh...
3997	5588.0	MacBook Pro ME865视网膜屏	MacBookPro13.3寸ME865靓机，纯原机，视网膜2k屏幕设计专用，办公高大上，配...	//2.taobao.com/item.htm?id=562113058976	qingsh...
3998	6800.0	macbook pro 839 国行	2016款128g用了半个月。。无任何损坏。。换了工作用不上。原价9288元	//2.taobao.com/item.htm?id=549609299244	a56437...
3999	6600.0	2015款 MacBook Pro 13.3寸 256GB	老师自用Macbookpro13.3寸2015款，港版，发票无，边角有处小磕碰，已上图，正常...	//2.taobao.com/item.htm?id=562392569537	plmxs

 

print(mac_info.columns)

Index(['price', 'title', 'detail', 'url', 'seller_id'], dtype='object')

mac_info.loc[1]                                                     4580

title                                              MacBook Air
detail       银色，8+128g全套都在，盒子箱说保卡都在，去年8月在万象城官网价买的！成色99新！外观无...
url                    //2.taobao.com/item.htm?id=560631743622
seller_id                                              zj庞志...
Name: 1, dtype: object

 

 

print(mac_info.shape)

 

 

 

(4000, 5)

 

print(mac_info.loc[1:10])

 

     price                                      title  \
1   4580.0                                MacBook Air   
2   4299.0                           Macbook Air 8G内存   
3   6188.0  mac 苹果 macbook pro air 笔记本 retina 视网膜屏13寸   
4   5000.0                                macbook air   
5   4999.0              Apple MacBook Air 13.3英寸笔记本电脑   
6   4699.0                              苹果MacBook Air   
7   4000.0     MacBook air md711 i7 8G 256G高配苹果笔记本11寸   
8   4588.0                       17年的MacBook Air 128G   
9   4500.0                          Macbook Air 2016款   
10  5000.0                          macbook air 13.3寸   

                                               detail  \
1   银色，8+128g全套都在，盒子箱说保卡都在，去年8月在万象城官网价买的！成色99新！外观无...   
2              15年夏天买的，外壳有一点磕碰，完美主义者勿喷。顺丰或西安当面交易。接受小刀   
3   有13到15款视网膜屏a1502mf839等几台国行成色好.完美屏.电池完好.充电循环100...   
4   苹果笔记本电脑macbookair2015款gf213寸i5-1.6/8g/128固态原装苹...   
5   AppleMacBookAir13.3英寸笔记本电脑银色(2017新款Corei5处理器/8...   
6   苹果MacbookAirMacbookAir苹果电脑高配：i5处理器4G运行内存258G固态...   
7   95新成色不错功能正常无暗病配置Intel酷睿i7四代1.7Ghz处理器8G1600Mhz内...   
8   自己很小心在用了因为打不了游戏想换个台式机所以转手了实际使用次数少之又少都去网吧了..最近过...   
9                                    8G+128G。4500诚意转让   
10  17年6月购于京东，由于平时只是用来看看视频，所以想换个piad。平时工作都有电脑，这台放家...   

                                        url  seller_id  
1   //2.taobao.com/item.htm?id=560631743622    zj庞志...  
2   //2.taobao.com/item.htm?id=540607495605  diana_...  
3   //2.taobao.com/item.htm?id=562061895422  qq9981...  
4   //2.taobao.com/item.htm?id=563321529956    姗珊jz...  
5   //2.taobao.com/item.htm?id=561230162530  icyzha...  
6   //2.taobao.com/item.htm?id=561941022351  lamove...  
7   //2.taobao.com/item.htm?id=564024940549     怡轩数...  
8   //2.taobao.com/item.htm?id=563917739532     最爱唱...  
9   //2.taobao.com/item.htm?id=562039830652  ye1598...  
10  //2.taobao.com/item.htm?id=558799468026        欣欣辰  

 

col_price = mac_info['price']

print(col_price)

 

 

 

0       4300.0
1       4580.0
2       4299.0
3       6188.0
4       5000.0
5       4999.0
6       4699.0
7       4000.0
8       4588.0
9       4500.0
10      5000.0
11      4599.0
12      4800.0
13      5000.0
14      4500.0
15      4099.0
16      4200.0
17      5899.0
18      4680.0
19      4988.0
20      4199.0
21      5699.0
22      4500.0
23      4499.0
24      4250.0
25      6200.0
26      4600.0
27      5000.0
28      5199.0
29      4500.0
         ...  
3970    5600.0
3971    6500.0
3972    4100.0
3973    6500.0
3974    5100.0
3975    4866.0
3976    6200.0
3977    4100.0
3978    4699.0
3979    4699.0
3980    6666.0
3981    5688.0
3982    6666.0
3983    6000.0
3984    4586.0
3985    6800.0
3986    4000.0
3987    5580.0
3988    4000.0
3989    4500.0
3990    5200.0
3991    5500.0
3992    4700.0
3993    5000.0
3994    6000.0
3995    4388.0
3996    4299.0
3997    5588.0
3998    6800.0
3999    6600.0
Name: price, Length: 4000, dtype: float64