Bir DataFrame Oluşturma

Finans için Orta Düzey Python

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

	Sütun 1	Sütun 2	Sütun 3
0	v1	a	00
1	v2	b	01
2	v3	c	13.02

Sözlükten

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

df = pd.DataFrame(data=data)

Sözlükten

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

Sözlük listesinden

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)

Sözlük listesinden

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

Liste listesinden

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

Liste listesinden

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

Sütun adlarıyla liste listesinden

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

Sütun adlarıyla liste listesinden

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

Veri okuma

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

Virgülle ayrılmış değerler

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

CSV dosyası okuma

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

CSV dosyası okuma

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

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

Virgülsüz csv

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

Virgülsüz csv

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

Virgülsüz csv

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

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

Hadi pratik yapalım!

Finans için Orta Düzey Python