ai-100 day5 記錄

如何新建一個 dataframe?

新建dataframe 可以幫你：

1. 計算欄位結果
2. 可以新建一個比較少資料的data 的dataframe 來測試

import numpy as np
import pandas as pd

dataframe 建立方法

• read csv

df= pd.read_csv("./xxx.csv")

• read

Cov = pd.read_csv("path/to/file.txt", 
                  sep='\t', 
                  names=["Sequence", "Start", "End", "Coverage"])

• dictionary

df = pd.DataFrame({
    'col1': ['a', 'x'],
    'col2': ['b', 'y'],
    'col3': ['c', 'z']
    })
print(df)
#   col1 col2 col3
# 0    a    b    c
# 1    x    y    z

• array + header

df = pd.DataFrame([
     ['a','b', 'c'],
     ['x','y','z']
     ])
 df.columns = ["col1", "col2", "col3"]
 print(df.head())
#   col1 col2 col3
# 0    a    b    c
# 1    x    y    z

不同型式的data 讀取

python read different type data

建伸閱讀

Pandas Foundations

guipsamora/pandas_exercises