数据加载，存储和文件格式_json 数据存文件格式-CSDN博客

本文链接：https://blog.csdn.net/DMU_lzq1996/article/details/83443460

在这里插入图片描述

import pandas as pd
df = pd.read_csv('examples/ex1.csv')
df

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

pd.read_table('examples/ex1.csv',sep=",")

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

pd.read_csv('examples/ex2.csv',header=None)

	0	1	2	3	4
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

pd.read_csv('examples/ex2.csv',names=['a', 'b', 'c', 'd', 'message'])

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

names = ['a', 'b', 'c', 'd', 'message']
pd.read_csv('examples/ex2.csv',names=names,index_col='message')

	a	b	c	d
message
hello	1	2	3	4
world	5	6	7	8
foo	9	10	11	12

parsed = pd.read_csv('examples/csv_mindex.csv',index_col=['key1','key2'])
parsed

		value1	value2
key1	key2
one	a	1	2
	b	3	4
	c	5	6
	d	7	8
two	a	9	10
	b	11	12
	c	13	14
	d	15	16

list(open('examples/ex3.txt'))

['            A         B         C\n',
 'aaa -0.264438 -1.026059 -0.619500\n',
 'bbb  0.927272  0.302904 -0.032399\n',
 'ccc -0.264273 -0.386314 -0.217601\n',
 'ddd -0.871858 -0.348382  1.100491\n']

result = pd.read_table('examples/ex3.txt',sep='\s+') #数据规整
result

	A	B	C
aaa	-0.264438	-1.026059	-0.619500
bbb	0.927272	0.302904	-0.032399
ccc	-0.264273	-0.386314	-0.217601
ddd	-0.871858	-0.348382	1.100491

#用skiprows跳过文件的第一行、第三行和第四行
pd.read_csv('examples/ex4.csv',skiprows=[0,2,3])

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

#缺失值处理
result = pd.read_csv('examples/ex5.csv')
result

	something	a	b	c	d	message
0	one	1	2	3.0	4	NaN
1	two	5	6	NaN	8	world
2	three	9	10	11.0	12	foo

pd.isnull(result)

	something	a	b	c	d	message
0	False	False	False	False	False	True
1	False	False	False	True	False	False
2	False	False	False	False	False	False

result = pd.read_csv('examples/ex5.csv',na_values=[12])#设为缺失值
result

	something	a	b	c	d	message
0	one	1	2	3.0	4.0	NaN
1	two	5	6	NaN	8.0	world
2	three	9	10	11.0	NaN	foo

sentinels = {'message': ['foo', 'NA'], 'something': ['two']}
pd.read_csv('examples/ex5.csv',na_values=sentinels)

	something	a	b	c	d	message
0	one	1	2	3.0	4	NaN
1	NaN	5	6	NaN	8	world
2	three	9	10	11.0	12	NaN

在这里插入图片描述

#逐块读取文本文件
pd.options.display.max_rows = 10
result = pd.read_csv('examples/ex6.csv')
result

	one	two	three	four	key
0	0.467976	-0.038649	-0.295344	-1.824726	L
1	-0.358893	1.404453	0.704965	-0.200638	B
2	-0.501840	0.659254	-0.421691	-0.057688	G
3	0.204886	1.074134	1.388361	-0.982404	R
4	0.354628	-0.133116	0.283763	-0.837063	Q
...	...	...	...	...	...
9995	2.311896	-0.417070	-1.409599	-0.515821	L
9996	-0.479893	-0.650419	0.745152	-0.646038	E
9997	0.523331	0.787112	0.486066	1.093156	K
9998	-0.362559	0.598894	-1.843201	0.887292	G
9999	-0.096376	-1.012999	-0.657431	-0.573315	0

10000 rows × 5 columns

pd.read_csv('examples/ex6.csv',nrows=5)  #指定读取

	one	two	three	four	key
0	0.467976	-0.038649	-0.295344	-1.824726	L
1	-0.358893	1.404453	0.704965	-0.200638	B
2	-0.501840	0.659254	-0.421691	-0.057688	G
3	0.204886	1.074134	1.388361	-0.982404	R
4	0.354628	-0.133116	0.283763	-0.837063	Q

chunker = pd.read_csv('examples/ex6.csv',chunksize=1000)
chunker     #迭代器

<pandas.io.parsers.TextFileReader at 0x291a59a7a90>

tot = pd.Series([])
for piece in chunker:
    tot = tot.add(piece['key'].value_counts(),fill_value=0)
tot = tot.sort_values(ascending=False)
tot[:10]

E    368.0
X    364.0
L    346.0
O    343.0
Q    340.0
M    338.0
J    337.0
F    335.0
K    334.0
H    330.0
dtype: float64

#将数据写到文本格式
data = pd.read_csv('examples/ex5.csv')
data

	something	a	b	c	d	message
0	one	1	2	3.0	4	NaN
1	two	5	6	NaN	8	world
2	three	9	10	11.0	12	foo

data.to_csv('examples/out.csv')   #DataFrame方法

import sys
data.to_csv(sys.stdout,sep='|') #这里直接写出到sys.stdout，所以仅仅是打印出文本结果而已

|something|a|b|c|d|message
0|one|1|2|3.0|4|
1|two|5|6||8|world
2|three|9|10|11.0|12|foo

data.to_csv(sys.stdout,na_rep="NULL")

,something,a,b,c,d,message
0,one,1,2,3.0,4,NULL
1,two,5,6,NULL,8,world
2,three,9,10,11.0,12,foo

data.to_csv(sys.stdout,index=False,header=False)

one,1,2,3.0,4,
two,5,6,,8,world
three,9,10,11.0,12,foo

data.to_csv(sys.stdout,index=False,columns=['a','b','c'])

a,b,c
1,2,3.0
5,6,
9,10,11.0

import numpy as np
dates = pd.date_range('1/1/2000',periods=7)
ts = pd.Series(np.arange(7),index =dates)
ts.to_csv('examples/tseries.csv')  #Series的to_csv方法

#处理分隔符格式,为了使数据格式合乎要求
import csv
f = open('examples/ex7.csv')
reader = csv.reader(f)

for line in reader:
    print(line)

['a', 'b', 'c']
['1', '2', '3']
['1', '2', '3']

with open('examples/ex7.csv')as f:
    lines = list(csv.reader(f))
header,values = lines[0],lines[1:]    #读取到列表
data_dict = {h:v for h,v in zip(header,zip(*values))}
data_dict#用字典构造式和zip(*values)，后者将行转置为列，创建数据列的字典

{'a': ('1', '1'), 'b': ('2', '2'), 'c': ('3', '3')}

class my_dialect(csv.Dialect):          #自定义读取格式
    lineterminator = '\n'
    delimiter = ';'
    quotechar = '"'
    quoting = csv.QUOTE_MINIMAL
reader = csv.reader(f,dialect=my_dialect)

在这里插入图片描述

#JSON数据,JSON（JavaScript Object Notation的简称）已经成为通过HTTP请求在Web浏览器和其他应用程序之间发送数据的标准格式之一
obj = """
{"name": "Wes",
 "places_lived": ["United States", "Spain", "Germany"],
 "pet": null,
 "siblings": [{"name": "Scott", "age": 30, "pets": ["Zeus", "Zuko"]},
              {"name": "Katie", "age": 38,
               "pets": ["Sixes", "Stache", "Cisco"]}]
}
"""
import json
result = json.loads(obj)   #将JSON字符串转换成Python形式
result

{'name': 'Wes',
 'places_lived': ['United States', 'Spain', 'Germany'],
 'pet': None,
 'siblings': [{'name': 'Scott', 'age': 30, 'pets': ['Zeus', 'Zuko']},
  {'name': 'Katie', 'age': 38, 'pets': ['Sixes', 'Stache', 'Cisco']}]}

#json.dumps则将Python对象转换成JSON格式：
#asjson = json.dumps(result)

siblings = pd.DataFrame(result['siblings'],columns=['name','age'])
siblings

	name	age
0	Scott	30
1	Katie	38

data = pd.read_json('examples/example.json')
data #pandas.read_json的默认选项假设JSON数组中的每个对象是表格中的一行

	a	b	c
0	1	2	3
1	4	5	6
2	7	8	9

#XML和HTML:Web信息采集
tables = pd.read_html('examples/fdic_failed_bank_list.html')
len(tables)

failures = tables[0]
failures.head()

	Bank Name	City	ST	CERT	Acquiring Institution	Closing Date	Updated Date
0	Allied Bank	Mulberry	AR	91	Today's Bank	September 23, 2016	November 17, 2016
1	The Woodbury Banking Company	Woodbury	GA	11297	United Bank	August 19, 2016	November 17, 2016
2	First CornerStone Bank	King of Prussia	PA	35312	First-Citizens Bank & Trust Company	May 6, 2016	September 6, 2016
3	Trust Company Bank	Memphis	TN	9956	The Bank of Fayette County	April 29, 2016	September 6, 2016
4	North Milwaukee State Bank	Milwaukee	WI	20364	First-Citizens Bank & Trust Company	March 11, 2016	June 16, 2016

#利用lxml.objecttify解析XML
from lxml import objectify
path = 'datasets/mta_perf/Performance_MNR.xml'
parsed = objectify.parse(open(path)) #利用lxml.objectify解析该文件
root = parsed.getroot()
data=[]
skip_fields = ['PARENT_SEQ', 'INDICATOR_SEQ',
               'DESIRED_CHANGE', 'DECIMAL_PLACES']
for elt in root.INDICATOR:
    el_data = {}
    for child in elt.getchildren():
        if child.tag in skip_fields:
            continue
        el_data[child.tag] = child.pyval
    data.append(el_data)
perf = pd.DataFrame(data)
perf.head()

	AGENCY_NAME	CATEGORY	DESCRIPTION	FREQUENCY	INDICATOR_NAME	INDICATOR_UNIT	MONTHLY_ACTUAL	MONTHLY_TARGET	PERIOD_MONTH	PERIOD_YEAR	YTD_ACTUAL	YTD_TARGET
0	Metro-North Railroad	Service Indicators	Percent of commuter trains that arrive at thei...	M	On-Time Performance (West of Hudson)	%	96.9	95	1	2008	96.9	95
1	Metro-North Railroad	Service Indicators	Percent of commuter trains that arrive at thei...	M	On-Time Performance (West of Hudson)	%	95	95	2	2008	96	95
2	Metro-North Railroad	Service Indicators	Percent of commuter trains that arrive at thei...	M	On-Time Performance (West of Hudson)	%	96.9	95	3	2008	96.3	95
3	Metro-North Railroad	Service Indicators	Percent of commuter trains that arrive at thei...	M	On-Time Performance (West of Hudson)	%	98.3	95	4	2008	96.8	95
4	Metro-North Railroad	Service Indicators	Percent of commuter trains that arrive at thei...	M	On-Time Performance (West of Hudson)	%	95.8	95	5	2008	96.6	95

from io import StringIO
tag = '<a href="http://www.google.com">Google</a>'
root = objectify.parse(StringIO(tag)).getroot()
root

<Element a at 0x239d5aa8688>

root.get('href')

'http://www.google.com'

root.text

'Google'

#二进制数据格式,使用Python内置的pickle序列化
frame = pd.read_csv('examples/ex1.csv')
frame

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

frame.to_pickle('examples/frame_pickle')#将数据以pickle格式保存到磁盘

pd.read_pickle('examples/frame_pickle')#直接读取被pickle化的数据

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

#HDF5格式
#HDF5是一种存储大规模科学数组数据的非常好的文件格式

#读取Micosoft Excel文件
#ExcelFile类或pandas.read_excel函数
xlsx = pd.ExcelFile('examples/ex1.xlsx')
xlsx

<pandas.io.excel.ExcelFile at 0x239d92f9c18>

pd.read_excel(xlsx,'Sheet1')

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

#直接传递文件名
frame = pd.read_excel('examples/ex1.xlsx','Sheet1')
frame

	a	b	c	d	message
0	1	2	3	4	hello
1	5	6	7	8	world
2	9	10	11	12	foo

#pandas数据写入为Excel格式
writer = pd.ExcelWriter('examples/ex2.xlsx')
frame.to_excel(writer,'Sheet1')
writer.save()

#传递文件的路径到to_excel
frame.to_excel('examples/ex2.xlsx')

#Web APls交互
#通过python访问API的方法：request包
import requests
url = 'https://api.github.com/repos/pandas-dev/pandas/issues'
resp = requests.get(url)
resp

<Response [200]>

data = resp.json()

data #data中的每个元素都是一个包含所有GitHub主题页数据（不包含评论）的字典

[{'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23369',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23369/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23369/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23369/events',
  'html_url': 'https://github.com/pandas-dev/pandas/issues/23369',
  'id': 374588539,
  'node_id': 'MDU6SXNzdWUzNzQ1ODg1Mzk=',
  'number': 23369,
  'title': 'memory usage after writing then reading a multi-indexed dataframe from an hdf5 increases dramatically',
  'user': {'login': 'headdab',
   'id': 1169194,
   'node_id': 'MDQ6VXNlcjExNjkxOTQ=',
   'avatar_url': 'https://avatars0.githubusercontent.com/u/1169194?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/headdab',
   'html_url': 'https://github.com/headdab',
   'followers_url': 'https://api.github.com/users/headdab/followers',
   'following_url': 'https://api.github.com/users/headdab/following{/other_user}',
   'gists_url': 'https://api.github.com/users/headdab/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/headdab/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/headdab/subscriptions',
   'organizations_url': 'https://api.github.com/users/headdab/orgs',
   'repos_url': 'https://api.github.com/users/headdab/repos',
   'events_url': 'https://api.github.com/users/headdab/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/headdab/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 0,
  'created_at': '2018-10-27T00:43:01Z',
  'updated_at': '2018-10-27T00:43:01Z',
  'closed_at': None,
  'author_association': 'NONE',
  'body': "#### Code Sample, a copy-pastable example if possible\r\n\r\n```python\r\n#!/usr/bin/env python\r\n\r\nimport numpy as np\r\nimport pandas as pd\r\n\r\nindex = pd.MultiIndex.from_product([list(range(10000)), list(range(10))])\r\ndf = pd.DataFrame(np.random.rand(100000, 10), index=index, columns=list(range(10)))\r\ndf = (df * 3840).astype(np.int16)\r\ndf.info()\r\n\r\nsdf = df.sample(1000)\r\nsdf.info()\r\n\r\nwith pd.HDFStore('test.h5') as h5:\r\n    h5['sdf'] = sdf\r\n\r\nsdf = pd.read_hdf('test.h5', 'sdf')\r\nsdf.info()\r\n```\r\n\r\n#### Problem description\r\n\r\nThe memory used by a multi-indexed dataframe increases dramatically after writing to and reading it back from an hdf5 data file.\r\n\r\n#### Expected Output\r\n\r\n```\r\nclass 'pandas.core.frame.DataFrame'>\r\nMultiIndex: 100000 entries, (0, 0) to (9999, 9)\r\nData columns (total 10 columns):\r\n0    100000 non-null int16\r\n1    100000 non-null int16\r\n2    100000 non-null int16\r\n3    100000 non-null int16\r\n4    100000 non-null int16\r\n5    100000 non-null int16\r\n6    100000 non-null int16\r\n7    100000 non-null int16\r\n8    100000 non-null int16\r\n9    100000 non-null int16\r\ndtypes: int16(10)\r\nmemory usage: 2.6 MB\r\n\r\n<class 'pandas.core.frame.DataFrame'>\r\nMultiIndex: 1000 entries, (6381, 5) to (7551, 4)\r\nData columns (total 10 columns):\r\n0    1000 non-null int16\r\n1    1000 non-null int16\r\n2    1000 non-null int16\r\n3    1000 non-null int16\r\n4    1000 non-null int16\r\n5    1000 non-null int16\r\n6    1000 non-null int16\r\n7    1000 non-null int16\r\n8    1000 non-null int16\r\n9    1000 non-null int16\r\ndtypes: int16(10)\r\nmemory usage: 100.7 KB\r\n\r\n<class 'pandas.core.frame.DataFrame'>\r\nMultiIndex: 1000 entries, (6381, 5) to (7551, 4)\r\nData columns (total 10 columns):\r\n0    1000 non-null int16\r\n1    1000 non-null int16\r\n2    1000 non-null int16\r\n3    1000 non-null int16\r\n4    1000 non-null int16\r\n5    1000 non-null int16\r\n6    1000 non-null int16\r\n7    1000 non-null int16\r\n8    1000 non-null int16\r\n9    1000 non-null int16\r\ndtypes: int16(10)\r\nmemory usage: 421.0 KB\r\n```\r\n\r\n- Note that the sparse version before writing to an hdf5 file uses 100kB, but it uses 421kB after I reread it from the hdf5 file.  This is over 4X the original memory usage.\r\n\r\n- As a note, the original array uses 2.6 MB to store 100000 * 10 * 2 = 2MB of array data (30% overhead), the sparse version before writing uses 100.7kB to store 1000*10*2 = 20kB of array data (400% overhead), and the final version, after rereading from the hd5 file uses 421kB to store 20kB of data (\r\n2000% overhead).\r\n\r\n- A simpler, non-multiindex case gave the same result before and after writing the data to an hdf5 file, with about 30% overhead.\r\n\r\n#### Output of ``pd.show_versions()``\r\n\r\n<details>\r\nINSTALLED VERSIONS                \r\n------------------                \r\ncommit: None                      \r\npython: 3.6.3.final.0             \r\npython-bits: 64                   \r\nOS: Linux                         \r\nOS-release: 4.13.0-41-generic     \r\nmachine: x86_64                   \r\nprocessor: x86_64                 \r\nbyteorder: little                 \r\nLC_ALL: None                      \r\nLANG: en_US.UTF-8                 \r\nLOCALE: en_US.UTF-8               \r\n\r\npandas: 0.23.4                    \r\npytest: None                      \r\npip: 10.0.1                       \r\nsetuptools: 32.3.1                \r\nCython: None                      \r\nnumpy: 1.14.5                     \r\nscipy: 1.1.0                      \r\npyarrow: None                     \r\nxarray: None                      \r\nIPython: 6.4.0                    \r\nsphinx: None                      \r\npatsy: None                       \r\ndateutil: 2.7.3                   \r\npytz: 2018.5                      \r\nblosc: None                       \r\nbottleneck: None                  \r\ntables: 3.4.4                     \r\nnumexpr: 2.6.8                    \r\nfeather: None                     \r\nmatplotlib: 2.2.2                 \r\nopenpyxl: None                    \r\nxlrd: None                        \r\nxlwt: None                        \r\nxlsxwriter: None                  \r\nlxml: None                        \r\nbs4: None                         \r\nhtml5lib: 1.0.1                   \r\nsqlalchemy: None                  \r\npymysql: None                     \r\npsycopg2: None                    \r\njinja2: 2.10                      \r\ns3fs: None                        \r\nfastparquet: None                 \r\npandas_gbq: None                  \r\npandas_datareader: None           \r\n</details>\r\n"},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23368',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23368/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23368/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23368/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23368',
  'id': 374537157,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MjE3NzQ0',
  'number': 23368,
  'title': 'REF: Cleanups, typing, memoryviews in tslibs',
  'user': {'login': 'jbrockmendel',
   'id': 8078968,
   'node_id': 'MDQ6VXNlcjgwNzg5Njg=',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/8078968?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jbrockmendel',
   'html_url': 'https://github.com/jbrockmendel',
   'followers_url': 'https://api.github.com/users/jbrockmendel/followers',
   'following_url': 'https://api.github.com/users/jbrockmendel/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jbrockmendel/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jbrockmendel/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jbrockmendel/subscriptions',
   'organizations_url': 'https://api.github.com/users/jbrockmendel/orgs',
   'repos_url': 'https://api.github.com/users/jbrockmendel/repos',
   'events_url': 'https://api.github.com/users/jbrockmendel/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jbrockmendel/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 0,
  'created_at': '2018-10-26T20:31:01Z',
  'updated_at': '2018-10-26T20:31:01Z',
  'closed_at': None,
  'author_association': 'MEMBER',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23368',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23368',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23368.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23368.patch'},
  'body': '- [ ] closes #xxxx\r\n- [ ] tests added / passed\r\n- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n- [ ] whatsnew entry\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23367',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23367/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23367/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23367/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23367',
  'id': 374528004,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MjEwNDE1',
  'number': 23367,
  'title': 'Fix import format at pandas/tests/io/parser directory',
  'user': {'login': 'mwoss',
   'id': 23535916,
   'node_id': 'MDQ6VXNlcjIzNTM1OTE2',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/23535916?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/mwoss',
   'html_url': 'https://github.com/mwoss',
   'followers_url': 'https://api.github.com/users/mwoss/followers',
   'following_url': 'https://api.github.com/users/mwoss/following{/other_user}',
   'gists_url': 'https://api.github.com/users/mwoss/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/mwoss/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/mwoss/subscriptions',
   'organizations_url': 'https://api.github.com/users/mwoss/orgs',
   'repos_url': 'https://api.github.com/users/mwoss/repos',
   'events_url': 'https://api.github.com/users/mwoss/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/mwoss/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 4,
  'created_at': '2018-10-26T20:01:31Z',
  'updated_at': '2018-10-27T00:44:49Z',
  'closed_at': None,
  'author_association': 'NONE',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23367',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23367',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23367.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23367.patch'},
  'body': '- [x] partial #23334\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n\r\nRan `isort --recursive pandas/tests/io/parser` and then checked imports using `isort --recursive --check-only pandas/tests/io/parser`\r\n\r\nThis PR also exceeded 20 file limit (22 files with setup.cfg), but I think it\'s acceptable and unnecessary to divide it to two separate PRs.\r\n\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23366',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23366/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23366/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23366/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23366',
  'id': 374521995,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MjA1NjM4',
  'number': 23366,
  'title': 'STY: proposed isort settings [ci skip] [skip ci] [ciskip] [skipci]',
  'user': {'login': 'jbrockmendel',
   'id': 8078968,
   'node_id': 'MDQ6VXNlcjgwNzg5Njg=',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/8078968?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jbrockmendel',
   'html_url': 'https://github.com/jbrockmendel',
   'followers_url': 'https://api.github.com/users/jbrockmendel/followers',
   'following_url': 'https://api.github.com/users/jbrockmendel/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jbrockmendel/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jbrockmendel/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jbrockmendel/subscriptions',
   'organizations_url': 'https://api.github.com/users/jbrockmendel/orgs',
   'repos_url': 'https://api.github.com/users/jbrockmendel/repos',
   'events_url': 'https://api.github.com/users/jbrockmendel/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jbrockmendel/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 1,
  'created_at': '2018-10-26T19:42:01Z',
  'updated_at': '2018-10-26T19:42:05Z',
  'closed_at': None,
  'author_association': 'MEMBER',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23366',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23366',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23366.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23366.patch'},
  'body': "(not sure which tag(s) skip the CI)\r\n\r\nI propose we change the isort settings to arrange within-pandas imports by dependency structure.  i.e. \r\n\r\n- `pandas._libs`, `pandas.compat`, `pandas.util._*`, `pandas.errors` are for the most part not dependent on pandas.core, so get their own section(s)\r\n- `pandas.core.dtypes` for the most part does not depend on the rest of `pandas.core`, so it goes next\r\n- then the rest of `pandas.core`\r\n- then pandas non-core: `pandas.io`, `pandas.plotting`, `pandas.tseries`\r\n\r\nWithin blocks I propose we stick to alphabetical ordering.  e.g. right now in `core.series` we have import `pandas.core.indexes.base as ibase` 35 lines away from all the other `pandas.core.indexes` imports.  These should be adjacent.\r\n\r\nThe main thing I'd still like to fix/improve is that in this PR isort is failing to put `from pandas import compat` with the other `pandas.compat` imports.\r\n\r\nPutting the trailing parentheses on the same line as the imports instead of a separate line is less important, but I prefer it because it makes it cleaner when I wrap lines in sublimetext.  Happy to revert that if it is a sticking point."},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23365',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23365/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23365/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23365/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23365',
  'id': 374521181,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MjA0OTcz',
  'number': 23365,
  'title': 'Fix import format at pandas/tests/extension directory',
  'user': {'login': 'mwoss',
   'id': 23535916,
   'node_id': 'MDQ6VXNlcjIzNTM1OTE2',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/23535916?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/mwoss',
   'html_url': 'https://github.com/mwoss',
   'followers_url': 'https://api.github.com/users/mwoss/followers',
   'following_url': 'https://api.github.com/users/mwoss/following{/other_user}',
   'gists_url': 'https://api.github.com/users/mwoss/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/mwoss/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/mwoss/subscriptions',
   'organizations_url': 'https://api.github.com/users/mwoss/orgs',
   'repos_url': 'https://api.github.com/users/mwoss/repos',
   'events_url': 'https://api.github.com/users/mwoss/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/mwoss/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 2,
  'created_at': '2018-10-26T19:39:17Z',
  'updated_at': '2018-10-26T22:14:20Z',
  'closed_at': None,
  'author_association': 'NONE',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23365',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23365',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23365.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23365.patch'},
  'body': '- [x] partial #23334 \r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n\r\nPR includes 21 files, but I think it\'s acceptable and unnecessary to divide it to two separate PRs.\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23364',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23364/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23364/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23364/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23364',
  'id': 374466617,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MTYzMDgy',
  'number': 23364,
  'title': 'Isort contributing guide',
  'user': {'login': 'alimcmaster1',
   'id': 16733618,
   'node_id': 'MDQ6VXNlcjE2NzMzNjE4',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/16733618?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/alimcmaster1',
   'html_url': 'https://github.com/alimcmaster1',
   'followers_url': 'https://api.github.com/users/alimcmaster1/followers',
   'following_url': 'https://api.github.com/users/alimcmaster1/following{/other_user}',
   'gists_url': 'https://api.github.com/users/alimcmaster1/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/alimcmaster1/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/alimcmaster1/subscriptions',
   'organizations_url': 'https://api.github.com/users/alimcmaster1/orgs',
   'repos_url': 'https://api.github.com/users/alimcmaster1/repos',
   'events_url': 'https://api.github.com/users/alimcmaster1/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/alimcmaster1/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 134699,
    'node_id': 'MDU6TGFiZWwxMzQ2OTk=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Docs',
    'name': 'Docs',
    'color': '3465A4',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 1,
  'created_at': '2018-10-26T16:54:43Z',
  'updated_at': '2018-10-26T22:50:25Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23364',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23364',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23364.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23364.patch'},
  'body': '- [x] follow up from #23096\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23363',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23363/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23363/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23363/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23363',
  'id': 374427545,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MTMyNjA1',
  'number': 23363,
  'title': 'COMPAT: update for latest flake8',
  'user': {'login': 'TomAugspurger',
   'id': 1312546,
   'node_id': 'MDQ6VXNlcjEzMTI1NDY=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/1312546?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/TomAugspurger',
   'html_url': 'https://github.com/TomAugspurger',
   'followers_url': 'https://api.github.com/users/TomAugspurger/followers',
   'following_url': 'https://api.github.com/users/TomAugspurger/following{/other_user}',
   'gists_url': 'https://api.github.com/users/TomAugspurger/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/TomAugspurger/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/TomAugspurger/subscriptions',
   'organizations_url': 'https://api.github.com/users/TomAugspurger/orgs',
   'repos_url': 'https://api.github.com/users/TomAugspurger/repos',
   'events_url': 'https://api.github.com/users/TomAugspurger/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/TomAugspurger/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 2,
  'created_at': '2018-10-26T15:10:45Z',
  'updated_at': '2018-10-26T22:33:00Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23363',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23363',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23363.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23363.patch'},
  'body': ''},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23362',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23362/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23362/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23362/events',
  'html_url': 'https://github.com/pandas-dev/pandas/issues/23362',
  'id': 374403630,
  'node_id': 'MDU6SXNzdWUzNzQ0MDM2MzA=',
  'number': 23362,
  'title': 'PERF: concat perf',
  'user': {'login': 'TomAugspurger',
   'id': 1312546,
   'node_id': 'MDQ6VXNlcjEzMTI1NDY=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/1312546?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/TomAugspurger',
   'html_url': 'https://github.com/TomAugspurger',
   'followers_url': 'https://api.github.com/users/TomAugspurger/followers',
   'following_url': 'https://api.github.com/users/TomAugspurger/following{/other_user}',
   'gists_url': 'https://api.github.com/users/TomAugspurger/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/TomAugspurger/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/TomAugspurger/subscriptions',
   'organizations_url': 'https://api.github.com/users/TomAugspurger/orgs',
   'repos_url': 'https://api.github.com/users/TomAugspurger/repos',
   'events_url': 'https://api.github.com/users/TomAugspurger/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/TomAugspurger/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 8935311,
    'node_id': 'MDU6TGFiZWw4OTM1MzEx',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Performance',
    'name': 'Performance',
    'color': 'a10c02',
    'default': False},
   {'id': 13098779,
    'node_id': 'MDU6TGFiZWwxMzA5ODc3OQ==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Reshaping',
    'name': 'Reshaping',
    'color': '02d7e1',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/32',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/32',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/32/labels',
   'id': 933188,
   'node_id': 'MDk6TWlsZXN0b25lOTMzMTg4',
   'number': 32,
   'title': 'Contributions Welcome',
   'description': 'Changes that would be nice to have in the next release. These issues are not blocking. They will be pushed to the next release if no one has time to fix them.',
   'creator': {'login': 'jreback',
    'id': 953992,
    'node_id': 'MDQ6VXNlcjk1Mzk5Mg==',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/953992?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jreback',
    'html_url': 'https://github.com/jreback',
    'followers_url': 'https://api.github.com/users/jreback/followers',
    'following_url': 'https://api.github.com/users/jreback/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jreback/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jreback/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jreback/subscriptions',
    'organizations_url': 'https://api.github.com/users/jreback/orgs',
    'repos_url': 'https://api.github.com/users/jreback/repos',
    'events_url': 'https://api.github.com/users/jreback/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jreback/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 1183,
   'closed_issues': 331,
   'state': 'open',
   'created_at': '2015-01-13T10:53:19Z',
   'updated_at': '2018-10-26T14:15:25Z',
   'due_on': '2020-12-31T08:00:00Z',
   'closed_at': None},
  'comments': 0,
  'created_at': '2018-10-26T14:15:14Z',
  'updated_at': '2018-10-26T14:15:37Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'body': "For `Series[period]`, `pd.concat` is about 6x slower than `PeriodArray._concat_same_type`. There's always going to be some overhead, but I  wonder how much we can narrow this.\r\n\r\n```python\r\nIn [1]: import numpy as np\r\n   ...: import pandas as pd\r\n   ...:\r\n   ...: a = np.random.randint(2000, 2100, size=1000)\r\n   ...: b = np.random.randint(2000, 2100, size=1000)\r\n   ...:\r\n   ...: x = pd.core.arrays.period_array(a, freq='B')\r\n   ...: y = pd.core.arrays.period_array(b, freq='B')\r\n   ...:\r\n   ...: s = pd.Series(x)\r\n   ...: t = pd.Series(y)\r\n\r\n\r\nIn [2]: %timeit pd.concat([s, t], ignore_index=True)\r\n523 µs ± 22.6 µs per loop (mean ± std. dev. of 7 runs, 1000 loops each)\r\n\r\nIn [3]: %timeit x._concat_same_type([x, y])\r\n90.1 µs ± 948 ns per loop (mean ± std. dev. of 7 runs, 10000 loops each)\r\n```"},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23361',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23361/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23361/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23361/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23361',
  'id': 374398026,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MTA5NTA1',
  'number': 23361,
  'title': 'unpin openpyxl',
  'user': {'login': 'alimcmaster1',
   'id': 16733618,
   'node_id': 'MDQ6VXNlcjE2NzMzNjE4',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/16733618?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/alimcmaster1',
   'html_url': 'https://github.com/alimcmaster1',
   'followers_url': 'https://api.github.com/users/alimcmaster1/followers',
   'following_url': 'https://api.github.com/users/alimcmaster1/following{/other_user}',
   'gists_url': 'https://api.github.com/users/alimcmaster1/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/alimcmaster1/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/alimcmaster1/subscriptions',
   'organizations_url': 'https://api.github.com/users/alimcmaster1/orgs',
   'repos_url': 'https://api.github.com/users/alimcmaster1/repos',
   'events_url': 'https://api.github.com/users/alimcmaster1/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/alimcmaster1/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 1,
  'created_at': '2018-10-26T14:02:04Z',
  'updated_at': '2018-10-26T22:28:20Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23361',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23361',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23361.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23361.patch'},
  'body': '- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n\r\n- Follow up from #22601.\r\n\r\n- Confirmed with openpyxl this bug was fixed in version 2.5.7 see [bitbucket issue here](https://bitbucket.org/openpyxl/openpyxl/issues/1093/newly-introduced-keyerror-problem-in)\r\n\r\nThis was release 13th Sept -> https://pypi.org/project/openpyxl/#history\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23359',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23359/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23359/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23359/events',
  'html_url': 'https://github.com/pandas-dev/pandas/issues/23359',
  'id': 374384534,
  'node_id': 'MDU6SXNzdWUzNzQzODQ1MzQ=',
  'number': 23359,
  'title': 'PERF: Investigate caching on PeriodArray',
  'user': {'login': 'TomAugspurger',
   'id': 1312546,
   'node_id': 'MDQ6VXNlcjEzMTI1NDY=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/1312546?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/TomAugspurger',
   'html_url': 'https://github.com/TomAugspurger',
   'followers_url': 'https://api.github.com/users/TomAugspurger/followers',
   'following_url': 'https://api.github.com/users/TomAugspurger/following{/other_user}',
   'gists_url': 'https://api.github.com/users/TomAugspurger/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/TomAugspurger/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/TomAugspurger/subscriptions',
   'organizations_url': 'https://api.github.com/users/TomAugspurger/orgs',
   'repos_url': 'https://api.github.com/users/TomAugspurger/repos',
   'events_url': 'https://api.github.com/users/TomAugspurger/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/TomAugspurger/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 8935311,
    'node_id': 'MDU6TGFiZWw4OTM1MzEx',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Performance',
    'name': 'Performance',
    'color': 'a10c02',
    'default': False},
   {'id': 60635328,
    'node_id': 'MDU6TGFiZWw2MDYzNTMyOA==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Period',
    'name': 'Period',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 0,
  'created_at': '2018-10-26T13:29:34Z',
  'updated_at': '2018-10-26T13:29:34Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'body': 'Start with benchmarks\r\n\r\n1. ops on PeriodArray and PeriodIndex\r\n2. ...\r\n\r\nIf we determine that caching attributes like `hasnans` and `isna` does help then we can investigate caching on PeriodArray.'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23358',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23358/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23358/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23358/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23358',
  'id': 374345603,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MDY3ODUx',
  'number': 23358,
  'title': 'CI: rebalance the travis ci jobs',
  'user': {'login': 'jreback',
   'id': 953992,
   'node_id': 'MDQ6VXNlcjk1Mzk5Mg==',
   'avatar_url': 'https://avatars2.githubusercontent.com/u/953992?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jreback',
   'html_url': 'https://github.com/jreback',
   'followers_url': 'https://api.github.com/users/jreback/followers',
   'following_url': 'https://api.github.com/users/jreback/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jreback/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jreback/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jreback/subscriptions',
   'organizations_url': 'https://api.github.com/users/jreback/orgs',
   'repos_url': 'https://api.github.com/users/jreback/repos',
   'events_url': 'https://api.github.com/users/jreback/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jreback/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 48070600,
    'node_id': 'MDU6TGFiZWw0ODA3MDYwMA==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/CI',
    'name': 'CI',
    'color': 'a2bca7',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 4,
  'created_at': '2018-10-26T11:38:35Z',
  'updated_at': '2018-10-26T22:45:35Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23358',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23358',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23358.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23358.patch'},
  'body': 'move some from the 3.6 build to 3.7 as the 3.6 is 15 min longer. mark the multi-thread tests as slow.'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23356',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23356/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23356/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23356/events',
  'html_url': 'https://github.com/pandas-dev/pandas/issues/23356',
  'id': 374298565,
  'node_id': 'MDU6SXNzdWUzNzQyOTg1NjU=',
  'number': 23356,
  'title': 'ENH: Tox as main entry point for development',
  'user': {'login': 'FHaase',
   'id': 41163037,
   'node_id': 'MDQ6VXNlcjQxMTYzMDM3',
   'avatar_url': 'https://avatars2.githubusercontent.com/u/41163037?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/FHaase',
   'html_url': 'https://github.com/FHaase',
   'followers_url': 'https://api.github.com/users/FHaase/followers',
   'following_url': 'https://api.github.com/users/FHaase/following{/other_user}',
   'gists_url': 'https://api.github.com/users/FHaase/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/FHaase/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/FHaase/subscriptions',
   'organizations_url': 'https://api.github.com/users/FHaase/orgs',
   'repos_url': 'https://api.github.com/users/FHaase/repos',
   'events_url': 'https://api.github.com/users/FHaase/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/FHaase/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 4,
  'created_at': '2018-10-26T09:23:52Z',
  'updated_at': '2018-10-26T13:26:52Z',
  'closed_at': None,
  'author_association': 'NONE',
  'body': "So I have been working on issue #23154 trying to setup flake8-rst as additional check for code within documentation.\r\n\r\nIt's working great, finding multiple places to fix, however in order to test I'm not able to run the appropriate commands.\r\n\r\n* created a conda environment\r\n* installed dependencies from `./ci/requirements_dev.txt` and `./ci/requirements-optional-conda.txt`\r\n* activated pandas-dev environment\r\n* executed `python make.py html` within `./doc` folder \r\n\r\nResulting in \r\n```\r\n~/.../pandas/core/algorithms.py in _factorize_array(values, na_sentinel, size_hint, na_value)\r\n    472     table = hash_klass(size_hint or len(values))\r\n    473     labels, uniques = table.factorize(values, na_sentinel=na_sentinel,\r\n--> 474                                       na_value=na_value)\r\n    475 \r\n    476     labels = ensure_platform_int(labels)\r\n\r\nTypeError: factorize() takes no keyword arguments\r\n```\r\nSo I can't really evaluate weather the changes I am going to make are correct.\r\n\r\nTrying to build pandas or running the test suite never worked for me as well. Maybe it's just my own error, but I think there are others getting these issues.\r\n\r\nAs the project is already featuring `tox` I'm proposing to enhance tox with all these use-cases so that after a fresh clone of the project someone can just type `tox -e docs` and tox creates a venv with all required dependencies and runs the build,\r\n`tox -e check` to run flake8, isort, validate_docstrings.py ...\r\n`tox` for a complete check of everything -> reducing failing ci-builds\r\n\r\nIn my opinion this could simplify someones first steps to contribute to pandas. What do you think?\r\n\r\n"},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23355',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23355/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23355/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23355/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23355',
  'id': 374280687,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI2MDE3MDE2',
  'number': 23355,
  'title': 'DOC: fixup whatsnew note for GH21394',
  'user': {'login': 'jorisvandenbossche',
   'id': 1020496,
   'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
   'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jorisvandenbossche',
   'html_url': 'https://github.com/jorisvandenbossche',
   'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
   'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
   'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
   'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
   'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 1,
  'created_at': '2018-10-26T08:34:33Z',
  'updated_at': '2018-10-26T21:18:56Z',
  'closed_at': None,
  'author_association': 'MEMBER',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23355',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23355',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23355.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23355.patch'},
  'body': 'xref https://github.com/pandas-dev/pandas/pull/21394 \r\n(also moved from enhancements to api changes)'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23354',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23354/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23354/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23354/events',
  'html_url': 'https://github.com/pandas-dev/pandas/issues/23354',
  'id': 374254493,
  'node_id': 'MDU6SXNzdWUzNzQyNTQ0OTM=',
  'number': 23354,
  'title': 'issue regarding fill missing value',
  'user': {'login': 'ayushpatidar',
   'id': 25405746,
   'node_id': 'MDQ6VXNlcjI1NDA1NzQ2',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/25405746?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/ayushpatidar',
   'html_url': 'https://github.com/ayushpatidar',
   'followers_url': 'https://api.github.com/users/ayushpatidar/followers',
   'following_url': 'https://api.github.com/users/ayushpatidar/following{/other_user}',
   'gists_url': 'https://api.github.com/users/ayushpatidar/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/ayushpatidar/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/ayushpatidar/subscriptions',
   'organizations_url': 'https://api.github.com/users/ayushpatidar/orgs',
   'repos_url': 'https://api.github.com/users/ayushpatidar/repos',
   'events_url': 'https://api.github.com/users/ayushpatidar/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/ayushpatidar/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 3,
  'created_at': '2018-10-26T07:09:34Z',
  'updated_at': '2018-10-26T11:30:04Z',
  'closed_at': None,
  'author_association': 'NONE',
  'body': 'problem description : \r\nThere is no function available in pandas which can fill missing value in dataframe according to column type i.e whether column is of categorical type or numeric type.\r\nIt will be easier if we provide a direct function which can fill missing value according to the type of column\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23353',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23353/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23353/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23353/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23353',
  'id': 374223668,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTczOTkw',
  'number': 23353,
  'title': 'BUG: Fix IntervalTree handling of NaN',
  'user': {'login': 'jschendel',
   'id': 5332445,
   'node_id': 'MDQ6VXNlcjUzMzI0NDU=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/5332445?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jschendel',
   'html_url': 'https://github.com/jschendel',
   'followers_url': 'https://api.github.com/users/jschendel/followers',
   'following_url': 'https://api.github.com/users/jschendel/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jschendel/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jschendel/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jschendel/subscriptions',
   'organizations_url': 'https://api.github.com/users/jschendel/orgs',
   'repos_url': 'https://api.github.com/users/jschendel/repos',
   'events_url': 'https://api.github.com/users/jschendel/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jschendel/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 76811,
    'node_id': 'MDU6TGFiZWw3NjgxMQ==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Bug',
    'name': 'Bug',
    'color': 'e10c02',
    'default': False},
   {'id': 150096370,
    'node_id': 'MDU6TGFiZWwxNTAwOTYzNzA=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Interval',
    'name': 'Interval',
    'color': '009800',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 4,
  'created_at': '2018-10-26T04:37:12Z',
  'updated_at': '2018-10-26T19:44:37Z',
  'closed_at': None,
  'author_association': 'MEMBER',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23353',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23353',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23353.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23353.patch'},
  'body': '- [X] closes #23352\r\n- [X] tests added / passed\r\n- [X] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n- [X] whatsnew entry\r\n\r\nxref #23327 : As far as I can tell the only reason that PR is failing is because of tests raising a `RuntimeWarning` due to this bug.\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23352',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23352/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23352/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23352/events',
  'html_url': 'https://github.com/pandas-dev/pandas/issues/23352',
  'id': 374210886,
  'node_id': 'MDU6SXNzdWUzNzQyMTA4ODY=',
  'number': 23352,
  'title': 'BUG: IntervalTree should not have NaN in nodes',
  'user': {'login': 'jschendel',
   'id': 5332445,
   'node_id': 'MDQ6VXNlcjUzMzI0NDU=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/5332445?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jschendel',
   'html_url': 'https://github.com/jschendel',
   'followers_url': 'https://api.github.com/users/jschendel/followers',
   'following_url': 'https://api.github.com/users/jschendel/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jschendel/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jschendel/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jschendel/subscriptions',
   'organizations_url': 'https://api.github.com/users/jschendel/orgs',
   'repos_url': 'https://api.github.com/users/jschendel/repos',
   'events_url': 'https://api.github.com/users/jschendel/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jschendel/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 76811,
    'node_id': 'MDU6TGFiZWw3NjgxMQ==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Bug',
    'name': 'Bug',
    'color': 'e10c02',
    'default': False},
   {'id': 150096370,
    'node_id': 'MDU6TGFiZWwxNTAwOTYzNzA=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Interval',
    'name': 'Interval',
    'color': '009800',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 0,
  'created_at': '2018-10-26T03:17:11Z',
  'updated_at': '2018-10-26T03:17:11Z',
  'closed_at': None,
  'author_association': 'MEMBER',
  'body': "#### Code Sample, a copy-pastable example if possible\r\nInitializing an `IntervalTree`  with arrays containing `np.nan` can trigger a `RuntimeWarning`:\r\n```python\r\nIn [2]: left, right = [0, 1, 2, np.nan], [1, 2, 3, np.nan]\r\n\r\nIn [3]: tree = pd._libs.interval.IntervalTree(left, right, leaf_size=2)\r\n/home/jeremy/anaconda3/lib/python3.6/site-packages/numpy/lib/function_base.py:4033: RuntimeWarning: Invalid value encountered in median\r\n  r = func(a, **kwargs)\r\n```\r\nThis causes some attributes to be incorrectly set as `np.nan`, which can lead to incorrect results:\r\n```python\r\nIn [4]: tree.get_loc(0.5)\r\nOut[4]: array([0, 1, 2, 3])\r\n```\r\n#### Problem description\r\n\r\nInitializing an `IntervalTree` with data containing `np.nan` triggers a `RuntimeWarning` and can lead to incorrect results.\r\n\r\n#### Expected Output\r\nI'd expect no warnings to be raised and for the `get_loc` query to be correct.\r\n\r\n#### Output of ``pd.show_versions()``\r\n\r\n<details>\r\n\r\nINSTALLED VERSIONS\r\n------------------\r\ncommit: 437f31cb609372f465aaa853bf4b2299a9550716\r\npython: 3.6.5.final.0\r\npython-bits: 64\r\nOS: Linux\r\nOS-release: 4.14.29-galliumos\r\nmachine: x86_64\r\nprocessor: x86_64\r\nbyteorder: little\r\nLC_ALL: None\r\nLANG: en_US.UTF-8\r\nLOCALE: en_US.UTF-8\r\n\r\npandas: 0.24.0.dev0+824.g437f31c\r\npytest: 3.5.1\r\npip: 18.0\r\nsetuptools: 39.1.0\r\nCython: 0.28.2\r\nnumpy: 1.14.3\r\nscipy: 1.1.0\r\npyarrow: None\r\nxarray: None\r\nIPython: 6.4.0\r\nsphinx: 1.7.4\r\npatsy: 0.5.0\r\ndateutil: 2.7.3\r\npytz: 2018.4\r\nblosc: None\r\nbottleneck: 1.2.1\r\ntables: 3.4.3\r\nnumexpr: 2.6.5\r\nfeather: None\r\nmatplotlib: 2.2.2\r\nopenpyxl: 2.5.3\r\nxlrd: 1.1.0\r\nxlwt: 1.3.0\r\nxlsxwriter: 1.0.4\r\nlxml: 4.2.1\r\nbs4: 4.6.0\r\nhtml5lib: 1.0.1\r\nsqlalchemy: 1.2.7\r\npymysql: None\r\npsycopg2: None\r\njinja2: 2.10\r\ns3fs: None\r\nfastparquet: None\r\npandas_gbq: None\r\npandas_datareader: None\r\ngcsfs: None\r\n\r\n</details>\r\n"},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23351',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23351/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23351/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23351/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23351',
  'id': 374196614,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTUzODIw',
  'number': 23351,
  'title': 'Fix import format pandas/tests/indexing',
  'user': {'login': 'amphy',
   'id': 5441213,
   'node_id': 'MDQ6VXNlcjU0NDEyMTM=',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/5441213?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/amphy',
   'html_url': 'https://github.com/amphy',
   'followers_url': 'https://api.github.com/users/amphy/followers',
   'following_url': 'https://api.github.com/users/amphy/following{/other_user}',
   'gists_url': 'https://api.github.com/users/amphy/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/amphy/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/amphy/subscriptions',
   'organizations_url': 'https://api.github.com/users/amphy/orgs',
   'repos_url': 'https://api.github.com/users/amphy/repos',
   'events_url': 'https://api.github.com/users/amphy/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/amphy/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 7,
  'created_at': '2018-10-26T01:53:26Z',
  'updated_at': '2018-10-27T00:00:11Z',
  'closed_at': None,
  'author_association': 'NONE',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23351',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23351',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23351.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23351.patch'},
  'body': '- [x] xref #23334\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n\r\nRan `isort --recursive pandas` and then checked imports using `isort --recursive --check-only pandas`\r\n\r\nPR capped at 20 files, but 21 files changed because it includes setup.cfg which has also been changed.\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23349',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23349/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23349/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23349/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23349',
  'id': 374183523,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTQ0MTgy',
  'number': 23349,
  'title': 'API/TST: make hasnans always return python booleans',
  'user': {'login': 'topper-123',
   'id': 26364415,
   'node_id': 'MDQ6VXNlcjI2MzY0NDE1',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/26364415?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/topper-123',
   'html_url': 'https://github.com/topper-123',
   'followers_url': 'https://api.github.com/users/topper-123/followers',
   'following_url': 'https://api.github.com/users/topper-123/following{/other_user}',
   'gists_url': 'https://api.github.com/users/topper-123/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/topper-123/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/topper-123/subscriptions',
   'organizations_url': 'https://api.github.com/users/topper-123/orgs',
   'repos_url': 'https://api.github.com/users/topper-123/repos',
   'events_url': 'https://api.github.com/users/topper-123/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/topper-123/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 31404521,
    'node_id': 'MDU6TGFiZWwzMTQwNDUyMQ==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Dtypes',
    'name': 'Dtypes',
    'color': 'e102d8',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 4,
  'created_at': '2018-10-26T00:33:05Z',
  'updated_at': '2018-10-26T23:38:48Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23349',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23349',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23349.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23349.patch'},
  'body': '- [x] xref #23294\r\n- [x] tests added / passed\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n- [x] whatsnew entry\r\n\r\n``Index.hasnans`` currently returns either a python or a numpy boolean, depending on circumstances. This PR ensures that only python booleans ae returned and makes the tests for hasnans stricter.\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23348',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23348/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23348/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23348/events',
  'html_url': 'https://github.com/pandas-dev/pandas/issues/23348',
  'id': 374180778,
  'node_id': 'MDU6SXNzdWUzNzQxODA3Nzg=',
  'number': 23348,
  'title': 'Pandas should validate display.max_rows option',
  'user': {'login': 'cosinequanon',
   'id': 1226424,
   'node_id': 'MDQ6VXNlcjEyMjY0MjQ=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/1226424?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/cosinequanon',
   'html_url': 'https://github.com/cosinequanon',
   'followers_url': 'https://api.github.com/users/cosinequanon/followers',
   'following_url': 'https://api.github.com/users/cosinequanon/following{/other_user}',
   'gists_url': 'https://api.github.com/users/cosinequanon/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/cosinequanon/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/cosinequanon/subscriptions',
   'organizations_url': 'https://api.github.com/users/cosinequanon/orgs',
   'repos_url': 'https://api.github.com/users/cosinequanon/repos',
   'events_url': 'https://api.github.com/users/cosinequanon/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/cosinequanon/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 42670965,
    'node_id': 'MDU6TGFiZWw0MjY3MDk2NQ==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Error%20Reporting',
    'name': 'Error Reporting',
    'color': 'ffa0ff',
    'default': False},
   {'id': 13101118,
    'node_id': 'MDU6TGFiZWwxMzEwMTExOA==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Output-Formatting',
    'name': 'Output-Formatting',
    'color': 'ededed',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': None,
  'comments': 1,
  'created_at': '2018-10-26T00:17:52Z',
  'updated_at': '2018-10-26T05:23:26Z',
  'closed_at': None,
  'author_association': 'NONE',
  'body': "#### Code Sample, a copy-pastable example if possible\r\n\r\n```python\r\nimport pandas as pd\r\npd.set_option('display.max_rows', -1)\r\ntest = [['a', 'b'] ,['c','d'] ,['f','g']]\r\npd.DataFrame(test, columns=['columna', 'columnb'])\r\n```\r\n#### Problem description\r\n\r\nThis incorrectly print's 4 rows:\r\n\r\n```\r\nOut[1]:\r\n..     ...     ...\r\n   columna columnb\r\n0        a       b\r\n1        c       d\r\n1        c       d\r\n2        f       g\r\n\r\n[3 rows x 2 columns]\r\n```\r\nPandas should not allow negative numbers for this setting because it does non-sensical things. In many other places -1 is used to represent an unbounded number so setting it -1 is actually intuitive but it doesn't work correctly and we should fail fast instead of confusing users.\r\n\r\n#### Expected Output\r\n\r\n```\r\nOut[1]:\r\n..     ...     ...\r\n   columna columnb\r\n0        a       b\r\n1        c       d\r\n2        f       g\r\n\r\n[3 rows x 2 columns]\r\n```\r\n\r\n#### Output of ``pd.show_versions()``\r\n\r\n<details>\r\n\r\n[paste the output of ``pd.show_versions()`` here below this line]\r\nINSTALLED VERSIONS\r\n------------------\r\ncommit: None\r\npython: 3.6.3.candidate.1\r\npython-bits: 64\r\nOS: Linux\r\nOS-release: 4.11.3-67_fbk17_4093_g2bf19e7a0b95\r\nmachine: x86_64\r\nprocessor: x86_64\r\nbyteorder: little\r\nLC_ALL: \r\nLANG: en_US.UTF-8\r\nLOCALE: en_US.UTF-8\r\n\r\npandas: 0.23.4\r\npytest: None\r\npip: None\r\nsetuptools: 40.4.3\r\nCython: 0.29a0\r\nnumpy: 1.15.1\r\nscipy: 1.1.0\r\npyarrow: None\r\nxarray: None\r\nIPython: 6.5.0\r\nsphinx: None\r\npatsy: 0.4.1\r\ndateutil: 2.7.3\r\npytz: 2018.4\r\nblosc: None\r\nbottleneck: None\r\ntables: None\r\nnumexpr: None\r\nfeather: None\r\nmatplotlib: 2.2.3\r\nopenpyxl: 2.4.11\r\nxlrd: 0.9.4\r\nxlwt: None\r\nxlsxwriter: None\r\nlxml: 3.5.0\r\nbs4: None\r\nhtml5lib: 0.9999999\r\nsqlalchemy: 1.1.13\r\npymysql: None\r\npsycopg2: None\r\njinja2: 2.10\r\ns3fs: None\r\nfastparquet: None\r\npandas_gbq: None\r\npandas_datareader: None\r\n</details>\r\n"},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23347',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23347/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23347/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23347/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23347',
  'id': 374172080,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTM1NDA2',
  'number': 23347,
  'title': 'Run Isort on tests/util single PR',
  'user': {'login': 'thoo',
   'id': 6972290,
   'node_id': 'MDQ6VXNlcjY5NzIyOTA=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/6972290?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/thoo',
   'html_url': 'https://github.com/thoo',
   'followers_url': 'https://api.github.com/users/thoo/followers',
   'following_url': 'https://api.github.com/users/thoo/following{/other_user}',
   'gists_url': 'https://api.github.com/users/thoo/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/thoo/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/thoo/subscriptions',
   'organizations_url': 'https://api.github.com/users/thoo/orgs',
   'repos_url': 'https://api.github.com/users/thoo/repos',
   'events_url': 'https://api.github.com/users/thoo/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/thoo/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 2,
  'created_at': '2018-10-25T23:30:59Z',
  'updated_at': '2018-10-26T17:17:28Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23347',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23347',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23347.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23347.patch'},
  'body': '- [x] partial  #23334\r\n- [x] tests added / passed\r\n- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\nRun `isort -rc pandas/tests/util/`\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23346',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23346/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23346/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23346/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23346',
  'id': 374154969,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTIxNzIx',
  'number': 23346,
  'title': 'Run Isort on tests/arrays single PR',
  'user': {'login': 'thoo',
   'id': 6972290,
   'node_id': 'MDQ6VXNlcjY5NzIyOTA=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/6972290?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/thoo',
   'html_url': 'https://github.com/thoo',
   'followers_url': 'https://api.github.com/users/thoo/followers',
   'following_url': 'https://api.github.com/users/thoo/following{/other_user}',
   'gists_url': 'https://api.github.com/users/thoo/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/thoo/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/thoo/subscriptions',
   'organizations_url': 'https://api.github.com/users/thoo/orgs',
   'repos_url': 'https://api.github.com/users/thoo/repos',
   'events_url': 'https://api.github.com/users/thoo/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/thoo/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 3,
  'created_at': '2018-10-25T22:17:07Z',
  'updated_at': '2018-10-26T16:06:31Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23346',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23346',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23346.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23346.patch'},
  'body': '- [x] partial #23334\r\n- [x] tests added / passed\r\n- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\nRun `isort -rc pandas/tests/arrays/`'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23345',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23345/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23345/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23345/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23345',
  'id': 374152700,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTE5OTEw',
  'number': 23345,
  'title': 'BUG: Fix date_range overflow',
  'user': {'login': 'jbrockmendel',
   'id': 8078968,
   'node_id': 'MDQ6VXNlcjgwNzg5Njg=',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/8078968?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jbrockmendel',
   'html_url': 'https://github.com/jbrockmendel',
   'followers_url': 'https://api.github.com/users/jbrockmendel/followers',
   'following_url': 'https://api.github.com/users/jbrockmendel/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jbrockmendel/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jbrockmendel/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jbrockmendel/subscriptions',
   'organizations_url': 'https://api.github.com/users/jbrockmendel/orgs',
   'repos_url': 'https://api.github.com/users/jbrockmendel/repos',
   'events_url': 'https://api.github.com/users/jbrockmendel/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jbrockmendel/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 76811,
    'node_id': 'MDU6TGFiZWw3NjgxMQ==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Bug',
    'name': 'Bug',
    'color': 'e10c02',
    'default': False},
   {'id': 211840,
    'node_id': 'MDU6TGFiZWwyMTE4NDA=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Timeseries',
    'name': 'Timeseries',
    'color': 'AFEEEE',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 2,
  'created_at': '2018-10-25T22:09:13Z',
  'updated_at': '2018-10-26T14:31:22Z',
  'closed_at': None,
  'author_association': 'MEMBER',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23345',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23345',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23345.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23345.patch'},
  'body': '- [x] closes #19740\r\n- [x] tests added / passed\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n- [x] whatsnew entry\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23344',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23344/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23344/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23344/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23344',
  'id': 374151204,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTE4Njg4',
  'number': 23344,
  'title': 'Run Isort on tests/series single pr',
  'user': {'login': 'thoo',
   'id': 6972290,
   'node_id': 'MDQ6VXNlcjY5NzIyOTA=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/6972290?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/thoo',
   'html_url': 'https://github.com/thoo',
   'followers_url': 'https://api.github.com/users/thoo/followers',
   'following_url': 'https://api.github.com/users/thoo/following{/other_user}',
   'gists_url': 'https://api.github.com/users/thoo/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/thoo/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/thoo/subscriptions',
   'organizations_url': 'https://api.github.com/users/thoo/orgs',
   'repos_url': 'https://api.github.com/users/thoo/repos',
   'events_url': 'https://api.github.com/users/thoo/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/thoo/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 1,
  'created_at': '2018-10-25T22:04:05Z',
  'updated_at': '2018-10-27T00:52:20Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23344',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23344',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23344.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23344.patch'},
  'body': '- [x] partial #23334\r\n- [x] tests added / passed\r\n- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\nRun `isort -rc pandas/tests/series/`'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23343',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23343/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23343/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23343/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23343',
  'id': 374146341,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTE0ODM0',
  'number': 23343,
  'title': 'Run Isort on tests/indexes P4/Final',
  'user': {'login': 'thoo',
   'id': 6972290,
   'node_id': 'MDQ6VXNlcjY5NzIyOTA=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/6972290?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/thoo',
   'html_url': 'https://github.com/thoo',
   'followers_url': 'https://api.github.com/users/thoo/followers',
   'following_url': 'https://api.github.com/users/thoo/following{/other_user}',
   'gists_url': 'https://api.github.com/users/thoo/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/thoo/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/thoo/subscriptions',
   'organizations_url': 'https://api.github.com/users/thoo/orgs',
   'repos_url': 'https://api.github.com/users/thoo/repos',
   'events_url': 'https://api.github.com/users/thoo/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/thoo/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 3,
  'created_at': '2018-10-25T21:48:11Z',
  'updated_at': '2018-10-27T01:19:14Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23343',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23343',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23343.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23343.patch'},
  'body': '- [x] partial #23334\r\n- [x] tests added / passed\r\n- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\nRun `isort -rc pandas/tests/indexes/`\r\n\r\nPR is capped at 20 files. So this is not all the files modified from `pandas/tests/indexes/`. So this is Part Four  ( last pr) of this directory `pandas/tests/indexes/`. '},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23342',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23342/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23342/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23342/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23342',
  'id': 374145789,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTE0Mzk1',
  'number': 23342,
  'title': 'Fix+Test Timedelta.__mul__(nan)',
  'user': {'login': 'jbrockmendel',
   'id': 8078968,
   'node_id': 'MDQ6VXNlcjgwNzg5Njg=',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/8078968?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/jbrockmendel',
   'html_url': 'https://github.com/jbrockmendel',
   'followers_url': 'https://api.github.com/users/jbrockmendel/followers',
   'following_url': 'https://api.github.com/users/jbrockmendel/following{/other_user}',
   'gists_url': 'https://api.github.com/users/jbrockmendel/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/jbrockmendel/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/jbrockmendel/subscriptions',
   'organizations_url': 'https://api.github.com/users/jbrockmendel/orgs',
   'repos_url': 'https://api.github.com/users/jbrockmendel/repos',
   'events_url': 'https://api.github.com/users/jbrockmendel/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/jbrockmendel/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 47223669,
    'node_id': 'MDU6TGFiZWw0NzIyMzY2OQ==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Numeric',
    'name': 'Numeric',
    'color': '006b75',
    'default': False},
   {'id': 49597148,
    'node_id': 'MDU6TGFiZWw0OTU5NzE0OA==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Timedelta',
    'name': 'Timedelta',
    'color': '5319e7',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 2,
  'created_at': '2018-10-25T21:46:23Z',
  'updated_at': '2018-10-26T03:10:06Z',
  'closed_at': None,
  'author_association': 'MEMBER',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23342',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23342',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23342.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23342.patch'},
  'body': 'Specifically, `np.float64("NAN")` which in master gets caught by the `hasattr(other, "dtype")` branch and incorrectly returns `np.timedelta64("NaT", "ns")` instead of `NaT`\r\n\r\n- [ ] closes #xxxx\r\n- [x] tests added / passed\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n- [ ] whatsnew entry\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23340',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23340/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23340/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23340/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23340',
  'id': 374144488,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTEzMzUy',
  'number': 23340,
  'title': 'Run Isort on tests/indexes part three',
  'user': {'login': 'thoo',
   'id': 6972290,
   'node_id': 'MDQ6VXNlcjY5NzIyOTA=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/6972290?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/thoo',
   'html_url': 'https://github.com/thoo',
   'followers_url': 'https://api.github.com/users/thoo/followers',
   'following_url': 'https://api.github.com/users/thoo/following{/other_user}',
   'gists_url': 'https://api.github.com/users/thoo/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/thoo/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/thoo/subscriptions',
   'organizations_url': 'https://api.github.com/users/thoo/orgs',
   'repos_url': 'https://api.github.com/users/thoo/repos',
   'events_url': 'https://api.github.com/users/thoo/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/thoo/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 3,
  'created_at': '2018-10-25T21:42:09Z',
  'updated_at': '2018-10-26T13:10:40Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23340',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23340',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23340.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23340.patch'},
  'body': '- [x] partial #23334\r\n- [x] tests added / passed\r\n- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\nRun `isort -rc pandas/tests/indexes/`\r\n\r\nPR is capped at 20 files. So this is not all the files modified from `pandas/tests/indexes/`. So this is Part Three of this directory `pandas/tests/indexes/`. \r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23339',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23339/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23339/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23339/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23339',
  'id': 374141594,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTExMDYw',
  'number': 23339,
  'title': 'Fix import format tests/indexes/multi Part Two',
  'user': {'login': 'thoo',
   'id': 6972290,
   'node_id': 'MDQ6VXNlcjY5NzIyOTA=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/6972290?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/thoo',
   'html_url': 'https://github.com/thoo',
   'followers_url': 'https://api.github.com/users/thoo/followers',
   'following_url': 'https://api.github.com/users/thoo/following{/other_user}',
   'gists_url': 'https://api.github.com/users/thoo/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/thoo/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/thoo/subscriptions',
   'organizations_url': 'https://api.github.com/users/thoo/orgs',
   'repos_url': 'https://api.github.com/users/thoo/repos',
   'events_url': 'https://api.github.com/users/thoo/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/thoo/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 2,
  'created_at': '2018-10-25T21:33:08Z',
  'updated_at': '2018-10-27T01:02:47Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23339',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23339',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23339.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23339.patch'},
  'body': '- [x] partial  #23334\r\n- [x] tests added / passed\r\n- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\nRun `isort -rc pandas/tests/indexes/`\r\n\r\nPR is capped at 20 files. So this is not all the files modified from `pandas/tests/indexes/`. So this is Part Two of this directory `pandas/tests/indexes/`. \r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23338',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23338/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23338/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23338/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23338',
  'id': 374139649,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTA5NTIw',
  'number': 23338,
  'title': 'DOC: Added MultiIndex Example for Series Min',
  'user': {'login': 'vadakattu',
   'id': 13705459,
   'node_id': 'MDQ6VXNlcjEzNzA1NDU5',
   'avatar_url': 'https://avatars2.githubusercontent.com/u/13705459?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/vadakattu',
   'html_url': 'https://github.com/vadakattu',
   'followers_url': 'https://api.github.com/users/vadakattu/followers',
   'following_url': 'https://api.github.com/users/vadakattu/following{/other_user}',
   'gists_url': 'https://api.github.com/users/vadakattu/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/vadakattu/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/vadakattu/subscriptions',
   'organizations_url': 'https://api.github.com/users/vadakattu/orgs',
   'repos_url': 'https://api.github.com/users/vadakattu/repos',
   'events_url': 'https://api.github.com/users/vadakattu/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/vadakattu/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 134699,
    'node_id': 'MDU6TGFiZWwxMzQ2OTk=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Docs',
    'name': 'Docs',
    'color': '3465A4',
    'default': False},
   {'id': 71268330,
    'node_id': 'MDU6TGFiZWw3MTI2ODMzMA==',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/MultiIndex',
    'name': 'MultiIndex',
    'color': '207de5',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 4,
  'created_at': '2018-10-25T21:27:04Z',
  'updated_at': '2018-10-26T01:52:57Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23338',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23338',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23338.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23338.patch'},
  'body': 'Corollary to #23298\r\n- [X] tests added / passed\r\n- [X] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23337',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23337/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23337/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23337/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23337',
  'id': 374137966,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTA4MjAy',
  'number': 23337,
  'title': 'Fix import format tests/indexes/ "Part One"',
  'user': {'login': 'thoo',
   'id': 6972290,
   'node_id': 'MDQ6VXNlcjY5NzIyOTA=',
   'avatar_url': 'https://avatars3.githubusercontent.com/u/6972290?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/thoo',
   'html_url': 'https://github.com/thoo',
   'followers_url': 'https://api.github.com/users/thoo/followers',
   'following_url': 'https://api.github.com/users/thoo/following{/other_user}',
   'gists_url': 'https://api.github.com/users/thoo/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/thoo/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/thoo/subscriptions',
   'organizations_url': 'https://api.github.com/users/thoo/orgs',
   'repos_url': 'https://api.github.com/users/thoo/repos',
   'events_url': 'https://api.github.com/users/thoo/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/thoo/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 6,
  'created_at': '2018-10-25T21:21:52Z',
  'updated_at': '2018-10-26T13:00:46Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23337',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23337',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23337.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23337.patch'},
  'body': '- [x] xref #23334\r\n- [x] tests added / passed\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\nRun `isort -rc pandas/tests/indexes/`\r\n\r\nPR is capped at 20 files. So this is not all the files modified from `pandas/tests/indexes/`. So this is Part One of this directory `pandas/tests/indexes/`. \r\n'},
 {'url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23336',
  'repository_url': 'https://api.github.com/repos/pandas-dev/pandas',
  'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23336/labels{/name}',
  'comments_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23336/comments',
  'events_url': 'https://api.github.com/repos/pandas-dev/pandas/issues/23336/events',
  'html_url': 'https://github.com/pandas-dev/pandas/pull/23336',
  'id': 374129938,
  'node_id': 'MDExOlB1bGxSZXF1ZXN0MjI1OTAxNzc0',
  'number': 23336,
  'title': 'Partialy fix issue #23334 - isort pandas/core/dtypes directory',
  'user': {'login': 'alexander-ponomaroff',
   'id': 33966871,
   'node_id': 'MDQ6VXNlcjMzOTY2ODcx',
   'avatar_url': 'https://avatars1.githubusercontent.com/u/33966871?v=4',
   'gravatar_id': '',
   'url': 'https://api.github.com/users/alexander-ponomaroff',
   'html_url': 'https://github.com/alexander-ponomaroff',
   'followers_url': 'https://api.github.com/users/alexander-ponomaroff/followers',
   'following_url': 'https://api.github.com/users/alexander-ponomaroff/following{/other_user}',
   'gists_url': 'https://api.github.com/users/alexander-ponomaroff/gists{/gist_id}',
   'starred_url': 'https://api.github.com/users/alexander-ponomaroff/starred{/owner}{/repo}',
   'subscriptions_url': 'https://api.github.com/users/alexander-ponomaroff/subscriptions',
   'organizations_url': 'https://api.github.com/users/alexander-ponomaroff/orgs',
   'repos_url': 'https://api.github.com/users/alexander-ponomaroff/repos',
   'events_url': 'https://api.github.com/users/alexander-ponomaroff/events{/privacy}',
   'received_events_url': 'https://api.github.com/users/alexander-ponomaroff/received_events',
   'type': 'User',
   'site_admin': False},
  'labels': [{'id': 106935113,
    'node_id': 'MDU6TGFiZWwxMDY5MzUxMTM=',
    'url': 'https://api.github.com/repos/pandas-dev/pandas/labels/Style',
    'name': 'Style',
    'color': 'eb6420',
    'default': False}],
  'state': 'open',
  'locked': False,
  'assignee': None,
  'assignees': [],
  'milestone': {'url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55',
   'html_url': 'https://github.com/pandas-dev/pandas/milestone/55',
   'labels_url': 'https://api.github.com/repos/pandas-dev/pandas/milestones/55/labels',
   'id': 3228419,
   'node_id': 'MDk6TWlsZXN0b25lMzIyODQxOQ==',
   'number': 55,
   'title': '0.24.0',
   'description': '',
   'creator': {'login': 'jorisvandenbossche',
    'id': 1020496,
    'node_id': 'MDQ6VXNlcjEwMjA0OTY=',
    'avatar_url': 'https://avatars2.githubusercontent.com/u/1020496?v=4',
    'gravatar_id': '',
    'url': 'https://api.github.com/users/jorisvandenbossche',
    'html_url': 'https://github.com/jorisvandenbossche',
    'followers_url': 'https://api.github.com/users/jorisvandenbossche/followers',
    'following_url': 'https://api.github.com/users/jorisvandenbossche/following{/other_user}',
    'gists_url': 'https://api.github.com/users/jorisvandenbossche/gists{/gist_id}',
    'starred_url': 'https://api.github.com/users/jorisvandenbossche/starred{/owner}{/repo}',
    'subscriptions_url': 'https://api.github.com/users/jorisvandenbossche/subscriptions',
    'organizations_url': 'https://api.github.com/users/jorisvandenbossche/orgs',
    'repos_url': 'https://api.github.com/users/jorisvandenbossche/repos',
    'events_url': 'https://api.github.com/users/jorisvandenbossche/events{/privacy}',
    'received_events_url': 'https://api.github.com/users/jorisvandenbossche/received_events',
    'type': 'User',
    'site_admin': False},
   'open_issues': 182,
   'closed_issues': 966,
   'state': 'open',
   'created_at': '2018-03-29T12:00:12Z',
   'updated_at': '2018-10-26T22:06:46Z',
   'due_on': '2018-11-30T08:00:00Z',
   'closed_at': None},
  'comments': 17,
  'created_at': '2018-10-25T20:57:52Z',
  'updated_at': '2018-10-27T00:32:28Z',
  'closed_at': None,
  'author_association': 'CONTRIBUTOR',
  'pull_request': {'url': 'https://api.github.com/repos/pandas-dev/pandas/pulls/23336',
   'html_url': 'https://github.com/pandas-dev/pandas/pull/23336',
   'diff_url': 'https://github.com/pandas-dev/pandas/pull/23336.diff',
   'patch_url': 'https://github.com/pandas-dev/pandas/pull/23336.patch'},
  'body': 'The imports have been sorted with isort in the pandas/core/dtypes directory.\r\n\r\nMoving onto sorting the pandas/core/groupby directory.\r\n\r\n- [x] partly #23334\r\n- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`\r\n'}]

data[0]['title']

'memory usage after writing then reading a multi-indexed dataframe from an hdf5 increases dramatically'

issues = pd.DataFrame(data,columns=['number','title','labels','state'])
issues

	number	title	labels	state
0	23369	memory usage after writing then reading a mult...	[]	open
1	23368	REF: Cleanups, typing, memoryviews in tslibs	[]	open
2	23367	Fix import format at pandas/tests/io/parser di...	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
3	23366	STY: proposed isort settings [ci skip] [skip c...	[]	open
4	23365	Fix import format at pandas/tests/extension di...	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
5	23364	Isort contributing guide	[{'id': 134699, 'node_id': 'MDU6TGFiZWwxMzQ2OT...	open
6	23363	COMPAT: update for latest flake8	[]	open
7	23362	PERF: concat perf	[{'id': 8935311, 'node_id': 'MDU6TGFiZWw4OTM1M...	open
8	23361	unpin openpyxl	[]	open
9	23359	PERF: Investigate caching on PeriodArray	[{'id': 8935311, 'node_id': 'MDU6TGFiZWw4OTM1M...	open
10	23358	CI: rebalance the travis ci jobs	[{'id': 48070600, 'node_id': 'MDU6TGFiZWw0ODA3...	open
11	23356	ENH: Tox as main entry point for development	[]	open
12	23355	DOC: fixup whatsnew note for GH21394	[]	open
13	23354	issue regarding fill missing value	[]	open
14	23353	BUG: Fix IntervalTree handling of NaN	[{'id': 76811, 'node_id': 'MDU6TGFiZWw3NjgxMQ=...	open
15	23352	BUG: IntervalTree should not have NaN in nodes	[{'id': 76811, 'node_id': 'MDU6TGFiZWw3NjgxMQ=...	open
16	23351	Fix import format pandas/tests/indexing	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
17	23349	API/TST: make hasnans always return python boo...	[{'id': 31404521, 'node_id': 'MDU6TGFiZWwzMTQw...	open
18	23348	Pandas should validate display.max_rows option	[{'id': 42670965, 'node_id': 'MDU6TGFiZWw0MjY3...	open
19	23347	Run Isort on tests/util single PR	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
20	23346	Run Isort on tests/arrays single PR	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
21	23345	BUG: Fix date_range overflow	[{'id': 76811, 'node_id': 'MDU6TGFiZWw3NjgxMQ=...	open
22	23344	Run Isort on tests/series single pr	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
23	23343	Run Isort on tests/indexes P4/Final	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
24	23342	Fix+Test Timedelta.__mul__(nan)	[{'id': 47223669, 'node_id': 'MDU6TGFiZWw0NzIy...	open
25	23340	Run Isort on tests/indexes part three	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
26	23339	Fix import format tests/indexes/multi Part Two	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
27	23338	DOC: Added MultiIndex Example for Series Min	[{'id': 134699, 'node_id': 'MDU6TGFiZWwxMzQ2OT...	open
28	23337	Fix import format tests/indexes/ "Part One"	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open
29	23336	Partialy fix issue #23334 - isort pandas/core/...	[{'id': 106935113, 'node_id': 'MDU6TGFiZWwxMDY...	open

#数据库交互