Python基础——数据分析考核(基础版本)

数据生成文件：

类名：【GetRandomInfo.py】

import random


def getClassName():
randomClass = ("天字一号", "地字一号", "玄字一号", "黄字一号", "东宫正品")
return randomClass[int(random.random() * len(randomClass))]


def getName():
"""随机姓名"""
randomNames = (
"华", "韦", "覃", "琴", "湘", "", "钱", "彭", "邓" "张", "王", "里", "赵", "赵", "李", "春", "梦", "星", "二", "宿", "管", "土", "生",
"风", "胡")
return str.format("{0}{1}{2}", randomNames[int(random.random() * len(randomNames))],
randomNames[int(random.random() * len(randomNames))],
randomNames[int(random.random() * len(randomNames))])


def getSex():
"""随机性别"""
sex = ("男", "男", "女")
return sex[int(random.random() * 3)]


def getSubJectName():
"""随机科目"""
randomClass = ("java", "python", "C#", "php", "go")
return randomClass[int(random.random() * len(randomClass))]


def getResults():
"""随机成绩"""
return int(random.random() * 41)+60


def GetRandomInfo():
"""获取500条随机信息"""
data = []
for index in range(1, 501):
strInfo = str.format("{0} {1} {2} {3} {4} {5}", index, getClassName(), getName(), getSex(), getSubJectName(),
getResults())
data.append(strInfo.split(","))
return data

写入【csv】测试信息：

类名：【WriteCsv.py】

import csv
import GetRandomInfo

# 文件获取
file = open('info.csv', 'w+', encoding="utf-8")
# 写入操作
writer = csv.writer(file)

# 写入多行记录
writer.writerows(GetRandomInfo.GetRandomInfo())

# 刷新文件
file.flush()

# 关闭文件流
file.close()

读取【csv】测试数据：

类名：【ReadCsv.py】

import csv

# 文件获取
file = open('info.csv', 'r', encoding="utf-8")
# 内容读取
list1 = csv.reader(file)
# 计数器
countBoy = 0
countGirl = 0
CountJava = 0
SumBoyResults = 0
SumGirlResults = 0
# 信息遍历
for line in list1:
if len(line) != 0:
for row in line:
arr = row.split(" ")
if arr[3] == "男":
countBoy += 1
SumBoyResults += int(arr[5])
else:
countGirl += 1
SumGirlResults += int(arr[5])
if arr[4] == "java":
CountJava += 1

print("男孩数量:", countBoy)
print("女孩数量:", countGirl)
print("男孩平均成绩：", "%.2f" % (SumBoyResults / countBoy))
print("女孩平均成绩：", "%.2f" % (SumGirlResults / countGirl))
print("java班共计：", CountJava, "人")

简单数据分析：

【文章原创作者：美国服务器 https://www.68idc.cn处的文章,转载请说明出处】