Tạo DataFrame

Python Trung cấp cho Tài chính

Kennedy Behrman

Data Engineer, Author, Founder

Pandas

import pandas as pd

print(pd)

<module 'pandas' from '.../pandas/__init__.py'>

Pandas DataFrame

pd.DataFrame()

Pandas DataFrame

	Cột 1	Cột 2	Cột 3
0	v1	a	00
1	v2	b	01
2	v3	c	13.02

Từ dict

data = {'Bank Code': ['BA', 'AAD', 'BA'],
        'Account#': ['ajfdk2', '1234nmk', 'mm3d90'],
        'Balance':[1222.00, 390789.11, 13.02]}

df = pd.DataFrame(data=data)

Từ dict

data = {'Bank Code': ['BA', 'AAD', 'BA'],
        'Account#': ['ajfdk2', '1234nmk', 'mm3d90'],
        'Balance':[1222.00, 390789.11, 13.02]}

df = pd.DataFrame(data=data)

	Bank Code	Account#	Balance
0	BA	ajfdk2	1222.00
1	AAD	1234nmk	390789.11
1	BA	mm3d90	13.02

Từ list dict

data = [{'Bank Code': 'BA', 'Account#': 'ajfdk2',  'Balance': 1222.00},
        {'Bank Code': 'AAD', 'Account#': '1234nmk', 'Balance': 390789.11},
        {'Bank Code': 'BA', 'Account#': 'mm3d90', 'Balance': 13.02}]
df = pd.DataFrame(data=data)

Từ list dict

data = [{'Bank Code': 'BA', 'Account#': 'ajfdk2',  'Balance': 1222.00},
        {'Bank Code': 'AAD', 'Account#': '1234nmk', 'Balance': 390789.11},
        {'Bank Code': 'BA', 'Account#': 'mm3d90', 'Balance': 13.02}]
df = pd.DataFrame(data=data)

	Bank Code	Account#	Balance
0	BA	ajfdk2	1222.00
1	AAD	1234nmk	390789.11
1	BA	mm3d90	13.02

Từ list lồng nhau

data = [['BA',  'ajfdk2',  1222.00],
        ['AAD', '1234nmk', 390789.11],
        ['BA',  'mm3d90',  13.02]]      
df = pd.DataFrame(data=data)

Từ list lồng nhau

data = [['BA',  'ajfdk2',  1222.00],
        ['AAD', '1234nmk', 390789.11],
        ['BA',  'mm3d90',  13.02]]      
df = pd.DataFrame(data=data)

	0	1	2
0	BA	ajfdk2	1222.00
1	AAD	1234nmk	390789.11
1	BA	mm3d90	13.02

Từ list lồng nhau kèm tên cột

data = [['BA',  'ajfdk2',  1222.00],
        ['AAD', '1234nmk', 390789.11],
        ['BA',  'mm3d90',  13.02]]      
columns = ['Bank Code', 'Account#', 'Balance']
df = pd.DataFrame(data=data, columns=columns)

	Bank Code	Account#	Balance
0	BA	ajfdk2	1222.00
1	AAD	1234nmk	390789.11
1	BA	mm3d90	13.02

Từ list lồng nhau kèm tên cột

data = [['BA',  'ajfdk2',  1222.00],
        ['AAD', '1234nmk', 390789.11],
        ['BA',  'mm3d90',  13.02]]      
columns = ['Bank Code', 'Account#', 'Balance']
df = pd.DataFrame(data=data, columns=columns)

	Bank Code	Account#	Balance
0	BA	ajfdk2	1222.00
1	AAD	1234nmk	390789.11
2	BA	mm3d90	13.02

Đọc dữ liệu

Excel pd.read_excel
JSON pd.read_json
HTML pd.read_html
Pickle pd.read_pickle
SQL pd.read_sql
CSV pd.read_csv

CSV

Giá trị phân tách bằng dấu phẩy

client id,trans type, amount
14343,buy,23.0
0574,sell,2000
7093,dividend,2234

Đọc tệp CSV

df = pd.read_csv('/data/daily/transactions.csv')

Đọc tệp CSV

df = pd.read_csv('/data/daily/transactions.csv')

client id	trans type	amount
14343	buy	23.0
0574	sell	2000
7093	dividend	2234

CSV không dùng dấu phẩy

client id|trans type| amount
14343|buy|23.0
0574|sell|2000
7093|dividend|2234

CSV không dùng dấu phẩy

df = pd.read_csv('/data/daily/transactions.csv', sep='|')

CSV không dùng dấu phẩy

df = pd.read_csv('/data/daily/transactions.csv', sep='|')

client id	trans type	amount
14343	buy	23.0
0574	sell	2000
7093	dividend	2234

Ayo berlatih!

Python Trung cấp cho Tài chính