Which function category is not in Excel 2016?
2 answers:
You might be interested in
Answer:
I am writing a Python program that deletes players from the file whose names whose names do not begin with a vowel which means their names begin with a consonant instead. Since the SomePlayers.txt is not provided so i am creating this file. You can simply use this program on your own file.
fileobj= open('SomePlayers.txt', 'r')
player_names=[name.rstrip() for name in fileobj]
fileobj.close()
vowels = ('a', 'e', 'i', 'o', 'u','A','E','I','O','U')
player_names=[name for name in player_names
if name[0] in vowels]
fileobj.close()
print(player_names)
Explanation:
I will explain the program line by line.
First SomePlayers.txt is opened in r mode which is read mode using open() method. fileobj is the name of the file object created to access or manipulate the SomePlayers.txt file. Next a for loop is used to move through each string in the text file and rstrip() method is used to remove white spaces from the text file and stores the names in player_names. Next the file is closed using close() method. Next vowels holds the list of characters which are vowels including both the upper and lower case vowels.
player_names=[name for name in player_names
if name[0] in vowels]
This is the main line of the code. The for loop traverses through every name string in the text file SomePlayers.txt which was first stored in player_names when rstrip() method was used. Now the IF condition checks the first character of each name string. [0] is the index position of the first character of each players name. So the if condition checks if the first character of the name is a vowel or not. in keyword is used here to check if the vowel is included in the first character of every name in the file. This will separate all the names that begins with a vowel and stores in the list player_names. At the end the print statement print(player_names) displays all the names included in the player_names which begin with a vowel hence removing all those names do not begin with a vowel.
