Kashif Naz @CodewithNaz

Experienced Finance Professional | Data Analyst | Automation Expert | Technical Blogger | Web Scraper Talks about #python, #sql, #automation, #datascience linkedin.com/in/kashifnaz Karachi, Pakistan Joined September 2019

Tweets

33
Followers

8
Following

336
Likes

9

Kashif Naz @CodewithNaz

3 years ago

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

0 0 0 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 1 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 0 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 0 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 1 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 1 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 0 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 0 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 0 0 0

Kashif Naz @CodewithNaz

3 years ago

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

0 0 1 0 0

Download Image

Raymond Hettinger @raymondh

3 years ago

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/

7 4 54 0 7

Kashif Naz @CodewithNaz

3 years ago

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…

0 0 0 0 0

Kashif Naz @CodewithNaz

3 years ago

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…

0 0 0 0 0

Kashif Naz @CodewithNaz

4 years ago

Python - An Introduction { by @CodewithNaz } from @hashnode #python #python3 #pythonprojects #pythonbeginner #programmingblogs codewithnaz.hashnode.dev/python-an-intr…

0 0 0 0 0

Will Kurt @willkurt

4 years ago

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!