import pandas as pd
import pprint
import json
pd.__version__
'1.3.2'
names = ['john','mary','peter','gary','anne']
ages = [33,22,45,23,12]
df = pd.DataFrame({
'names':names,
'ages':ages
})
df
names | ages | |
---|---|---|
0 | john | 33 |
1 | mary | 22 |
2 | peter | 45 |
3 | gary | 23 |
4 | anne | 12 |
data_dicts = [
{'name':"john","gender":'male','age':45},
{'name':"mary", 'gender':"female",'age':19},
{'name':"peter",'gender':'male', 'age':34}
]
# must reassign since the append method does not work in place
df = pd.DataFrame.from_records(data_dicts)
df
name | gender | age | |
---|---|---|---|
0 | john | male | 45 |
1 | mary | female | 19 |
2 | peter | male | 34 |
d = {"alice": 12, "bob": 20, "charlie": 33}
print(json.dumps(d, indent=2))
pd.DataFrame.from_dict(d, orient='index', columns=['age'])
{ "alice": 12, "bob": 20, "charlie": 33 }
age | |
---|---|
alice | 12 |
bob | 20 |
charlie | 33 |
df = pd.DataFrame()
# must reassign since the append method does not work in place
df = df.append({'col_a':5,'col_b':10}, ignore_index=True)
df = df.append({'col_a':1,'col_b':100}, ignore_index=True)
df = df.append({'col_a':32,'col_b':999}, ignore_index=True)
df
col_a | col_b | |
---|---|---|
0 | 5.0 | 10.0 |
1 | 1.0 | 100.0 |
2 | 32.0 | 999.0 |
data_dicts = [
{'name':"john","gender":'male','age':45},
{'name':"mary", 'gender':"female",'age':19},
{'name':"peter",'gender':'male', 'age':34}
]
# must reassign since the append method does not work in place
df = pd.DataFrame.from_records(data_dicts,)
df
name | gender | age | |
---|---|---|---|
0 | john | male | 45 |
1 | mary | female | 19 |
2 | peter | male | 34 |