Hello Krishna,

I'm encountering an issue when attempting to download the below mentioned file from your repository. I've followed the usual steps for downloading this file, but it doesn't seem to be working as expected.

https://github.com/krishnaik06/The-Grand-Complete-Data-Science-Materials/blob/main/Complete%20MySQL%20Interview%20Materials/Complete%20SQL%20Basics%20To%20Advance%20Guide.pdf

Please look into it.

Thanks
Baiju

Hi @krishnaik06 ,

I hope this message finds you well.
I'm writing to follow up on my previous pull request #36 to remove the venv directory from the repository. I noticed that the venv directory is still included in the repository, and I wanted to kindly request that you review and merge my pull request at your earliest convenience.

The venv directory, which contains Python-specific dependencies, should not be tracked by Git. Including this directory can cause several issues, including increased repository size and conflicts when cloning or pulling the repository.

Removing the venv directory will ensure that the repository is as clean and user-friendly as possible for everyone to use.

Thank you for your time and consideration.

In the 'Complete Statistics' folder, the files named "stat1.pdf","stat2.pdf","stat3.pdf","stat5.pdf" show an error saying 'Invalid PDF' thereby making them inaccessible.
Probably requires a re-upload.

In readme, https://github.com/krishnaik06/The-Grand-Complete-Data-Science-Materials#data-science-trackersheet-for-learning

Tried to open in mobile Pixel 6a, it works
But on desktop, with Windows 10 64 bit , Google Chrome Version 115.0.5790.171 (Official Build) (64-bit) it is not opening any idea what is the issue?

Hi Krish,
I have added Walmart Salesbot and SearchGPT project in ML Project repository and you have merged with your own repo. But it seems it doesn't work. Don't know what happened. If I click on the project it redirect to an error page.
Walmart-SalesBot-and-SearchGPT project

Kindly check at your convenient time and let me know if I have to do anything else from my end.

Thank you Krish for your time and this great initiative.

This is the error ,I see whenever I click on any pdf

I would like to upload data analysis projects to this repository.

Issue Description:

Hello.
I have discovered a performance degradation in the .loc function of pandas version below 2.1 when .loc handling big DataFrame with non-unique indexes. When using pandas more than 4 indexes, .loc drastically increases to X1000 times. And I noticed that some parts of the repository depend on the pandas version below 2.1. For example, ML Projects/NLP_WebAPP_Twitter_Sentiment_Analysis_knowledge_graph/venv/Lib/site-packages/pandas/_version.py depends on pandas 2.0.0, ML Projects/Multi Class News Classification Project/requirements.txt depends on pandas 2.0.3. I found that many files in ML Projects/NLP_WebAPP_Twitter_Sentiment_Analysis_knowledge_graph used the influenced api. There may be more files using the influenced api. I am not sure whether this performance problem in pandas will affect this repository. Here are some discussions on GitHub related to this issue, including #54550 and #54746.

Suggestion

I would recommend considering an upgrade to a different version of pandas >= 2.1 or exploring other solutions to optimize the performance of .loc .
Any other workarounds or solutions would be greatly appreciated.
Thank you!