Skip to main content

How to load a dataset in Python?

This is the first step for Data scientist work. Data is very important in this field without data there is nothing to do here. I mean data is everything, not only number it consists of image, audio,  video or anything.

In this post, I will tell the process to load simple dataset in CSV format. I recommend installing jupyter or spyder from Anaconda website.

Packages you want to install in cmd or terminal 

pip install pandas
pip install numpy
pip install matplotlib

Mostly these packages will be installed default. Just for a verification check whether  it is installed.

Numpy
            It is a mathematical tool used to do some complex calculation.

Pandas
             Without pandas, we can import the data. It is manually used to form a data frame and other allocation processes.

Matplotlib
                It is one of the visualization packages in python. It is used to visualize data.  

I write the standard code below to import CSV file


import pandas as pd
import numpy as np

data =pd.read_csv("path to the file")
data.head()

There are a lot of commands like read_csv,read_html, read_json etc.

Head() is to describe top 5 rows in the table.

I feel this is the first step to the data science

Happy Learning!!!







Comments

Post a Comment

Popular posts from this blog

Welcome

Hi everyone, This is Karthick Aravindan, I am a  Machine Learning Engineer working in Optisol Business Solution. I just want to share my experience in this field. This blog is completely dedicated to machine learning stuff. As into to blog, I am sharing my daily tools what I am using for my work. 1) Python 3.+ version:  https://www.python.org/ 2) Anaconda or miniconda both are best install anyone:  https://www.anaconda.com/download/ 3) Jupyter notebook 4) Colabs form google, I will write a sperate post for this: https://colab.research.google.com 5) Pycharm awesome IDE for python:  https://www.jetbrains.com/pycharm/download/ 6) AWS account to train module or use colab to train quickly. 7) Any text editor like sublime, atom, vscode. I recommend vscode it is really cool stuff to have on         your desk:  https://code.visualstudio.com/ I feel these are the basic things we need to...
Post a Comment
Read more

Top 10 basic command you should try in your data analysis / Machine learning

Hi all, When you get the data in CSV format or any other format then you should try this 10 basic command to understand more the data. How much you understand the dataset will help you to make better model for it. Before jumping into the code I want to mention some basic packages/software you want to have: Python  Jupyter Notebook (Highly recommend this one) or Spyder pandas (default it will be installed in python) That's it. These are the basic things you should need to start. First get some the data from kaggle or anywhere.Let the data format will be CSV format for better understanding. Import the necessary packages and data like this import pandas as pd df= pd.read_csv("path to csv file) Now Lets the establish top common commands: 1. df.head(): This command will show top rows in the dataset 2. df.info(): This command will tell the type of each column such as float, int, object type. 3. df. describe(): This will describe ...
Post a Comment
Read more