【python数据处理】pandas基础操作

基础操作

• 1.创建表

dataframe 类似于csv 与SQL表 

方法1

import codecademylib
import pandas as pd

df1 = pd.DataFrame({
  'Product ID': [1, 2, 3, 4],
  'Product Name': ['t-shirt', 't-shirt', 'skirt', 'skirt'],
  'Color': ['blue', 'green', 'red', 'black']
})

print(df1)

 方法2

import codecademylib
import pandas as pd

df2 = pd.DataFrame([
  [1, 'San Diego', 100],
  [2, 'Los Angeles', 120],
  # Fill in rows 3 and 4
  [3,'San Francisco'	,	90],
  [4	,'Sacramento',	115]
],
  columns=[
    'Store ID','Location','Number of Employees'
  ])

print(df2)

• 2.导入csv文件