Questions tagged [data-files]
209 questions
1
vote
1 answer
How to import a list of blob files into SQL Server using bcp
I have a table in SQL Server with 3 columns:
id (int), Name (varchar), Column_Vb (Varbinary)
I want to import data into this table from a data file using BCP. The Id and Name columns contain the id and names, but the data in the Column_Vb (data…
Emilee
- 11
- 2
1
vote
1 answer
How Do I Use a Generator on a Data File to Convert JSON and TSV Rows Into a Dataframe?
I have a ".data" file containing these two sample rows below. The first row denotes json and the second row denotes tsv. I would like to convert the json to a python dictionary and the tsv lines into a python dictionary and then output both into a…
user14237286
- 109
- 10
1
vote
0 answers
how to insert the ID of a specific record usinf XML data file in odoo 13
I am trying to create data file using XML, so I can load predefined configuration during the instalation of my module. However, I couldn't insert the ID of the default company (company_id) which exists in res.company model ( I tried both eval, and…
Chems B
- 11
- 1
1
vote
1 answer
Parameterized fixture with pytest-datafiles
I have a Python function that processes different types of files for which I want set up a testing scheme. For each of the different file types it can handle I have a test file. I'd like to use pytest-datafiles so the tests automatically get…
MaartenB
- 383
- 1
- 2
- 12
1
vote
4 answers
finding max and min from a line of integers in a data file
I am trying to find the max and min of a line of text from a data file. Though there is plenty of lines of text in this data file.
DATA
-99 1 2 3 4 5 6 7 8 9 10 12345
10 9 8 7 6 5 4 3 2 1 -99
10 20 30 40 50 -11818 40 30 20 10
32767
255 255
9 10 -88…
Razmon
- 61
- 6
1
vote
1 answer
How to generate a three column data file in gnuplot
its my first question in this community. I am running the following short script in gnuplot (5.2),
set table "testable.txt"
plot '+' using 1:($1**2):($1**3)
unset table
The resulting data file contains only two columns; first a series of numbers…
Noman Ahmad Khan
- 13
- 2
1
vote
3 answers
Compare columns in Pandas between two unequal size Dataframes for condition check
I have two pandas DF. Of unequal sizes. For example :
Df1
id value
a 2
b 3
c 22
d 5
Df2
id value
c 22
a 2
No I want to extract from DF1 those rows which has the same id as in DF2. Now my first approach is…
Ayan Mitra
- 497
- 1
- 8
- 20
1
vote
1 answer
How to plot NetCDF Files with GnuPlot?
Hey guys I was wondering if it is possible to plot NetCDF files using Gnuplot. I was trying to use PyFerret on the command line, but I was unable to figure it out.
Using PyFerret I was able to determine that the NetCDF file has the following…
RSM
- 227
- 2
- 11
1
vote
1 answer
How to set environment variable using a data file in Postman
I have a data file having a column userid, now i want to set a environment variable based on the value of userid using pre-request script.
var i = data.userId;
console.log(i);
if(i==='1')
{
pm.environment.set("id","i");
…
Sudi
- 13
- 4
1
vote
0 answers
Popcorn Java Program Exception
Develop a top-down design and write a program to produce a bar chart of gourmet-popcorn production for a cooperative farm group on a farm-by-farm basis.
The input to the program is a series of data sets, one per line, with each set representing the…
Tristan Remus
- 34
- 1
- 8
1
vote
1 answer
Build queries from Jekyll csv data file
So I have a csv file with rows of data called "opportunities.csv"
This file is in the _data folder of my Jekyll site
client,opp,person,status
Oracle,"New thing five","Mary Smith",lead
Oracle,"Data plan","Sue Curry",lead
Oracle,"Migration 2019","Sue…
Dug Falby
- 53
- 5
1
vote
1 answer
Data files did not show the actual output
I have two .dat files. They are world.dat and sensor_data.dat. I have a folder name in D: drive named tutorial. Within this tutorial file, there are two folders data and code. Now in the data folder, there are two files as I mentioned earlier…
Encipher
- 1,370
- 1
- 14
- 31
1
vote
0 answers
Replace \N in Canvas LMS API calls to be NULL
I am extracting data from the Canvas API and the flat files that it creates have a \N in columns that do not have any data. I believe it is representing a NULL and I would like to know if the \N can be switched to a NULL during the GET phase of the…
Michael Docteroff
- 11
- 1
1
vote
1 answer
Why the fread() function is not reaching the end-of-file and the loop continues infinitely, while reading structures from a file?
The code snippet given below is a part of my Customer Billing System Project which I'm writing in C. Here I'm taking input of the Customer Data in a Customer structure and saving the entire structure in "CustomerRecord.dat" file using the…
Kalpadiptya Roy
- 95
- 1
- 11
1
vote
2 answers
every value in a row treated as new column - convert to loadable data file
I have a data file where every row value is shown as a new column entry. I want to convert this or find a logic to make this file loadable to a database. Below is sample of how the data is in the file.
The file is huge. It has more than >7000…
harsha87
- 55
- 6