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 file Words.txt is opened in read mode, and its content is read into a string.
The function iterates through each character in the file.
The isupper() method is used to check for uppercase letters, and the islower() method is used to check for lowercase letters.
Counts of uppercase and lowercase letters are maintained in separate variables and displayed after iteration.
Differentiate between 'w' and 'a' file modes in Python.
\[ \begin{array}{|c|c|c|c|} \hline \textbf{S\_id} & \textbf{S\_name} & \textbf{Address} & \textbf{S\_type} \\ \hline S001 & Sandhya & Rohini & Day Boarder \\ S002 & Vedanshi & Rohtak & Day Scholar \\ S003 & Vibhu & Raj Nagar & NULL \\ S004 & Atharva & Rampur & Day Boarder \\ \hline \end{array} \]
\[ \begin{array}{|c|c|c|} \hline \textbf{S\_id} & \textbf{Bus\_no} & \textbf{Stop\_name} \\ \hline S002 & TSS10 & Sarai Kale Khan \\ S004 & TSS12 & Sainik Vihar \\ S005 & TSS10 & Kamla Nagar \\ \hline \end{array} \]
Ms. Veda created a table named Sports in a MySQL database, containing columns Game_id, P_Age, and G_name.
After creating the table, she realized that the attribute Category has to be added.
Help her to write a command to add the Category column.
Thereafter, write the command to insert the following record in the table: Game_id: G42 P\_Age: Above 18 G_name: Chess Category: Senior
Write a user-defined function in Python named Puzzle(W, N) which takes the argument W as an English word and N as an integer and returns the string where every Nth alphabet of the word W is replaced with an underscore ("_").
Example: If W contains the word "TELEVISION" and N is 3, then the function should return the string "TE_EV_SI_N". Likewise, for the word "TELEVISION" if N is 4, the function should return "TEL_VIS_ON".

