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 … Read more

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 … Read more

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 … Read more

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”] … Read more

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 … Read more