Need your suggestions in Data Analytics project in python 🙏🙏

Hi all Analytics folks,

I need your help, suggestion and whatever you can in python project in data analytics. I have a couple of doubts in it.

I'm a data analyst having 2 year of experience while i know python but never worked in it. I used SAS and SQL. I'm giving interviews since couple of months and I'm realizing interviewers aren't so happy from the project i did in my company, it's sort of reconciliation ane validation.

1. Now I want to build some portfolio project in python specifically in data analytics(excluding any ML algorithms) but unable to find any. I'm searching projects in marketing customer segmentation and risk analytics but i found everyone is using ML in these projects.

Can't it be done without using ML or I'll have to use ML algos and core stats in building portfolio project.

2. What you guys do in your day to day work in python. Ratio of your work in python, sql, excel and other tech stacks. Excluding ML coz I'm not focusing on it for now.

Note: pls help your buddy 🙏🙏