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']
- Missing optional dependency 'tables'. In pandas to_hdf
- Plotting cumulative distribution from data
- How to calculate the quantity of business days between two dates using Pandas
- How to fix AttributeError: 'Series' object has no attribute 'append'
- Linear interpolation lookup of a dataframe
- Good alternative to Pandas .append() method, now that it has been deprecated?
- Add column to dataframe with constant value
- Plotly: bar plot with color red<0, green>0, divided by groups
- Replace NaN with the average of the last 5 values - Pandas
- Boxplot showes incorrect picture
- Python Dataframe Extract Colum Data Based cell value
- python pandas remove text in column names after specific characters
- Pandas - match column from two df and return value from another columnl
- Set column width in pandas dataframe
- Update column depending if other column value is in list
- Why is tz-naive Timestamp converted to integer while tz-aware is kept as Timestamp?
- Get a single series of classes instead of one series for each class with pandas in Python
- Randomly shard large CSV into smaller CSVs
- How can plot categorical stacked bar over periodic time?
- How to import values from excel with pandas into tkinter faster?
- Speed up concatenation of excel files with Pandas
- Faster way to read Excel files to pandas dataframe
- Get the value of a column by max value in others
- How does Pandas.Series.nbytes work for strings? Results don't seem to match expectations
- Value based partial slicing with non-existing keys is now deprecated
- Get number of decimals in python float, including trailing zeros
- Mark True from conditions satisfy on two consecutive values till another two consecutive values
- How do I replace set_value with at[] in a pandas Series
- Groupby if at least one element is in common
- Yfinance returning NaN for first ticker in list