I Quit Coding - How I use ChatGPT instead as Data Analyst 

AI has become a topic of discussion for everyone, with people on online platforms explaining its capabilities. However, it is important to realize that AI applications have already started to become widespread and could potentially consume our minds. Soon, people may depend entirely on AI, as machines are now capable of learning. Rather than solely discussing the benefits of AI. @CodingIsFun: You are good content creator, but your last videos (6-8 videos) are talking about the solution using AI only, So it will be eat human mind gradually. It would be beneficial to also explore ways in which we can outsmart and overcome it.

Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 🤩

Glad you liked it. Thanks for watching. ♥

Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 😃

My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍

Thanks for watching! Haha, I'm right there with you on being the robots' best friend - I even use "please" in my prompts, just in case 😅

​@@CodingIsFun Yay! I sensed that you did, but wasn't sure whether to ask 😊

Thanks for watching and asking! I haven't really compared the GPT-3.5 and GPT-4 models in terms of code generation. But, in general, the GPT-4 model is usually better with longer prompts and conversations, and it makes fewer mistakes too.

My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

Thanks for watching. I do have the ChatGPT Plus subscription, but as mentioned in the video (2:22 min), for all examples I have used the free GPT-3.5 model.

Thanks for watching and throwing in your two cents. 👍

Given enough time and progress with ai, probably not if everyone has access to this. I have access to a lot of plugins and am a data analyst, and I can see a future where many are not needed. I don't think this would happen overnight though.. I could do everything in this video with code interpreter in less than 5 mins. If this tool(code interpreter) or something similar was connected to a datasource, an end user could just prompt for whatever data question they had I mind.. furthermore, at some point, the system could deliver this information unprompted.

@@brando2818 as a data analyst, do you think this job will even exist in the future? It is really difficult to predict what jobs will be eradicated by AI, and me being a college student, I am really interested in knowing what I should do to prevent getting caught in this "AI trap"

Hey, thanks for watching and your great question! I haven't tried the ChatGPT code interpreter plugin yet, but once I get the chance, I'll definitely check it out and let you know what I think. I've seen a couple of comments asking about how data roles might change with all these AI advancements. Maybe I'll make a video to share my thoughts on that. In a perfect world, if all data were super organized (like in a data warehouse), AI tools would be amazing at analyzing data, creating charts, and stuff like that. But in real life, most data is kind of all over the place, spread across a ton of Excel files. And if you need data from different departments, that's probably even more files to deal with. A lot of my colleagues spend a lot of time just working with Excel to get things ready for analysis. So, considering all this, I think data engineers might become even more important in the future. And at least for the next few years, I believe we'll still need humans to guide AI and present data to the higher-ups. The world of data is always changing, but if you've got a solid foundation in data engineering and analysis and can adapt to new tech, you should be in a good spot to handle whatever comes your way. But that's just my personal opinion.

@@CodingIsFun I will be looking forward to the code interpreter video!

Data analysts will be there, but the number will decline. Teams consisting of 10 can be easily reduced to 3 with AI

That's a pity! :(

Thanks for watching. I am using VS Code

@@CodingIsFun Perfect! Thanks! keep up the good work!

Thanks for tuning in! While I don't have a specific video addressing your query, I do have one where I demonstrate how to search and replace text in multiple Excel files. It could be a helpful starting point! Feel free to give it a watch here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Uyw9fjDKYQY.html Happy Coding! 🤓

@@CodingIsFun thanks man ! will try it out and let you know

@@CodingIsFun here is the code that chatGPT gave, can you look at this and indicate what is issue is?: import os from openpyxl import load_workbook from openpyxl.utils import column_index_from_string, get_column_letter # Path to directory containing all excel files folder_path = r'C:\Users\user\Downloads\Sheets_B_O' # Search terms in cell 1 olt_card_search_term = 'OLT CARD-PORT' olt_slot_search_term = 'OLT SLOT' fat_search_term = 'FAT' # Loop through each file in the directory for filename in os.listdir(folder_path): if not filename.endswith('.xlsx'): continue # Skip non-excel files # Load the workbook wb = load_workbook(os.path.join(folder_path, filename)) # Initialize a flag to indicate if any sheet contains the search terms found_search_terms = False # Loop through each sheet in the workbook for sheet in wb: # Initialize variables olt_card_col = None olt_slot_col = None # Find the index of the first row that contains the search term for row in sheet.iter_rows(min_row=1, max_row=1): for cell in row: if olt_card_search_term in str(cell.value): olt_card_col = cell.column print(f"Found {olt_card_search_term} in column {get_column_letter(olt_card_col)} of sheet {sheet.title}") elif olt_slot_search_term in str(cell.value): olt_slot_col = cell.column print(f"Found {olt_slot_search_term} in column {get_column_letter(olt_slot_col)} of sheet {sheet.title}") # Check if columns were found if olt_card_col is not None and olt_slot_col is not None: found_search_terms = True # Copy OLT CARD-PORT and OLT SLOT columns to columns A and B, respectively for i in range(1, sheet.max_row + 1): sheet.cell(row=i, column=1).value = sheet.cell(row=i, column=olt_card_col).value sheet.cell(row=i, column=2).value = sheet.cell(row=i, column=olt_slot_col).value # Copy FAT column to column C for column in sheet.columns: cell_1 = column[0] if str(cell_1.value) == fat_search_term: found_search_terms = True for i in range(1, sheet.max_row + 1): sheet.cell(row=i, column=3).value = column[i - 1].value print(f"Found {fat_search_term} in column C of sheet {sheet.title}") break # Stop searching for FAT once found # Delete all other columns except A, B and C for column in reversed(range(4, sheet.max_column + 1)): for cell in sheet[column]: cell.value = None # Delete all other columns except A, B and C for column in reversed(range(4, sheet.max_column + 1)): if any(column in merged for merged in sheet.merged_cells.ranges): continue # Skip merged cells for cell in sheet[column]: cell.value = None # Rename the workbook if any of the sheets contain the search terms if found_search_terms: new_filename = f"NEW_{filename}" os.rename(os.path.join(folder_path, filename), os.path.join(folder_path, new_filename)) print(f"Workbook renamed to '{new_filename}'") # Save the modified workbook if found_search_terms: # Create a new file name by appending 'MODIFIED' to the original file name new_filename = os.path.splitext(filename)[0] + '_MODIFIED.xlsx' wb.save(os.path.join(folder_path, new_filename)) print(f"Workbook saved as {new_filename}") else: wb.save(os.path.join(folder_path, filename)) print("Workbook saved without modification") error in python IDE: C:\Users\user\PycharmProjects\pythonProject\OLTExcelparsing\venv\Scripts\python.exe C:/Users/user/PycharmProjects/pythonProject/OLTExcelparsing/venv/excelparsing4OLT.py Found OLT CARD-PORT in column D of sheet JCA00209 Traceback (most recent call last): File "C:\Users\user\PycharmProjects\pythonProject\OLTExcelparsing\venv\excelparsing4OLT.py", line 65, in if any(column in merged for merged in sheet.merged_cells.ranges): File "C:\Users\user\PycharmProjects\pythonProject\OLTExcelparsing\venv\excelparsing4OLT.py", line 65, in if any(column in merged for merged in sheet.merged_cells.ranges): File "C:\Users\user\PycharmProjects\pythonProject\OLTExcelparsing\venv\lib\site-packages\openpyxl\worksheet\merge.py", line 137, in __contains__ return coord in CellRange(self.coord) File "C:\Users\user\PycharmProjects\pythonProject\OLTExcelparsing\venv\lib\site-packages\openpyxl\worksheet\cell_range.py", line 263, in __contains__ cr = self.__class__(coord) File "C:\Users\user\PycharmProjects\pythonProject\OLTExcelparsing\venv\lib\site-packages\openpyxl\worksheet\cell_range.py", line 51, in __init__ if "!" in range_string: TypeError: argument of type 'int' is not iterable Process finished with exit code 1

Thanks for watching! In the video, I didn't actually share any real data, just talked about its structure. As for your question, I agree that sharing sensitive company data with ChatGPT isn't a good idea. It's best to keep your data secure and not risk it becoming part of the AI's knowledge.

Glad I could help! Thanks for watching and for the kind words. ♥

Hey Jonas Alderson! Thanks for watching and your excellent question. Predicting the future is always a challenge (even for a Data Analyst 😅), and I can't say for certain how Data roles will transform. That said, I believe humans will continue to make the final decisions and present data to management. As no/low code tools with AI capabilities keep advancing, the tasks of collecting and cleaning data might evolve. As demonstrated in my video, Data Analysts could end up being more like "directors" of data, focusing less on coding and more on guiding the tools. So, while the future's uncertain, being adaptable and embracing new tech will always be a plus in the data analysis world. At the end of the day, it's still up to you whether you want to dive into the data analyst world and learn the existing tools and new technologies. Just remember, this is only my humble opinion.

Ask ChatGPT this question 😂. For real though - yes, it's worthwhile, but do it with AI! There has to be humans in charge of knowing what they want AI to do, and you can be the first gen of analyst that's a native user, and come out stronger through the transition to an AI-driven economy. Most people and companies are not even close to ready for, or even aware of AI, and they need you to know all that and more. Put another way, even if AI could do the analysis, your bosses and customers still don't know what to do with the results. Anything you can learn can be valuable.

No need. You don't need to know object oriented programming for data analysis.

In my opinion, it really depends on the specific requirements of the Data Analyst role you're aiming for. While I am not a software developer myself and don't consider myself an expert in Python, I do think it's worthwhile to learn the basics of Python, especially popular plotting and data wrangling libraries, in order to be proficient in data analysis. As I mentioned in the video at the 11:01 mark, understanding the code generated by ChatGPT is important in order to ensure that you don't accidentally harm your computer or data. Additionally, having a good grasp of Python can help you to create better prompts and leverage AI tools to your advantage.

@@CodingIsFun excellent, thanks for both the great content and this explanation

It's not a prerequisite to applying, but I think you'd only feel regret if you were at a job that won't let you have the right tools (many corp & gov jobs). If you can use Python, you should learn it, if only for scripting / automating your own tasks. Excel and SQL are bigger deal breaker skills IMO, where you can't do jobs without them; no matter what tool you use for analysis, you have to be able to get to the data to begin with, however it is stored.

Thank you guys

I don't know what you mean

Thanks for watching. Totally agree, it's not smart to share sensitive data with ChatGPT. Better to play it safe and keep your data secure, so it doesn't end up as part of the AI's knowledge.

@@CodingIsFun Yes, not to mention your boss wouldn't be happy if you shared the company's secrets :)