def PandasCSVWrite():
df = pandas.readCSV('tgs.csv',
index_col='NPM',
parse_dates=['Tanggal Lahir'],
header=0,
names=['NPM', 'Nama', 'Kelas', 'Tanggal Lahir'])
df.to_csv('tgs5.csv')
and region = 'US' ''') #(select max(trovo_asof) from [Pricing_BankLoans].[Main].[DailyInputTable])
print("SQL Done")
newDaily = open(glob(r'\\xsqnfs2.nyc.ime.reuters.com\TRPS\Bank Loans\Auto 2.0\Algo\Input\D*.csv')[0], 'w', newline='')
writeDaily = csv.writer(newDaily)
header = ['Concatenated', 'unchanged_for', 'days_stale'] #defining header for daily file
writeDaily.writerow(header)
for row in SQLNavigator:
writeDaily.writerow(row)
newDaily.close()
hierarchyFile = readCSV(glob(r'\\xsqnfs2.nyc.ime.reuters.com\TRPS\Bank Loans\Auto 2.0\Algo\Input\B*.csv')[0]) #dealer hierarchy
trovoFiles = glob(r'\\xsqnfs2.nyc.ime.reuters.com\TRPS\Bank Loans\Auto 2.0\Trovo\mw-set*.csv')
trovoFiles.sort(key=path.getmtime, reverse = True)
trovoFile = readCSV(trovoFiles[0]) #most recent trovo file
dailyFile = readCSV(glob(r'\\xsqnfs2.nyc.ime.reuters.com\TRPS\Bank Loans\Auto 2.0\Algo\Input\D*.csv')[0]) #yesterday's dailyInputFile
print("merge started")
cleanFile = merge(trovoFile, dailyFile) #file after merging data and killing stale quotes
print("select started")
cleanFile = select(cleanFile, hierarchyFile) #file after selections are made
def bukaModeListPandas():
df = pandas.readCSV('tgs.csv')
print(df)
def ubahNamaKolom():
df = pandas.readCSV('tugas.csv')
df.columns = ['Col_1', 'Col_2', 'Col_3', 'Col_4']
print(df)
def ClmIdxChng():
df = pandas.readCSV('tugas.csv')
df.index = ['Row_1', 'Row_2']
print(df)
def ubahFormatTanggal():
df = pandas.readCSV('tgs.csv', parse_dates=['tanggal lahir'])
print(df)
import pandas as pd
df = pd.readCSV('buddymove_holidayiq.csv')
print(df.head())