njsharkcat-CSDN博客

原创【Python】Introductory Python Programming Problems

Coursework 1: Introductory Python Programming Problems Questions This 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 99

原创【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 151

原创【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 141

原创【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 276

原创【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 344

原创【Excel小技巧】若干列数据中最大值

【条件】有3列数据，选择其中最大值填充到第4列【问题】当时第一想法就是max函数 Sub kk() Dim i As Integer For i = 1 To 5 Cells(i, 4) = Max（Cells(i, 1):Cells(i, 3)） Next End Sub 结果错误【错误提示】【修改】是不是函数不能嵌套？修改一下 Sub kk() Dim i,a,b,cAs Integer For i = 1 To 5 a = Cells(i, 1) b ..

2020-08-10 09:27:02 420

原创【Excel小技巧】多列数据合并

在另外一列进行数据合并，假设要合并A和B列的数据方法很简单，只要在C1中输入“=A1&B1”，按回车键，C1列的内容就是A1、B1两列的和了。然后，选中C1单元格，用鼠标指向单元格右下角，当光标变成"+"后，按住鼠标拖动光标向下拖到要合并的结尾行处，就完成了A列和B列的合并。但是如果数据较多几万条数据时，最好用VBA Sub kk() Dim i As Integer For i = 1 To 1115 Cells(i, 5) = Cells(i, 1)& Cells(i

2020-08-06 13:59:44 352

njsharkcat的博客