- 博客(7)
- 收藏
- 关注
原创 【Python】Introductory Python Programming Problems
Coursework 1:Introductory Python Programming ProblemsQuestionsThis coursework is divided into 5 parts. You should try to answer all parts. Your answer for each part should be in a separate Python program file. Template files are provided for each par
2020-08-13 09:45:29 113
原创 【Python】Assessing the strength of a password
# -*- coding: utf-8 -*-"""Created on Sat Oct 19 17:55:27 2019@author: shark"""print( "*Password Strength Assessment Program*" )password = input( "Enter the password you want to test: " )if len(password)<8: strength="WEAK"elif len(passwo..
2020-08-13 09:44:06 165
原创 【Python】Anonymise a string.
# -*- coding: utf-8 -*-"""Created on Sat Oct 19 17:55:27 2019@author: shark"""print( "*Password Strength Assessment Program*" )password = input( "Enter the password you want to test: " )if len(password)<8: strength="WEAK"elif len(passwo..
2020-08-13 09:42:46 154
原创 【Python】 Count the different vowels in a string. 不同元音数量
# -*- coding: utf-8 -*-"""Created on Sat Oct 19 12:37:04 2019@author: shark"""print("This code should compute the number of vowels in a string.")input_string = input( "Enter a string (e.g. your name): " )a = "a"A = "A"e = "e"E = "E"i = "...
2020-08-13 09:40:42 293
原创 【python】Count the vowels in a string.元音数量
# -*- coding: utf-8 -*-"""Created on Sat Oct 19 11:42:25 2019@author: shark"""print("This code should compute the number of vowels in a string.")input_string = input( "Enter a string (e.g. your name): " )a = "a"A = "A"e = "e"E = "E"i = ...
2020-08-13 09:38:59 363
原创 【Excel小技巧】若干列数据中最大值
【条件】有3列数据,选择其中最大值填充到第4列【问题】当时第一想法就是max函数Sub kk()Dim i As IntegerFor i = 1 To 5Cells(i, 4) = Max(Cells(i, 1):Cells(i, 3))NextEnd Sub结果错误【错误提示】【修改】是不是函数不能嵌套?修改一下Sub kk()Dim i,a,b,cAs IntegerFor i = 1 To 5a = Cells(i, 1)b ..
2020-08-10 09:27:02 446
原创 【Excel小技巧】多列数据合并
在另外一列进行数据合并,假设要合并A和B列的数据方法很简单,只要在C1中输入“=A1&B1”,按回车键,C1列的内容就是A1、B1两列的和了。然后,选中C1单元格,用鼠标指向单元格右下角,当光标变成"+"后,按住鼠标拖动光标向下拖到要合并的结尾行处,就完成了A列和B列的合并。但是如果数据较多几万条数据时,最好用VBASub kk()Dim i As IntegerFor i = 1 To 1115Cells(i, 5) = Cells(i, 1)& Cells(i
2020-08-06 13:59:44 373
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人