very well explained.

Hi Manish, def find_distinct_name(file_path,action): try: file = open(file_path, action) lines = file.read().splitlines() name = [] if len(lines)==0: raise Exception("the file is empty") else: for i in range(1,len(lines)): line = lines[i] words = line.split(",") name.append(words[1]) name_list = set(name) print(name_list) except Exception as e: print(e) find_distinct_name("details.txt", "r") o/p = {'"Manish"', '"Rohan"', '"Simaran"', '"Manish'} when reading the file using read option. All the lines are getting converted into strings and when i use split method to get list from lines. I am getting data as "Manish" and "Manish, instead of error. Please let me know if there is a way to read data from txt file along with data type.

👍

sir how to practice python for data analyst

Hi bro.. can you please share the topics required in python for data engineer

import pandas as pd def unique_values(path, column_name): try: df = pd.read_csv(path) name = df[f"{column_name}"] return set(name) except FileNotFoundError: print("The File is not available at given path") raise Exception("Please check the path provided") except KeyError: raise Exception("Please provide the correct column name") except Exception as e: if (str(e) == 'No columns to parse from file'): raiseException('The file is empty, No columns found') try: output = unique_values(path="C:/Desktop/NewFolder/names.csv",column_name="name") except Exception as e: print(e) print(f"The list of unique values are : {list(output)}")

Is that you in DP?

import os filename = r'C:\Users\homeuser\Documents\de prjs\Python\manish\user_info.txt' name_list = [] try: if os.path.getsize(filename) == 0: raise Exception("Empty File") else: with open(filename,'r') as handler: # read next line next(handler) # rstrip to remove '/n at end of line, split at , and name is at position 1 for line in handler: name_element = line.rstrip().split(',')[1] if not(name_element.startswith('"') and name_element.endswith('"')): raise ValueError(f"Name is not properly quoted : {name_element}") name_list.append(name_element) print(set(name_list)) handler.close() except FileNotFoundError: print("File cannot be opened: ", filename) except ValueError as e: print(e) except Exception as e: print(e)