Kashif Naz
@CodewithNaz
Experienced Finance Professional | Data Analyst | Automation Expert | Technical Blogger | Web Scraper Talks about #python, #sql, #automation, #datascience
You might like
I'm speaking at Free Webinar - Power Excel for Finance Professionals. Would you like to attend? #Excel #powerquery #PowerPivot #dax #daxfunctions #finance #webinar lnkd.in/d7FSQJhR
The 𝒓𝒆𝒂𝒅_𝒄𝒔𝒗() reads a comma-seperated (csv) and text(txt) file into a DataFrame. This function accepts more than 50 arguments. One of these is the 𝐞𝐧𝐠𝐢𝐧𝐞 parameter. Pandas currently supports three engines, the 𝐂 engine, the 𝐩𝐲𝐭𝐡𝐨𝐧 en…lnkd.in/dmbJqfFg
Consider the following scenario: You wish to convert long data to wide data in Pandas. The first approach is to utilize the pivot() method. Let's consider an example below. When the pivot() function is used, it will raise a "ValueError: Index contains…lnkd.in/dEEFQeyh
Did you know that you can generate monthly and annual calendars using Python's "calendar" standard library? TextCalendar() takes the parameter "firstweekday" from 0 (Monday) to 6 (Sunday) or calendar.MONDAY to calendar.SUNDAY. pryear() method will gener…lnkd.in/d9P_Uer8
When it comes to managing tabular data, Pandas in a Python Eco-system is an excellent package. Consider the case of a 1-million-row Excel file that you want to split into multiple Excel files, each with 200_000 rows. It is possible to accomplish this usi…lnkd.in/dp3ZjfqW
Yesterday, I shared an Excel Power Query tip as how you can remove null columns from your data. Today, I am sharing how you can perform that operation in Python with the help of Pandas's dropna() function. dropna() accepts a parameter "how". If you defi…lnkd.in/dmS3HWNJ
Just sharing a quick Excel Power Query tip: If you want to remove null or empty column in Excel, you can use Power Query for that. Step by Step Guide: 1) Data > Get Data > From Table, select the range of the data, the data will then be open with Power…lnkd.in/dFxs-i8H
Oracle Database can be connected with Python through two libraries naming Sqlalchemy and cx_Oracle with setting defined in TNSNAMES.ORA file. Below is the Python code for connecting to Oracle Database and querying with Pandas with aforementioned librarie…lnkd.in/dvCAXZqM
Has it ever occurred to you, how a simple Python script can rename the Windows sub-directories. We will be using Walk() function from the Python's Standard Library os. Walk() takes a Boolean value for the parameter topdown. If you want to ensure that yo…lnkd.in/dZ8x4zSq
Oracle Database can be connected with Python through Sqlalchemy and cx_Oracle with setting defined in TNSNAMES.ORA file. Below is the Python code for connecting to Oracle Database and querying with Pandas with aforementioned libraries #Oracle #pythonprogramming
Interestingly, it wouldn't be hard to add that capability to dataclasses: age: int = field(assert_isinstance=int) or age: int = field(type_converter=int) 3/
I just earned SQL (Intermediate) skill certificate via @HackerRank. Get your skills certified and show the world what you can do! #skilloverpedigree hackerrank.com/certificates/8…
I just earned SQL (Basic) skill certificate via @HackerRank. Get your skills certified and show the world what you can do! #skilloverpedigree hackerrank.com/certificates/0…
Python - An Introduction { by @CodewithNaz } from @hashnode #python #python3 #pythonprojects #pythonbeginner #programmingblogs codewithnaz.hashnode.dev/python-an-intr…
Got my copy! Fantastic work @aloctavodia @junpenglao @canyon289 This book is a really excellent resource for anyone looking to do practical Bayesian modelling. A great blend of theory with a ton of practical tips on writing code and building models!
United States Trends
- 1. Raindotgg 1,665 posts
- 2. #TalusLabs N/A
- 3. Sam Houston 1,418 posts
- 4. Oregon State 4,792 posts
- 5. Boots 28.9K posts
- 6. Boots 28.9K posts
- 7. #T1WIN 23.1K posts
- 8. Louisville 14.3K posts
- 9. #GoAvsGo 1,524 posts
- 10. Batum N/A
- 11. UCLA 7,788 posts
- 12. Nuss 5,800 posts
- 13. Emmett Johnson 2,437 posts
- 14. #Huskers 1,088 posts
- 15. Oilers 4,959 posts
- 16. #FlyTogether 1,991 posts
- 17. Miller Moss 1,219 posts
- 18. T1 FIGHTING 3,243 posts
- 19. Bama 13.8K posts
- 20. Brohm 1,156 posts
Something went wrong.
Something went wrong.