In this repo, I share some scripts and notebooks mainly related to finance but random too.

I've learned how to (i) set git and github in my computer, (ii) make commits, edit code; and (iii) also how to collaborate in a team developing project.

• Pulled down a couple of repos (Python related) from GitHub with Git Bush
• Set properly VSCode with Py plugins
• Set properly VS2019 with C++ build tools to run #PyPortfolioOpt
• Updated my readme log

My expected plan is following the next journey in learning Python:

• Pandas: Data loading and manipulation
• Numpy: Vector operations, mathematical, scientific functions
• Matplotlib + Seaborn + Plotly: Visualización y gráficas
• SciPy + Scikit-Learn: stats and classic ML algorithms
• Tensorflow: Machine learging
• Keras: Neurals Network

Out of topic. I coded a little program in C# that interacts with Ms Excel, using the reference "http://Microsoft.Office.Interop.Excel" It didn't run but It will.

I worked with a the Day3 file and I finally got to run the C# code. It was a simple application about registration of sales and vendors.

I started with the Python Journey. Following the suggestion of working in real-world problems, I started with a small app of webscrapping with #Requests and #BeautifulSoup. The main task was download 96 files from an academic website.

I needed to create a script to allow sending customized emails in terms of body and attachments in a matter of one click. To do so, I used the libraries: #Smtlib, #Pandas and #Email.mime.

I took the book "Foundations for Analytics with Python" (Brownley, 2016) as a guidance. Started with the "Python basics building blocks":

• Strings
• Regular expressions and pattern matching
• Dates
• Lists

Following with the "Python basics building blocks":

• Tuples
• Dictionaries
• Control flow

I worked with #DateTime libraries #Date and #Time. Worked with:

• Database with date column
• Attributes of a datetime object: year, month, day, weekday.
• Calculating differences between two dates.

I had troubles updating Spyder to 5.1.5 version with Conda. The suggested and conventional way to update lead to 8 hours of proccessing without any success. Finally, I found a suggested solution from a Spyder maintainer

conda remove spyder
conda remove python-language-server
conda update anaconda
conda install spyder=5.1.5

DateTime

my_datetime = datetime = (year, month, day, hour, minute, second, microsecond)
print(my_datetime)

2021-02-20 22:30:12.500000