Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 45264

Comma-Separated Values are a list of plain text values delimited by commas, or a file containing one or more lists in that format.

10 votes

How to store strings in CSV with new line characters?

I assume that you want to keep the newlines in the strings for some reason after you have loaded the csv files from disk. Also that this is done again in Python. … I set index=False as you said you don't want row numbers to be in the CSV: FILE = '~/path/to/test_file.csv' df.to_csv(FILE, index=False) What does it look like on disk? …
n1k31t4's user avatar
  • 15.1k
1 vote

Processing csv file with more than 700K rows of data

I think the main time-consumer will be the fact that you are iterating over 700,000 rows, one-by-one. You could perhaps do a few of your checks/comparisons (used in the line with bit-wise stuff: &, | …
n1k31t4's user avatar
  • 15.1k
3 votes

How to save API data into CSV format?

There is no simple way to write this directly to a CSV file, because there are nested structures: e.g. under "result" there "fields" and then more values, and CSV files can't display that directly. … Once you have done that, you can do the following using Pandas to write the CSV file: import pandas as pd df = pd.read_json(r) df.to_csv("output.csv") …
n1k31t4's user avatar
  • 15.1k
1 vote

How do I get Multiple CSV files (csv file names will be column names) from a folder to a pan...

How do you get to the second picture from that code? I wil give you rough set of steps to follow along with the main function names. you can search through the pandas documentation for more details. …
n1k31t4's user avatar
  • 15.1k
2 votes
Accepted

Creating a single number from a numpy array - Python

Welcome to Data Science! You're question needs a little more detail... there are many many ways to make an array into a single number. You should say a little more about what you mean by meaningful. H …
n1k31t4's user avatar
  • 15.1k