{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Here are some examples on how to use PANDAS library\n",
"- https://pandas.pydata.org\n",
"- https://pandas.pydata.org/pandas-docs/stable/getting_started/10min.html"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Dataframe concatenation and Iterative creation of a dataframe"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [],
"source": [
"df1=pd.DataFrame({'a':[5,5,5,5],'b':[4,4,4,4]},index=[1,2,3,4])\n",
"df2=pd.DataFrame({'a':[6,6,6,6],'b':[3,3,3,3]},index=[1,2,3,4])"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" a | \n",
" b | \n",
"
\n",
" \n",
" \n",
" \n",
" 1 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 2 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 3 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 4 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" a b\n",
"1 5 4\n",
"2 5 4\n",
"3 5 4\n",
"4 5 4"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df1"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" a | \n",
" b | \n",
"
\n",
" \n",
" \n",
" \n",
" 1 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 2 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 3 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 4 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 1 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
" 2 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
" 3 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
" 4 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" a b\n",
"1 5 4\n",
"2 5 4\n",
"3 5 4\n",
"4 5 4\n",
"1 6 3\n",
"2 6 3\n",
"3 6 3\n",
"4 6 3"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.concat([df1,df2])"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" a | \n",
" b | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 1 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 2 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 3 | \n",
" 5 | \n",
" 4 | \n",
"
\n",
" \n",
" 4 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
" 5 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
" 6 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
" 7 | \n",
" 6 | \n",
" 3 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" a b\n",
"0 5 4\n",
"1 5 4\n",
"2 5 4\n",
"3 5 4\n",
"4 6 3\n",
"5 6 3\n",
"6 6 3\n",
"7 6 3"
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.concat([df1,df2],ignore_index=True)"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [],
"source": [
"a=[1,2,3,4,5,6,7,8]\n",
"b=[5,6,4,3,2,4,5,2]"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" a | \n",
" b | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 1 | \n",
" 5 | \n",
"
\n",
" \n",
" 1 | \n",
" 2 | \n",
" 6 | \n",
"
\n",
" \n",
" 2 | \n",
" 3 | \n",
" 4 | \n",
"
\n",
" \n",
" 3 | \n",
" 4 | \n",
" 3 | \n",
"
\n",
" \n",
" 4 | \n",
" 5 | \n",
" 2 | \n",
"
\n",
" \n",
" 5 | \n",
" 6 | \n",
" 4 | \n",
"
\n",
" \n",
" 6 | \n",
" 7 | \n",
" 5 | \n",
"
\n",
" \n",
" 7 | \n",
" 8 | \n",
" 2 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" a b\n",
"0 1 5\n",
"1 2 6\n",
"2 3 4\n",
"3 4 3\n",
"4 5 2\n",
"5 6 4\n",
"6 7 5\n",
"7 8 2"
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sumdf=pd.DataFrame()\n",
"for x,y in zip(a,b):\n",
" df=pd.DataFrame({'a':[x],'b':[y]})\n",
" sumdf=pd.concat([sumdf,df],ignore_index=True)\n",
"sumdf"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python [conda env:moldyn]",
"language": "python",
"name": "conda-env-moldyn-py"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}