csv

[Solved] One variable returns two seperate array

by

Since the two request aren’t linked in any way and are asynchronous, you have to group the data manually once both files have been read. I usually use util.promisify() to turn fs.readFile() from accepting a callback into it returning a promise, so I can use Promise.all() to create the array once both files have been … Read more

[Solved] Connecting data in python to spreadsheets

by

Are you trying to write your dictionary in a Excel Spreadsheet? In this case, you could use win32com library: import win32com.client xlApp = win32com.client.DispatchEx(‘Excel.Application’) xlApp.Visible = 0 xlBook = xlApp.Workbooks.Open(my_filename) sht = xlBook.Worksheets(my_sheet) row = 1 for element in dict.keys(): sht.Cells(row, 1).Value = element sht.Cells(row, 2).Value = dict[element] row += 1 xlBook.Save() xlBook.Close() Note that … Read more

[Solved] Search column name in csv file using c# [closed]

by

This should work public bool CheckFile() { StreamReader sr = new StreamReader(File.Open(@”YourFilePath”, FileMode.Open)); string toCheck; using (sr) { toCheck = sr.ReadToEnd(); } return toCheck.Contains(“fileName”); } solved Search column name in csv file using c# [closed]

[Solved] Bash script to download data from url

by

You have two bits here. One is to schedule a cron job and the other is to get the file & save it. Steps : Open the terminal & run crontab -e minute(0-59) hour(0-23) day(1-31) month(1-12) weekday(0-6) command In place of minute, hour, day, month & weekday. Also provide the command to run. The command … Read more

[Solved] Find password by username

by

I am supposing your csv will be like this: user1, hash_pass_u1 user2, hash_pass_u2 user3, hash_pass_u3 … Just one note before the solution. You are importing the CSV module of Python and you did not use it in your code, such a silly import, just use it. The solution is simple import csv file=”yourcsv.csv” found = … Read more

[Solved] Convert an int** array into a char** array of a different size / composition [closed]

by

I think that you needed string, not 2D-Array. You can be written out to a string like write to the standard output by implementing a string that a simple extension. #include <stdio.h> #include <stdlib.h> #include <string.h> typedef struct char_vec { char *v; size_t capacity; size_t used; } sstream; sstream *ss_new(void); void ss_free(sstream *ss); void ss_putc(sstream … Read more

[Solved] Calculate the mean of one column from several CSV files

by

You do not need more functions. The solution can be simpler from my understanding in 6 lines: pollutantmean <- function(directory, pollutant, id = 1:10) { filenames <- sprintf(“%03d.csv”, id) filenames <- paste(directory, filenames, sep=”https://stackoverflow.com/”) ldf <- lapply(filenames, read.csv) df=ldply(ldf) # df is your list of data.frames mean(df[, pollutant], na.rm = TRUE) } 2 solved Calculate … Read more

[Solved] How can i read a csv based on data in other columns? [closed]

by

Using the built-in csv library to iterate over each row’s values will do the trick: import csv with open(‘data.csv’) as csvfile: csvin = csv.DictReader(csvfile) for row in csvin: if row[‘col2:’] == “true” and row[‘col3:’] == “false”: print(row[‘col1:’]) Output result: 1 0 solved How can i read a csv based on data in other columns? [closed]

[Solved] Parse existing CSV file and strip certain columns

by

If you want the columns removed completely: $CSV = Import-Csv $Path | Select-Object -Property User1, Name, Gender $CSV | Export-Csv $NewPath -NoTypeInformation Or this, if it’s easier: $CSV = Import-Csv $Path | Select-Object -Property * -ExcludeProperty Age, Location, HairColor $CSV | Export-Csv $NewPath -NoTypeInformation If you want the columns to remain but be empty: $CSV … Read more