Tagged Questions

1
vote
1answer
54 views

Pandas df.head() Error

I'm having a basic problem with df.head(). When the function is executed, it usually displays a nice HTML formatted table of the top 5 values, but now it only appears to slice the dataframe and ...
2
votes
1answer
80 views

Pandas: Setting no. of max rows

I have a problem viewing the following DataFrame n = 100 foo = DataFrame(index=range(n)) foo['floats'] = np.random.randn(n) foo the problem is that it does not print all rows per default in ...
0
votes
2answers
46 views

Delete first three rows of a dataframe in pandas

I need to delete first three rows of a dataframe in pandas. Got to know df.ix[:-1] would remove the last row of a data frame. Couldn't figure out how to remove first n rows.
0
votes
1answer
117 views

Make more than one chart in same IPython Notebook cell

I have started my IPython Notebook with ipython notebook --pylab inline This is my code in one cell df['korisnika'].plot() df['osiguranika'].plot() This is working fine, it will draw two lines, ...
0
votes
0answers
42 views

How do you get python Pandas to respect matplotlib arguments when running via IPython Notebook on a VM?

I have installed pandas and IPython Notebook, and am running on a Vagrant box. When plotting and attempting to create a stacked bar graph on a data frame, pandas ignores secondary arguments passed to ...
0
votes
1answer
66 views

CSV-like data in script to Pandas DataFrame

I've got a list of cities with associated lon,lat values that I'd like to turn into a DataFrame, but instead of reading from a CSV file, I want to have the user modify or add to these city,lat,lon ...
1
vote
1answer
118 views

How to force the short summary dataframe output in Ipython Notebook

I'm using IPython Notebook and would like to be able to control which type of output is returned from submitting a simple DataFrame name. For example: df = DataFrame({"A": [1,2,3], "B": [4,5,6]}) df ...
3
votes
1answer
133 views

IPython Notebook: What is the default encoding?

I have created a package using the encoding utf-8. When calling a function, it returns a DataFrame, with a column coded in utf-8. When using IPython at the command line, I don't have any problems ...
0
votes
0answers
95 views

Send output from iPython console to .csv file. (& viewing data issue)

Using the iPython console, I built a pandas dataframe called df. for (k1,k2), group in df.groupby(['II','time']): print k1,k2 print group df['II'] stores integers between: [-10,10]. ...
2
votes
1answer
73 views

How to do a data frame join with pandas?

Can somebody explain data frame joins with pandas to me based on this example? The first dataframe, let's call it A, looks like this: The second dataframe, B, looks like this: I want to create ...
4
votes
2answers
177 views

How to preview a part of a large pandas DataFrame?

I am just getting started with pandas in the IPython Notebook and encountering the following problem: When a DataFrame read from a CSV file is small, the IPython Notebook displays it in a nice table ...
2
votes
1answer
231 views

How to grab matplotlib plot as html in ipython notebook?

I have an IPython Notebook that is using Pandas to back-test a rule-based trading system. I have a function that accepts various scalars and functions as parameters and outputs a stats pack as some ...
2
votes
1answer
158 views

RMagic, IPython and Summary Information

Following the example here http://www.randalolson.com/2013/01/14/filling-in-pythons-gaps-in-statistics-packages-with-rmagic/ I tried the same on a different data set found here, in an IPython ...
2
votes
2answers
134 views

How do you make plotting two pandas Series in the same ipython notebook cell use different colors automatically?

When I run this in one cell, both plot lines are blue. I could have sworn I saw Wes do a demo of baby names with two plots where the two plot lines came out in different colors without having to ...
1
vote
2answers
139 views

Ipython Notebook not printing type() in dataframe

This is a pretty bizarre bug: The following code: a = 'string1' b = 'string2' test_dict = {'col1':{a:type(a), b:type(b)},'col2':{a:type(a), b:type(b)}} pd.DataFrame(test_dict) In a normal ipython ...