Line magic function `%%time` not found

python dataframe magic-function magicline
Chandrachud Pati picture Chandrachud Pati · Dec 3, 2020 · Viewed 14.6k times · Source

%%time

train_data = dt.fread('../input/prediction/train.csv').to_pandas()

The output results as an error and says UsageError: Line magic function %%time not found. Suggest some approach.

Answer

Simon Judd picture Simon Judd · Dec 9, 2020

%%time is a 'cell magic' and has to be the first thing in the IPython (Jupyter) cell. I can reproduce this error if for example I have a comment first. When %%time is not the first thing in the cell, IPython tries to interpret it as a 'line magic' hence the error you see.

I took a quick look in the documentation and it's not made explicitly clear there as far as I can see.

Related questions

How to select rows from a DataFrame based on column values

How can I select rows from a DataFrame based on values in some column in Pandas? In SQL, I would use: SELECT * FROM table WHERE colume_name = some_value I tried to look at Pandas' documentation, but I did not …

Read More
Renaming columns in pandas

I have a DataFrame using pandas and column labels that I need to edit to replace the original column labels. I'd like to change the column names in a DataFrame A where the original column names are: ['$a', '$…

Read More
How to iterate over rows in a DataFrame in Pandas

I have a DataFrame from Pandas: import pandas as pd inp = [{'c1':10, 'c2':100}, {'c1':11,'c2':110}, {'c1':12,'c2':120}] df = pd.DataFrame(inp) print df Output: c1 c2 0 10 100 1 11 110 2 12 120 Now I want to iterate over the rows …

Read More