Write a function, c_words(), in Python that separately counts and displays the number of uppercase and lowercase alphabets in a text file, Words.txt
def c_words():
# Open the file Words.txt in read mode
with open("Words.txt", "r") as file:
content = file.read() # Read the entire content of the file
upper_count = 0 # Initialize uppercase count
lower_count = 0 # Initialize lowercase count
# Iterate through each character in the content
for char in content:
if char.isupper(): # Check for uppercase letters
upper_count += 1
elif char.islower(): # Check for lowercase letters
lower_count += 1
# Display the counts
print(f"Uppercase letters: {upper_count}")
print(f"Lowercase letters: {lower_count}")
Explanation:
The script opens Words.txt for reading and loads its entire content. It then proceeds to examine each character within the content. The isupper() method identifies uppercase letters, while islower() identifies lowercase letters. The script maintains separate counters for both uppercase and lowercase letters and presents these counts upon completion of the character iteration.The SELECT statement when combined with \(\_\_\_\_\_\_\) clause, returns records without repetition.
In SQL, the aggregate function which will display the cardinality of the table is \(\_\_\_\_\_\).
myStr = "MISSISSIPPI"
print(myStr[:4] + "#" + myStr[-5:])