Pandas: Sorting DataFrame List

Using the sort function is pretty easy as of 2017 they are deprecating the old sort function and adding in a new way of writing. Error: FutureWarning: sort(columns=…) is deprecated, use sort_values(by=…) Solution: 12>variable_df.sort_values(by=["column_name1", "column_name2"], ascending = [1,0], inplace= True) >print (variable_df) Source: Sort Function: Pandas Ascending: 1 = Ascending & 0 = Descending. It is…

Automated IT – Vision of the Future

Creating an automated system that can resolve IT issues without the need for a person. It can be chat based and instead of opening a ticket and waiting for someone to assist you and 500 other people. We can run a algorithm that reads the request you type in. With that we can narrow the…

Pandas Library: Importing Excel CSV file

Using Python Pandas Library to Import CSV file Import the Pandas Library into your project – here I rename it to “pd” Use Pandas to Read the CSV file Print the top 10 rows including the column headers. 123>import pandas as pd >variablename_df = pd.read_csv("filename.csv") >print(variablename_df.head(10)) Import Pandas: The code above starts out by importing…

Retail’s BIG Show 2017

NRF’s Annual Convention & EXPO earned the nickname “Retail’s BIG Show” years ago and because the name was so appropriate, it stuck. Today, Retail’s BIG Show is NRF’s flagship event held annually in New York City. The three day event offers unparalleled education, collegial networking with 33,000 of your newest friends, and an enormous EXPO…

IBM – Big Data University

Analytics, Big Data, and Data Science Courses While checking one of my Google Alerts I came across an article about IBM’s project to create more data scientist in Nigeria and other countries to help meet the demand for Data Scientist in the future. In the article it expanded on a bootcamp that they would be…

Pip Install Windows 10

Installing pip on Windows 10: * If the regualar pip command is not working: 1. Open your PowerShell or Command Prompt 2. In the command prompt type: py -m pip – This should display a list of pip commands:         When  I tried to use the regular “pip” command I received an…

Daily Habits

Transforming Your Mind For Wealth This morning I listened to a podcast on Youtube with special guest John Kehoe that had a lot of excellent points. The first thought that caught my attention was when he was talking about people having limiting beliefs. Yesterday I was talking to my girlfriend and we had a discussion…

Learn Faster: Train Your Brain

This was a very good video clip put together using the sound clip of Brendon Buchard’s previously recorded message. You can find more details about it in the YouTube description. Secret to Learning The secret to learning is to have a strong enough WHY. Tony Robbins talks about this all the time you can search…

Using Data Analytics: Commercial Insurance Losses

This article was published by Ernie Feirer on RiskandInsurance.com. The article states that for the past decade commercial insurance companies for automobiles (insurance on company owned vehicles) has seen a continuous loss despite raising rates. It has accelerated even more in the past 5 years to a point where insurers are looking for alternative ways…

Installing Python on Windows 10

I found this tutorial to be one of the most complete and easy to follow tutorials when it comes to successfully installing python on your windows 10 pc operating system. He installs both Python 2 and Python 3 so that you can work on any project in both environments. For his IDE he uses atom…