<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[s5151的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/s5151</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; s5151]]></copyright><item><title><![CDATA[SQL]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/119184576</link><guid>https://blog.youkuaiyun.com/s5151/article/details/119184576</guid><author>s5151</author><pubDate>Fri, 30 Jul 2021 22:23:30 +0800</pubDate><description><![CDATA[1,order by:排序用的 比如:order by 'grade' '姓名' DESC(降序),默认升序 先按照'grade',然后就是'姓名'

2,就算select没有选择某些列,下面依旧可以用某些列去排序
]]></description><category></category></item><item><title><![CDATA[sql教程 1-15]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/119154456</link><guid>https://blog.youkuaiyun.com/s5151/article/details/119154456</guid><author>s5151</author><pubDate>Wed, 28 Jul 2021 00:18:36 +0800</pubDate><description><![CDATA[1,sql是不分大小写的

2,USE:选择哪个数据库

3,select:选择数据库中的哪几行  *号表示全部

4,FROM:从数据库中哪个表提取

5,where:找出某个属性的某个值

6,order by:按照某一列排序

use sql_store;

select age age*1.3as '四个月后''#选择子句
from customers#选择子句
where customer_id = 1
order by first_name

AND的优先级大于OR

IN的用法:'t...]]></description><category></category></item><item><title><![CDATA[数据处理的一般步骤]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/119122617</link><guid>https://blog.youkuaiyun.com/s5151/article/details/119122617</guid><author>s5151</author><pubDate>Tue, 27 Jul 2021 00:44:34 +0800</pubDate><description><![CDATA[# import pandas as pd
#
# #步骤一:提出问题
# #步骤二:理解数据
# # 1,导入数据库:主要函数有:pd.read_csv() pd.read_excel()
# # 2,查看导入数据的基本情况:参数:dtypes,shape,values   函数有:head() type()
#
# # 步骤三:数据清洗(重点)
# # 1,选择子集:若数据中项目较多,可以选择其中一些
# # 2,列名重命名
# # 更改列名所用函数:a={'a':'b'} data.rename(c.]]></description><category></category></item><item><title><![CDATA[pandas]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/118981086</link><guid>https://blog.youkuaiyun.com/s5151/article/details/118981086</guid><author>s5151</author><pubDate>Thu, 22 Jul 2021 00:41:44 +0800</pubDate><description><![CDATA[import pandas as pd
# data=pd.read_csv(r"D:\学习资料\机器学习\小实验.txt",sep=' ',header=None,names=['a','b','c','d','e','f'])
# data.set_index('f',inplace=True)#把'f'这一列设为行
# print(data)
# data=pd.read_excel(r"D:\学习资料\机器学习\student_excel.xlsx",skiprows=2)
#
# data.dr.]]></description><category></category></item><item><title><![CDATA[pandas_day2]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/118900347</link><guid>https://blog.youkuaiyun.com/s5151/article/details/118900347</guid><author>s5151</author><pubDate>Mon, 19 Jul 2021 23:16:19 +0800</pubDate><description><![CDATA[继上次:

map函数:第一个参数为函数名,第二或更多,取决于你函数里面的参数.类型为可迭代对象

将传入的函数依次作用到序列的每个元素，并把结果作为新的Iterator

小细节:

filter函数:

好像与map函数差不多的作用,可能只是结果的输出不同.

lambda:是个匿名函数:实际上就是个函数

a=lambda x:x+2    x1=5

print(a(x1))








...]]></description><category></category></item><item><title><![CDATA[pandas_day1]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/118887165</link><guid>https://blog.youkuaiyun.com/s5151/article/details/118887165</guid><author>s5151</author><pubDate>Mon, 19 Jul 2021 01:11:57 +0800</pubDate><description><![CDATA[map函数:



lambda函数:



filter函数:还未理解

pandas内容:

#columns:列 index:行
#a.dtypes:每列的数据元素类型,sep:间断 head:前五行
#pandas可以读取csv,txt(和csv一样),Excel,MySQL文件:分别用,pd.read_csv(),pd.read_excel().pd.read_sql() 参数:sep:间断,header=None:没有标签的意思,name=[]:给出列名称







今天和家人出去玩...]]></description><category></category></item><item><title><![CDATA[numpyday 学习]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/118830777</link><guid>https://blog.youkuaiyun.com/s5151/article/details/118830777</guid><author>s5151</author><pubDate>Fri, 16 Jul 2021 23:38:00 +0800</pubDate><description><![CDATA[import numpy as np
a=np.array([[1,2,3],[2,3,4]],dtype=np.float32)
print(a[:,2],a.dtype,a.size,a.ndim,a.shape)#dtype:数据元素类型,size:数据总个数,ndim:维度,可以看方括号个数,shape:(2,3)
print(a[0:1,0:2])#前面是行,后面是列,参数中间用:
#type:返回的是数据结构类型，如list、dict、numpy.ndarray、pandas.core.fra.]]></description><category></category></item><item><title><![CDATA[数据挖掘第一天:学习matplotlib]]></title><link>https://blog.youkuaiyun.com/s5151/article/details/118741978</link><guid>https://blog.youkuaiyun.com/s5151/article/details/118741978</guid><author>s5151</author><pubDate>Thu, 15 Jul 2021 01:30:55 +0800</pubDate><description><![CDATA[今天学了matplotlib的一些基础,学会了散点图scatter,柱状图bar,直方图hist,折线图plot,饼图pie



import matplotlib.pyplot as plt
import random
x=range(1,32)
x1=['time:{}'.format(i) for i in x]
y_shanghai=[random.uniform(15,19) for i in range(1,32)]
y_beijing=[random.uniform(0,6) for i i]]></description><category></category></item></channel></rss>