Solving Word Cookies Puzzles: A Python Adventure

import osimport csvimport reimport pandas as pd# define folder pathsinput_folder = 'c:\users\zenbook\desktop\word lists in csv'output_folder = 'c:\users\zenbook\desktop\word list output'# function to find words of specific lengths in textdef find_words_of_length(text, length):    words = re.findall(r'w+', text)    return [word for word in words if len(word) == length]# initialize dictionaries to store words of each lengthwords_by_length = {3: set(), 4: set(), 5: set(), 6: set(), 7: set()}# loop through all csv files in the input folderfor filename in os.listdir(input_folder):    if filename.endswith('.csv'):        filepath = os.path.join(input_folder, filename)        # read each csv file with a fallback encoding        with open(filepath, 'r', encoding='iso-8859-1') as file:            reader = csv.reader(file)            for row in reader:                # loop through each cell in the row                for cell in row:                    for length in words_by_length.keys():                        words = find_words_of_length(cell, length)                        words_by_length[length].update(words)# save words of each length to separate csv filesfor length, words in words_by_length.items():    output_file = os.path.join(output_folder, f'{length}_letters.csv')    with open(output_file, 'w', newline='', encoding='utf-8') as file:        writer = csv.writer(file)        for word in sorted(words):  # sort words for neatness            writer.writerow([word])print("words have been saved to separate csv files based on their length.")

import csv# Define the string to check againstcheck_string = 'langaur'# Define the folder path for CSV filesinput_folder = 'C:\Users\Zenbook\Desktop\Word list output'# Function to check if all letters in word can be found in check_stringdef is_word_in_string(word, check_string):    # Check if each letter in the word is in the string    for letter in word:        if word.count(letter) > check_string.count(letter):            return False    return True# Check words for 3, 4, 5, 6 and 7-letter CSVsfor length in [3, 4, 5, 6, 7]:    input_file = f'{input_folder}/{length}_letters.csv'    print(f"Length {length}:")    with open(input_file, 'r', encoding='utf-8') as file:        reader = csv.reader(file)        found_words = []        for row in reader:            word = row[0].strip()  # Remove any extra whitespace            if is_word_in_string(word, check_string):                found_words.append(word)        # Print all found words for the given length        for i in found_words:            print(i)