Vytautas Bielinskas vb100
🎯
vb100
/ automation_data_structuring_writing.py
Last active
July 2, 2018 13:53
This Python code read CSV file and automatically recongizes real estate properties, finds specific cells at Excel file where specific values should be written, make all Excel formating and building all neccesary formulas only by one click! Half day work done just in half a minute.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # -*- coding: utf-8 -*- | |
| """ Project Jupyter - extract data from PDF by Vytautas""" | |
| """ Importing libraries """ | |
| import pandas as pd | |
| import os | |
| """ Reading Dataset file """ | |
| os.chdir("C:\\Users\\Vytautas.Bielinskas\\Desktop\\Python\\") | |
| DF = pd.read_csv("tabula-Statement (BULK) 02 July.csv", header=None) |
vb100
/ automation_selenium_data_gathering_writing.py
Last active
July 2, 2018 13:57
This Python code gathering numerical data from Stat. data website by Selenium, parse tables, structuring data and write all the values directly to Excel file including cell formating (OpenXlsX library).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Import libraries | |
| import requests, re, os | |
| import pandas as pd | |
| from bs4 import BeautifulSoup | |
| import os | |
| print("Starting sheet: Inflation rates") | |
| """ Prepare Home directory : start """ | |
| os.chdir("C:\\Users\\Vytautas.Bielinskas\\Desktop\\PythonWorking\\Python\\") |
OlderNewer