- 博客(19)
- 收藏
- 关注
原创 职场利器CTRL+E
版本:EXCEL2016适用:Windows10在数据源有规律的前提下,先输入一个“样本”, Excel会自动判断其中的逻辑关系,按组合键 “Etrl+E” 全部返回需要的结果。 可以帮我们实现很多之前只能使用复杂函数才能实现的功能,秒完成工作。案例一:案例二:案例三:案例四:使用注意事项:1、能够处理的数据,一定需要是有规律的数据,无序的内容,无法完美处理;2、在提取或合并字符串方面,首行被操作的数据中,不能有重复的数据,CTRL+E只认为是将左侧开始的第一次出现的数据输入N次,
2021-03-25 13:17:40
168
原创 Mysql经典45道题目
此次练习主要有以下四个表:学生表:Student(s_id,s_name,s_birth,s_sex) – –学生编号,学生姓名, 出生年月,学生性别课程表:Course(c_id,c_name,t_id) – –课程编号, 课程名称, 教师编号教师表:Teacher(t_id,t_name) – –教师编号,教师姓名成绩表:Score(s_id,c_id,s_s_score) – –学生编号,课程编号,分数在开始之前,我们需要先把4张表之间的关联关系搞清楚了(最好的办法是自己在草稿纸上画
2021-03-25 12:49:16
352
原创 利用pandas创建excel文件!
Spyder (python 3.7)练习内容:1、创建一个空的EXCEL表2、进行数据填充3、将默认的索引改成以ID为索引首先,先确认是否有安装库pandas,如没有按如下操作进行:1.下载并安装 Anaconda (里面含Spyder)2. 在开始中找到Anaconda Prompt并且打开3.安装pandas : pip install pandas4.检测是否安装成功:import pandas as pd如果都没问题的话 就可以开始搬砖吧!1、创建一个空的EXCEL表并在
2020-07-15 16:16:24
3767
原创 Learn Python The Hard Way (习题14)
习题 14: 提示和传递参考上一习题的做法!1.新建一个文件,文件的名称为temp.py2.将下面的代码复制到文件中from sys import argv script,user_name = argv prompt = '> ' print("Hi %s,I'm the %s script."%(user_name,script))print("I'd like to ask you a few questions.")print("Do you like me %s?"
2020-07-14 14:57:17
83
原创 Learn Python The Hard Way (习题13)
习题 13: 参数、解包、变量from sys import argv# argv 是所谓的“参数变量(argument variable)script, first, second, third = argv # 将 argv 解包(unpack)print("The script is called: ", script)print("Your first variable is:", first)print("Your second variable is: ", second)
2020-07-14 13:59:40
227
原创 Learn Python The Hard Way (习题12)
习题 12: 提示别人age = input("How old are you? ")height = input("How tall are you? ")weight = input("How much do you weigh? ")print("So, you're %r old, %r tall and %r heavy." % ( age, height, weight) )运行结果:How old are you? 18How tall are you? 160Ho
2020-07-12 21:27:17
68
原创 Learn Python The Hard Way (习题11)
习题 11: 提问print("How old are you?",)age = input()print("How tall are you?",)height = input()print("How much do you weigh?",)weight = input()print("So, you're %r old, %r tall and %r heavy." % ( age, height, weight))运算结果 :How old are you?18How
2020-07-12 21:04:01
71
原创 Learn Python The Hard Way (习题10)
习题 10: 那是什么?tabby_cat = "\tI'm tabbed in."persian_cat = "I'm split\non a line."backslash_cat = "I'm \\ a \\ cat."fat_cat = """ I'll do a list: \t* Cat food \t* Fishies\t* Catnip\n\t* Grass """print(tabby_cat)print(persian_cat)print(backslash_ca
2020-07-12 19:48:10
49
原创 Learn Python The Hard Way (习题9)
习题 9: 打印,打印,打印# Here's some new strange stuff, remember type it exactly.days = "Mon Tue Wed Thu Fri Sat Sun"months = "Jan\nFeb\nMar\nApr\nMay\nJun\nJul\nAug"print("Here are the days: ", days)print("Here are the months: ", months)print(""" There's so
2020-07-12 19:42:31
65
原创 Learn Python The Hard Way (习题8)
习题 8: 打印,打印formatter = "%r %r %r %r"print(formatter % (1, 2, 3, 4))print(formatter % ("one", "two", "three", "four"))print(formatter % (True, False, False, True))print(formatter % (formatter, formatter, formatter, formatter))print(formatter % ( "
2020-07-12 19:36:29
85
原创 Learn Python The Hard Way (习题7)
习题 7: 更多打印print("Mary had a little lamb.")print("Its fleece was white as %s." % 'snow')print("And everywhere that Mary went.")print("."* 10) # what'd that do?end1 = "C"end2 = "h"end3 = "e"end4 = "e"end5 = "s"end6 = "e"end7 = "B"end8 = "u"end
2020-07-12 19:21:43
78
原创 Learn Python The Hard Way (习题6)
习题 6: 字符串(string)和文本x = "There are %d types of people." % 10binary = "binary"do_not = "don't"y = "Those who know %s and those who %s." % (binary, do_not)print(x)print(y)print("I said: %r." % x)print("I also said: '%s'." % y)hilarious = Falsejoke_
2020-07-12 19:10:35
67
原创 Learn Python The Hard Way (习题5)
习题 5: 更多的变量和打印my_name = 'Zed A. Shaw'my_age = 35 # not a liemy_height = 74 # inchesmy_weight = 180 # lbsmy_eyes = 'Blue'my_teeth = 'White'my_hair = 'Brown'print("Let's talk about %s." % my_name)print("He's %d inches tall." % my_height)print("
2020-07-12 15:13:14
69
原创 Learn Python The Hard Way (习题4)
习题 4: 变量(variable)和命名cars = 100space_in_a_car = 4.0drivers = 30passengers = 90cars_not_driven = cars - driverscars_driven = driverscarpool_capacity = cars_driven * space_in_a_caraverage_passengers_per_car = passengers / cars_drivenprint("There ar
2020-07-12 15:04:58
139
原创 Learn Python The Hard Way (习题3)
习题 3: 数字和数学计算这章练习里有很多的数学运算符号。我们来看一遍它们都叫什么名字。你要一边 写一边念出它们的名字来,直到你念烦了为止。名字如下:运算符说明实例结果+加12 + 1527-减4 - 13*乘5 * 3.618.0/除7 / 23.5//整除7 // 23%取余7 % 21**幂2 ** 416print("I will now count my chickens:")prin
2020-07-12 14:56:29
87
原创 Learn Python The Hard Way (习题2)
程序里的注释是很重要的。它们可以用自然语言告诉你某段代码的功能是什么。 在你想要临时移除一段代码时,你还可以用注解的方式将这段代码临时禁用。接下来的练习将学会注释:# A comment, this is so you can read your program later.# Anything after the # is ignored by python.print("I could have code like this." ) # and the comment after is ignor
2020-07-12 14:17:36
100
原创 Learn Python The Hard Way (习题1)
虽然前期已通过自学,完成了python基础部份的学习,但是对于实践方面的实操较少。为了让自己在读下一本编程书籍前打下良好的基础,通过《笨办法学python》这本书复习并提高自已的编程能力,以跑例子为主,并进行相关知识点的归纳总结。(pycharm,版本是python3.8。)Python3与Python2在使用print时区别在于是否需要添加()。> 习题 1: 第一个程序print ("Hello World!")print ("Hello Again" )print ("I like
2020-07-12 13:41:28
122
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人