{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true, "deletable": true, "editable": true }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false, "deletable": true, "editable": true }, "outputs": [], "source": [ "s = pd.DataFrame(-1, index=range(2), columns=range(1000))" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "\n", "0 int64\n", "1 int64\n", "2 int64\n", "3 int64\n", "4 int64\n", "5 int64\n", "6 int64\n", "7 int64\n", "8 int64\n", "9 int64\n", "10 int64\n", "11 int64\n", "12 int64\n", "13 int64\n", "14 int64\n", "15 int64\n", "16 int64\n", "17 int64\n", "18 int64\n", "19 int64\n", "20 int64\n", "21 int64\n", "22 int64\n", "23 int64\n", "24 int64\n", "25 int64\n", "26 int64\n", "27 int64\n", "28 int64\n", "29 int64\n", " ... \n", "970 int64\n", "971 int64\n", "972 int64\n", "973 int64\n", "974 int64\n", "975 int64\n", "976 int64\n", "977 int64\n", "978 int64\n", "979 int64\n", "980 int64\n", "981 int64\n", "982 int64\n", "983 int64\n", "984 int64\n", "985 int64\n", "986 int64\n", "987 int64\n", "988 int64\n", "989 int64\n", "990 int64\n", "991 int64\n", "992 int64\n", "993 int64\n", "994 int64\n", "995 int64\n", "996 int64\n", "997 int64\n", "998 int64\n", "999 int64\n", "dtype: object" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "s.dtypes" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": true, "deletable": true, "editable": true }, "outputs": [], "source": [ "def is_even(i):\n", " return i % 2 == 0" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true, "deletable": true, "editable": true }, "outputs": [], "source": [ "def fill_series1(s):\n", " mys = s.copy()\n", " for i in s.columns:\n", " mys.loc[0, i] = mys.loc[0, i] + is_even(i)\n", " return mys" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": true, "deletable": true, "editable": true }, "outputs": [], "source": [ "def fill_series2(s):\n", " mys = s.copy()\n", " for i in s.columns:\n", " mys.loc[0, i] = is_even(i)\n", " return mys" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false, "deletable": true, "editable": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "1 loop, best of 3: 231 ms per loop\n" ] } ], "source": [ "%timeit fill_series1(s)" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false, "deletable": true, "editable": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "1 loop, best of 3: 750 ms per loop\n" ] } ], "source": [ "%timeit fill_series2(s)" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false, "deletable": true, "editable": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "990 | \n", "991 | \n", "992 | \n", "993 | \n", "994 | \n", "995 | \n", "996 | \n", "997 | \n", "998 | \n", "999 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "True | \n", "False | \n", "True | \n", "False | \n", "True | \n", "False | \n", "True | \n", "False | \n", "True | \n", "False | \n", "... | \n", "True | \n", "False | \n", "True | \n", "False | \n", "True | \n", "False | \n", "True | \n", "False | \n", "True | \n", "False | \n", "
1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "... | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "-1 | \n", "
2 rows × 1000 columns
\n", "