unable to open csv file from mail app ios11

I have an app that exports a backup csv file via email which I can then use to import back into the app via "copy to". Up to iOS11 it was all working fine. Now with iOS11 in the mail app I get the name of the file and "comma-seperated values" when I ...
more »

2017-10-04 22:10 (0) Answers

How to remove two commas of a csv file using c

My csv file looks something like this: Alice,Girl,19,Beauty Alec,,30,cool Now as shown in the above sample there are two commas in the second entry. Right now I am using the following instruction in c to read the csv and store it in the da...
more »

2017-10-03 21:10 (1) Answers

Python CSV Finding average time taken

I am trying to find the average time taken. The value 'x' will allow me to get the time taken for every row there is, but how am I able to find the average time taken for all the rows. I will think it is something like x divided by count, but I am no...
more »

2017-10-03 05:10 (0) Answers

Using Pandas to Extract From a .csv File

I am attempting to answer the following question given a csv file with columns corresponding to final exam score and gender (among others). I understand how to solve using a for loop, but not pandas. "Find the mean Final exam score for all females i...
more »

2017-09-26 00:09 (2) Answers

Needed email addresses from list of display names

I'm trying to search AD through PowerShell to get email addresses based on display names. The display name is the only thing I have to reference. The CSV column header is DisplayName "John,Doe" Here is the script that I am running: $arrayDispl...
more »

2017-09-24 21:09 (1) Answers

Dates converted from csv to R and SPSS

I am having some very peculiar outcomes when converting data from csv to R as oppose to SPSS: I have a database with 33 columns and 4889 rows. In the csv form, most columns include likert-ratings but one include date of death in the format dd/mm/yyy...
more »

2017-09-24 12:09 (0) Answers

Reading a part of csv file

I have a really large csv file about 10GB. When ever I try to read in into iPython notebook using data = pd.read_csv("data.csv") my laptop gets stuck. Is it possible to just read like 10,000 rows or 500 MB of a csv file. ...
more »

2017-09-22 03:09 (2) Answers

Adding CSV File directly into cache folder

Currently in my program ,I have placed csv file in separate folder and then after reading it m serializing and storing it in separate cache folder(during app start up).And when API is called m deserializing it and giving it to frontEnd.My question is...
more »

2017-09-21 18:09 (0) Answers

pandas creating a dataframe from mysql database

So I have been trying to create a dataframe from a mysql database using pandas and python but I have encountered an issue which I need help on. The issue is when writing the dataframe to excel, it only writes the last row ie, it overwrites all the p...
more »

2017-09-21 16:09 (1) Answers

Splitting a csv into multiple csv files by column

Trying to learn Python and managed to create a script that takes a csv, turns it into a data frame, changes the columns and then outputs a csv to the desired style. Well what I need to do now is to be able to output multiple csvs based on the conten...
more »

2017-09-19 21:09 (4) Answers

Alternately mix DATA in MS EXCEL

I have one csv file which contains 10.000 rows. The 2.000 rows have the value "EXPL_1". The 3.000 rows have the value "EXPL_2". The 2.500 rows have the value "EXPL_3". The 1.500 rows have the value "EXPL_4". The 2.000 rows have the value "EXPL_5". I...
more »

2017-09-18 13:09 (4) Answers

csv wont download with url

I want to automatically download a csv in c# with a url. When I run the code I get the error message The remote server returned an error: (401) Unauthorized. Dispite this, I can download the csv by going to the website and manually clicking t...
more »

2017-09-18 02:09 (1) Answers

Export CSV File - JAX RS - REST - AJAX

I create a function to download a CSV File. I will use that to download simple reports. I got the error below on Netbeans using Wildfly and JAX RS RESTEASY002005: Failed executing POST /reports/downloadCSV/: org.jboss.resteasy.core.NoMessageBodyW...
more »

2017-09-14 18:09 (2) Answers

make ndarray containg string and int

How to make ndarray by reading from a csv file like 12,employed,32,happy,1 21,unemployed,31,poor,0 34,rich,45,unhapppy,0 NOTE: file can be very large output array: [[12,"employed",32,"happy",1] [21,"unemployed",31,"poor",0] [34,"rich",45,"unha...
more »

2017-09-12 07:09 (2) Answers

Pandas pd.read_csv - has anything changed?

I have a piece of code I wrote with Jupyter ~1 year ago which successfully used dg = pd.read_csv(f10,sep=';') to read this data A;W 83;88,0 64;70,1 94;94,2 Today I get: OSError: Initializing from file failed and somewhere inbetween: C:\A...
more »

2017-09-11 23:09 (2) Answers