Challenge: Earnings Forecaster
Forecasting your freelance earnings is an essential practice for financial planning and maintaining business stability. By leveraging Python, you can automate this process and quickly identify potential shortfalls before they become issues. In this chapter, you will build a script that takes hardcoded data for your past monthly earnings and upcoming project payments, calculates projected totals for each month in the next quarter, and displays a summary table. You will also highlight any months where projected earnings fall below a threshold you set, helping you proactively address lean periods.
Swipe to start coding
Complete the script to forecast your freelance earnings for the next quarter using the provided hardcoded data.
- Calculate the total projected earnings for each upcoming month based on the values in
upcoming_projects; - Create a pandas DataFrame named
dfwith columnsMonthandProjected Earnings; - Add a column
Below Thresholdto flag months where projected earnings are less than the value ofthreshold; - Print the DataFrame as a string with no index using
print(df.to_string(index=False)).
Рішення
Дякуємо за ваш відгук!
single
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
Can you show me how to structure the hardcoded data for past earnings and upcoming payments?
How do I set the earnings threshold in the script?
Can you explain how to highlight months with low projected earnings?
Чудово!
Completion показник покращився до 5Challenge: Earnings Forecaster
Свайпніть щоб показати меню
Forecasting your freelance earnings is an essential practice for financial planning and maintaining business stability. By leveraging Python, you can automate this process and quickly identify potential shortfalls before they become issues. In this chapter, you will build a script that takes hardcoded data for your past monthly earnings and upcoming project payments, calculates projected totals for each month in the next quarter, and displays a summary table. You will also highlight any months where projected earnings fall below a threshold you set, helping you proactively address lean periods.
Swipe to start coding
Complete the script to forecast your freelance earnings for the next quarter using the provided hardcoded data.
- Calculate the total projected earnings for each upcoming month based on the values in
upcoming_projects; - Create a pandas DataFrame named
dfwith columnsMonthandProjected Earnings; - Add a column
Below Thresholdto flag months where projected earnings are less than the value ofthreshold; - Print the DataFrame as a string with no index using
print(df.to_string(index=False)).
Рішення
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
single
