# import pandas library
import pandas as pd
# read the online file by the URL provides above, and assign it to variable “df”
path=”https://……”
df = pd.read_csv(path,header=None)
print(“Done”)
# show the first 5 rows using dataframe.head() method
df.head(5)
# create headers list
headers = [“name”, “price”, “make”]
#show the list
headers
df.columns = headers
#show top 10 rows
df.head(10)
df.dropna(subset=[“price”], axis=0)
df.columns
| Data Formate |
Read |
Save |
| csv |
pd.read_csv() |
df.to_csv() |
| json |
pd.read_json() |
df.to_json() |
| excel |
pd.read_excel() |
df.to_excel() |
| hdf |
pd.read_hdf() |
df.to_hdf() |
| sql |
pd.read_sql() |
df.to_sql() |
| … |
… |
… |
dataframe.dtypes
# check the data type of data frame “df” by .dtypes
df.dtypes
df.describe()
# describe all the columns in “df”
df.describe(include = “all”) From: http://sitestree.com/?p=12204
Categories:Python, Python, Introduction to Python
Tags:
Post Data:2018-04-25 15:12:47
Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada
