Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
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
// |
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
''' | |
Author: Akshaya Niraula | |
Created: 2022-08-29 | |
Copyright: Copyright (c) 2021 Akshaya Niraula. See MIT LICENSE for details | |
''' | |
''' | |
NOTE: | |
This code MUST be executed from Tulip interface. | |
It cannot run on it's own |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
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
Public Function ToJSON(rng As Range) As String | |
Dim checkType ' https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/vartype-function | |
Dim valuePart ' value part of the json | |
' Make sure there are two columns in the range | |
If rng.Columns.count < 2 Then | |
ToJSON = CVErr(xlErrNA) | |
Exit Function | |
End If |
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 glob | |
import pandas as pd | |
csv_dir = r"C:\Path\Where\CSV\Files\Area" | |
csv_files = glob.glob(f"{csv_dir}\*.csv") | |
# combined_csv = pd.concat([pd.read_csv(f) for f in csv_files]) | |
csv_dfs = [] | |
counter = 1 |
NewerOlder