[csv] Forum Topics

Hello there, submissiontime length finishtime remainingtime 1031 17:11 574.1025391 MB 1050 17:30 1 1326 22:06 536.0175781 MB 1343 22:23 2 2721 45:21:00 608.1279297 MB 2741 45:41:00 3 32 0:32 575.8115234 MB 51 0:51 4 1161 19:21 652.6259766 MB 1182 19:42 5 937 15:37 288.7597656 MB 946 15:46 6 3087 51:27:00 …

Hi everyone, I need to use python to read some data in my csv file, but the file I have contains 15 rows of introduction in front. all the data I need is from the row 16. I am able to read the data as the way I want it …

Hi all, [CODE]import java.io.*; import java.util.*; class MapDemo{ public static void main(String args[]){ Map<Integer, Object[]> tMap = new TreeMap<Integer, Object[]>(); Object[] values = new String[] {"Tree", "Map"}; tMap.put(1, values); System.out.println("Keys of tree map: " + tMap.keySet()); System.out.println("Values of tree map: " + Arrays.deepToString(tMap.values().toArray())); } }[/CODE] The above code works good …

Hi everybody. I have a simple problem. Need send the c++ output to excel(csv->xls or xls direct) in formated data. I can send the data to excel, but i can´t format that like this: |_ col 1__|___col 2___|___col n____| row 1......|....2row 1 row 2......|....2row 2 row 3......|... 2row n What …

Hi there, I'm using php to try and take two separate arrays ($colors and $message), write them to a single multidimensional array ($endline), and then write the resulting md array into a csv. This works fine on my localhost, but for some reason it doesn't work through my web host. …

Hi, I m trying to write code to merge two csv files. could any one help me out to get the hints to start?

I use the following code to read a CSV file with 6 columns. The headers are assigned correctly (i.e. print headers works) but when I try to read the rest of the rows as variables under those headers. The first column is 'time' and it is read correctly. But when …

Hi all, The project I am currently working on is an Address Book which works off a csv (specification takes the mick as a database would be so much easier), the method to write the lines of information into the CSV is in the class DataLayer and takes a String: …

I have a sort of csv file which looks likes given below i want to count number of digits in each line like number of 0's ,1 s in each line and print them this way for each line i want to print information in csv file . 0 0 …

Hi everyone, When I try the code below with data in a txt file, I have no problems and the data prints properly and neatly on the screen. (Note, one slight modification when using a txt file, instead of getline (ist, ignored, ','), I do getline (ist, ignored, '/t') to …

I have a C# WCF Ajax service with an OperationContract that accepts a string of text that is expected to be CSV. I have written most of a CSV parser for this, but I would like to possibly use OLEDB to parse this string. Is this possible? I would rather …

[B]Good Morning, I have a CSV file with thousands of rows of data, and I want to have this data uploaded into a table in a MySQL database. I also want an area where the file could be selected from the computer for the data to be uploaded. Could this …

Hi There, I have a datagrid table with 5 columns and as many rows as the user enters. Is there a simple way to export the contents of the table to a CSV file? The columns are named; a,b,c,d and e Im using VB 2005. Mant Thanks Alex

I've seen a lot of posts over time relating to importing and exporting CSV. Most of the answers involve using TextReader.readline and String.split, [B]which will not work[/B] with any but the simplest data. When you are writing for users who have the expectation that your application will work with anything …

Hi Friends, This is the code i wrote in order to First open a csv file as excel, then find the required three columns, n then read data from them n save the data into another variables showing them in textbox. As about the csv file, it contains many columns …

Hi everyone, I'm new here so I hope I've put this in the right place. I'm looking for a little help with a python program I've written. I'm trying to create a timeline from SQLite databases. I take information from a calls database, then an sms database, write those to …

hi, So heres the deal i am still learning VB (bet you guessed that), now what i am tryiing to do is create a form with a number of text boxes (say 25) where a user can enter their own data. Which they can then save as a file and …

Hello, I have data imported from a text file stored in an array. How do I go about writing it to a CSV file? Also, how do I set up different columns so that the CSV file opens up nicely in Excel. Thanks.

I am working in an older version of Python (2.6, I believe). I cannot update to the latest version because it is not currently compatible with the other program I need the code to run with so, unfortunately, the "decimal" module is not available to me (as far as I …

I am working with a CSV file with multiple rows, which I need to be able to access individual data elements from a row so I can assign them to variables and send them to the other program I am working with in a loop, going through each individual row. …

This is a continuation of problems with the program posted here: [URL="http://www.daniweb.com/software-development/python/threads/372311"]http://www.daniweb.com/software-development/python/threads/372311[/URL] I started thinking there was something wrong with my statement to open the csv file, using the reader. [CODE]reader = csv.reader(open('C:/Documents and Settings/VPC.VPC-SCALA.000/Desktop/RAH 7-11-11/RH/Projected Cash Goals Template.csv', 'rb')) [/CODE] I put a test statement above the open statement …

Hello, I have this code [CODE]#!/usr/bin/env python import csv import random alpha = 'abcdefghijklmnopqrstuvwxyz' e = range(0,99) x = random.sample(alpha,14) c = csv.writer(open("test2.csv", "wb")) c.writerow([x]) cr = csv.reader(open("test2.csv","rb")) for row in cr: print ', '.join(row) print "How many rows?" l = input() k = 1 while k < int(l): y …

Hi, I'm trying to parse a csv fiel using a code i've found on line: [CODE] private DataTable ParseCSV(string path) { if (!File.Exists(path)) return null; string full = Path.GetFullPath(path); string file = Path.GetFileName(full); string dir = Path.GetDirectoryName(full); //create the "database" connection string string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=\"" + …

How do you write a python code that looks at a specific cell in a csv file? I have the following data in a csv file 1 0 100 2 11 150 3 0 189 4 0 195 5 21 245 I need to write a program in python that …

Greetings I'm running in circes trying to accomplish something very simple. I have a csv file with multiple lines resembling: 0002345, 24, 5, 0.24 I need this format in my output file: '0002345', 24, 5 0.24 The first entry is a census meshblock code and the leading zeros are relevant …

I'm a beginner in programming, and I'm doing a project that requires continously getting an input from the Serial Port. I already used the SerialPort class to retrieve the data and use it in my programm, and now I want to write those same SerialPort values (splitted into array[0]....array[7]) into …

Currently I am making code to be used to make my playing of an online conquest video game easier. The first program the user would run is the initialize program. This is how the program looks: [CODE] #initialize import csv x=1 y=1 n=0 citiesx=[] citiesy=[] city_names=[] total=input("How many cities do …

Hi, I am attempting to read in a CSV file, modify certain arrays and output it into a new file. It works fine on a mac, however on Windows it does not do anything. Any ideas what im doing wrong? Code posted below; [CODE] open(FILE,"file.csv") or die $!; open(TARGET,"> newfile.csv") …

Hello! I am working with an Access Database (Access 2002) that contains a form that is supposed to import a CSV. However, because some of the integers contained in the CSV are too large for Access to handle (regardless of the number format I select for the field), I'm going …

Iam having trouble writing my results to a CSV file.The results i have are as follows -0.025 0.15 0.15 0.4 0.5 -0.05 0.1333333 0.2 0.4 0.5 -0.05 0.1333333 0.2 0.4 0.5 -0.05 0.1333333 0.2 0.4 0.5 -0.05 0.1333333 0.2 0.4 0.5 When i am writing them to the file it …