Converting Data file to CSV file and read through Jupyter notebook

Data File to CSV file

1.Datasets Extraction

  1. Kaggle:https://www.kaggle.com/tags/web-sites
  2. UCI Machine Learning: Repository :https://archive.ics.uci.edu/ml/index.php
  3. Data World:https://data.world/datasets/website
  4. Government data:https://data.gov.in/

2 .Data file to CSV file through excel

Data file
Conversion to notepad
Paste the content of notepad to Excel.
Click on data in menu bar and click text to columns.
Use the delimiter option and change in to relevant columns and rows click next.
Changed to relevant rows and columns.

Read through Jupyter Notebook without changing anything in excel using python code.

Import csv file to Jupyter

import numpy as np

import pandas as pd

df=pd.read_csv(“car.csv”)

Reading the DATA file through Python code is as simple .

--

--

--

Data scientist Aspirant passionate in learning new technologies and sharing my thoughts to others .

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Ames Housing Price Prediction — Complete ML Project with Python

Opening sentences of research papers:

Network Intrusion Detection System Using Machine Learning

Celebrating Open Data Day 2021

Top 10 Sessions to Watch from the HLPF on Sustainable Development

How to calculate polyarea in metres using latitude and longitude coordinates

D4S Sunday Briefing #75

Rowing Splits vs. Workout Duration

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vignesh S

Vignesh S

Data scientist Aspirant passionate in learning new technologies and sharing my thoughts to others .

More from Medium

2022 Python Data Analysis & Visualization Masterclass

2022 Python Data Analysis & Visualization Masterclass

8 years of running in one chart

Exploratory Data Analysis of Bike Share riding based on plotly express

Exploratory Data Analysis.