{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import pandas as pd\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# Excel形式のファイルを読み込めます。\n", "dframe = pd.read_excel('Lec_28_test.xlsx', sheetname='Sheet1')" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false, "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | This is a test | \n", "Unnamed: 1 | \n", "Unnamed: 2 | \n", "
---|---|---|---|
0 | \n", "23 | \n", "6678 | \n", "456 | \n", "
1 | \n", "234 | \n", "678 | \n", "456 | \n", "
2 | \n", "234 | \n", "7 | \n", "345 | \n", "
3 | \n", "34 | \n", "56 | \n", "234 | \n", "
4 | \n", "5 | \n", "456 | \n", "4365 | \n", "