python_car_可视化

#! /usr/bin/env python
#coding=utf-8
import pandas as pd
import numpy as np
#import ggplot
import matplotlib.pyplot as plt
path="F:/Data/exe/vehicles.csv"
vehicles=pd.read_csv(path)
#print(len(vehicles))
#print(vehicles.columns)
#print(pd.unique(vehicles.year))#pd.unique
#print(max(vehicles.year))
#rint(min(vehicles["year"]))#列的两种表示方法
#print(pd.value_counts(vehicles.fuelType1))#返回每个变量不同值发生次数总数
#print(pd.value_counts(vehicles["trany"]))
vehicles["trany2"]=vehicles["trany"].str[0]#取第一个字符
#print(pd.value_counts(vehicles.trany2))
grouped=vehicles.groupby("year")#按年份分组
averaged=grouped["comb08","highway08","city08"].agg([np.mean])#