Python Codefrom mtranslate import translateimport pandasimport numpy as npdf = pandas.read_excel('english.xlsx')df['Port...

In [1]: import pandas as pdIn [2]: import numpy as npIn [3]: df = pd.DataFrame([[1, 2], [3, 4]], columns=['A', 'B'], ind...

Similar to an observation on reddit I noticed that there is a huge performance difference between the default pandas pd....

Code Sample, a copy-pastable example if possiblepd.read_sql( ''' SELECT CountryCode, ShortName,Lat...

Code Sample, a copy-pastable example if possible# Imports:import numpy as npimport pandas as pdimport matplotlib.pyplot ...

Sample codeimport pandas as pdfrom pandas.api.types import CategoricalDtypeimport numpy as np# Load datadf = pd.read_exc...

Code Sample, a copy-pastable example if possiblea=pd.DataFrame(data=list(range(10)))def test(x): x["date"]=...

Code Sample, a copy-pastable example if possibleimport pandas as pdfrom datetime import datetimedates = [pd.Timestamp('2...

I want read 3w row and 87000 columns, use pandas read_csv cost 7h,but use R fread cost 9min. so, how can t use pandas or...

df.rx('regex') short-hand for df.filter(regex='regex') would allow to easily pipe multiple regex statements. For example...

Code Sample, a copy-pastable example if possible# Your code heredf = pandas.DataFrame({'a': [1, 10, 8, 11, -1], ...

I have two csv file below: test1.csvCOL1,COL210124420001034504343,110124420001095178632,210124420000004627498,3test2.c...

Hi - I recently upgraded to pandas version 0.21.0 from version 0.20.3 and got the following error writing a dataframe to...

I am trying to create a pandas DataFrame from a bunch of numpy ndarray without copying anything. The overall objective i...

Code Sample, a copy-pastable example if possibleimport pandas as pdimport numpy as npfill_value = 0 #fill_value = np.nan...

after resample the data types change to float64, is it possible to keep the input type, uint and uint64 in this example?...

Code Sample, a copy-pastable example if possibles = pd.Series(np.random.randint(0, 10, 1000, dtype=np.int64))df = pd.cro...

I've searched for issues, but haven't found a similar one - apologies if there are.Current behaviour:import pandas as pd...

This doesn't work:a = pd.DataFrame(data=np.random.rand(3))time = pd.date_range('2000-01-01', tz='UTC', periods=3, freq='...

Code Sample, a copy-pastable example if possible>>> a_list = ['string'] * 1000000>>> arr = np.array(a_...