Category: Python

How to open a text file from my desktop using python Windows Bash Terminal In this  Blog i will step through , how to open text file located in Desktop using Python  through Windows Bash Terminal Things you need before getting  Start A text file save at your Desktop Python Library installed Window Bash Terminal…

Connect MySQL using Python Connect MySQL using Python, In this Blog post i will  show how to connect a MySQL Database using Python Script. Prior Diving into how to connect MySQL using Python  , Make sure the below Software / Configuration are being installed & Setup into your workstation Python  Shell or you can use…

Manipulating Data Frames in Python   Manipulating Data Frames in Python, in this article i will show you how to manipulate imported data frames into python Deleting Column Deleting bunch of Column Deleting Row Deleting bunch of Row Adding Column Tran-pose Data Frame Adding a new Row Deleting Column df1.drop(“City”,1)   Deleting Bunch of Column…

Slicing and Indexing Dataframes   Slicing and Indexing Dataframes, in this article i will show you how to slice and index file using Python. Indexing df1.set_index(“Address”)   Creating a List for a Single Column list(df1.loc[:”Country”]) Display value in Cell ( row vs column) df1.loc[45845854,”Country”] Display value  in  column(city to country)  which located at row”765758″ df1.loc[765758,”City”:”Country”]…

Loading Data From csv json Excel Text Using Python   Loading Data From csv json Excel Text Using Python . In this Article i will show you how to load CSV Excel Json Text Using Python In order to do that i will use the Tool below to load the files listed above Jupyter  click…