Here is one approach. I created new lat for text annotation using transform in base R. I used geom_text to add the labels you wanted. I used scale_colour_discrete to change the name of the legend. library(ggmap) library(ggplot2) ### Get a map map <- get_map(location=c(lon=34.832, lat=0.852), color=”color”, source=”google”, maptype=”terrain”, zoom=9) ### Create new lat for annotation … Read more
A very easy way, is to create a vbs script. Paste the below into a notepad and save as XlsToCsv.vbs. Make sure you give the full path of sourcexlsFile and also destinationcsvfile To use: XlsToCsv.vbs [sourcexlsFile].xls [destinationcsvfile].csv if WScript.Arguments.Count < 2 Then WScript.Echo “Error! Please specify the source path and the destination. Usage: XlsToCsv SourcePath.xls … Read more
You are looking for nested dictionaries. Implement the perl’s autovivification feature in Python (the detailed description is given here). Here is a MWE. #!/usr/bin/env python # -*- coding: utf-8 -*- import csv class AutoVivification(dict): “””Implementation of perl’s autovivification feature.””” def __getitem__(self, item): try: return dict.__getitem__(self, item) except KeyError: value = self[item] = type(self)() return value … Read more
The first step (reading in the csv) is pretty simple: data = read.table(“filename.csv”, sep = “,”, quote = “”, header=TRUE) The ‘sep’ part makes it clear that the separator is a comma, and ‘header’ keeps those column headings separate from the rest of the data. Does that work for you? -Y solved Using R – … Read more
Your update2new function definitely returns something: def update2new(src_dest): print(“Hi”) fileProcess(src_dest) os.remove(‘outfile.csv’) os.remove(‘new.csv’) return src_dest But you don’t capture it in your main: def main(): print(“<——Initializing Updating Process——>”) srcFile=”abc_20160301_(file1).csv” update2new(srcFile) #the return is NOT captured here print(‘\nSuccessfully Executed [ {}]……’.format(str(srcFile)),end=’\n’) print (“OK”) Change it to: def main(): print(“<——Initializing Updating Process——>”) srcFile=”abc_20160301_(file1).csv” srcFile = update2new(srcFile) #get the … Read more
Consider this as an example, first off, of course you need a form: Sample Form: <!– HTML –> <form method=”POST” action=”processes_the_form.php”> Sr No.: <input type=”text” name=”srno” /><br/> Name: <input type=”text” name=”name” /><br/> Invt.: <input type=”text” name=”invt” /><br/> <input type=”submit” name=”submit” value=”Add to CSV” /> </form> Then process it in PHP: <?php // set delimitter (tab … Read more
From a performance point of view you probably want to avoid Import-Csv/Export-Csv and go with a StreamReader/StreamWriter approach. Something like this: $inputFolder=”C:\some\folder” $outputFile=”C:\path\to\output.csv” $writer = New-Object IO.StreamWriter ($outputFile, $false) Get-ChildItem $inputFolder -File | Where-Object { … # <– filtering criteria for selecting input files go here } | ForEach-Object { $reader = New-Object IO.StreamReader ($_.FullName) … Read more
A 48mb json file is pretty small. You should be able to load the data into memory using something like this import json with open(‘data.json’) as data_file: data = json.load(data_file) Dependending on how you wrote to the json file, data may be a list, which contains many dictionaries. Try running: type(data) If the type is … Read more
the way your code is structured, you iterate over the matches in your for loop, then, when the loop is finished, you save the last match in your CSV. You probably want to write each match in your CSV instead, inside the for loop. try to replace the last lines of your code (starting at … Read more
I want to compare my input csv file, with standard (template) csv file. such that, column headers also should be compared along with the data solved I want to compare my input csv file, with standard (template) csv file. such that, column headers also should be compared along with the data
matches = [] File.readlines(‘data.txt’).each do |line| my_line = line.chomp.split(‘, ‘).map! { |l| l.split(/\s+(?=\d+$)/) }.flatten matches << [[‘player1’, ‘scope_p1’, ‘player2’, ‘score_p2’], my_line].transpose.to_h end p matches Example Here 3 solved Ruby CSV.readline convert to hash
You would probably need to use a regular expression to find lines that contain the values you want and to extract them. These lines can then be written in CSV format using Python’s CSV library as follows: import re import csv with open(‘log.txt’) as f_input, open(‘output.csv’, ‘w’, newline=””) as f_output: csv_output = csv.writer(f_output) csv_output.writerow([‘Iteration’, ‘loss’]) … Read more
Try and see! Here is a request for imagery of the O2 Arena on the river in London for an image from January 2017: curl “https://api.nasa.gov/planetary/earth/imagery/?lon=0&lat=51.5&date=2017-01-01&cloud_score=True&api_key=DEMO_KEY” Here is the result: { “cloud_score”: 0.047324414226919846, “date”: “2017-01-17T10:52:32”, “id”: “LC8_L1T_TOA/LC82010242017017LGN00”, “resource”: { “dataset”: “LC8_L1T_TOA”, “planet”: “earth” }, “service_version”: “v1”, “url”: “https://earthengine.googleapis.com/api/thumb?thumbid=a286185b3fda28fa900a3ce43b3aad8c&token=206c7f1b6d4f847d0d16646461013150” If you paste the URL at the … Read more
Please never use reserved words like list, type, id… as variables because masking built-in functions. If later in code use list e.g. list = data[‘FirstNames’].tolist() #another solution for converting to list list1 = list(data[‘SecondNames’]) get very weird errors and debug is very complicated. So need: L = data[‘FirstNames’].tolist() Or: L = list(data[‘FirstNames’]) Also can check … Read more
You can create a function to do this task as below: String GetAddress(String searchName) { var strLines=File.ReadLines(“filepath.csv”); foreach(var line in strLines) { if(line.Split(‘,’)[1].Equals(searchName)) return line.Split(‘,’)[2]; } return “”; } you can call the above function as below: String peterAddress=GetAddress(“Peter”); EDIT: String address=””; Dictionary<String, String> dict_Name_Address = new Dictionary<string, string>(); var lines=File.ReadLines(“FileName.csv”); foreach (var line in … Read more