{ "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ab
154
254
354
454
\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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ab
154
254
354
454
163
263
363
463
\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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ab
054
154
254
354
463
563
663
763
\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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ab
015
126
234
343
452
564
675
782
\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 }