error in dividing 2 pandas series with decimal values (daily stock price)
I am trying to divide 2 pandas columns (same column divided by shifting one cell) but getting an error as below...
..This is surprising as I have done such computation many times before on time series data and never encountered this issue.
Can someone suggest what is going on here?...I am computing the daily returns of Adj Close price of a stock so need the answer in decimal.
Solution
I think you need convert to float first column, because dtype is object, what is obviously string:
z = x.astype(float) / y.astype(float)
Or:
data['Adj Close'] = data['Adj Close'].astype(float)
z = data['Adj Close'].shift(-1) / data['Adj Close']
- How to select rows that display some type of pattern in Python
- I want to connect to an api and extract the data
- How to shift dates in a pandas dataframe (add x months)?
- How to hide or remove all headers from a pandas DataFrame
- Delete a column from a Pandas DataFrame
- How can I find the column containing the third NaN value in each row of a DataFrame in pandas?
- pandas dataframe filter to return True for ALL rows. how?
- select dataframe column and replace values by indices if True
- Appending column values from one dataframe to another as a list
- Calculate the volume of 3d plot python
- Pandas Dataframe: Creating a new column and filling it with values according to 2 conditional statements on other columns
- How to normalize json correctly by Pandas
- Json List to Pandas Dataframe
- Count number of characters in each row and drop if all are below a certain number
- How to chain operations in pandas entirely in-line?
- In a pandas dataframe with a MultiIndex, how to conditionally fill missing values with group means?
- Filtering DataFrame by list of substrings
- Select rows if a condition is met in any two columns
- How to find if all the columns in a dataframe are object dtype?
- Grouping on Multiple Columns then finding unique rows based on max
- Create a dataframe from another dataframe and a list of formulas in Pandas Dataframe
- How should I parse times in the Japanese "30-hour" format for data analysis?
- Convert to float, pandas string column with mixed thousand and decimal separators
- How to calculate daily weights which satisfy certain conditions
- How can I convert each Pandas Data Frame row into an object including the column values as the attributes?
- Calculate percentage of flag grouped by another column
- TypeError: Cannot convert numpy.ndarray to numpy.ndarray
- Discord.gateway warning "Shard ID None heartbeat blocked for more than 10 seconds." while using pandas
- Release hdf5 disk memory after table or node removal with pytables or pandas
- HDF5 file grows in size after overwriting the pandas dataframe