SANDYA VB-Business Report TSF 2023& study guide with complete solution (Solved)

1. Read the data as an appropriate Time Series data and plot the data. The two datasets: Rose and Sparkling are imported using the read command. And convert to time series data using date_range function: date = _range(start='01/01/1980', end='08/01/1995', freq='M')date df['Time_Stamp'] = pd.DataFrame(date,columns=['Month']) () o/p: ROSE WINE YEAR WISE SALES • From the above plot we observe that there is a decreasing trend in the initial years and stabilizes over the years. • We also see that the seasonality in the data trend and pattern seems to repeat. SPARKLING WINE YEAR WISE SALES • We observe that there is no much trend in the above plot. • The seasonality seems to have a pattern on yearly basis. 2. Perform appropriate Exploratory Data Analysis to understand the data and also perform decomposition. ROSE WINE EDA • The shape of the data is (187,1). • There are 2 null values present in the data, which was interpolated using linear method. • Describing the data: Measures count mean std min 25% 50% 75% max Rose 185 90.3 39. 267 SPARKLING WINE EDA • The shape of the data is (187,1). • There are no null values present. • Describing the data: M