Obv too big to open in Excel, but is there some other readily available software that can digest this and render it in a viewable/searchable form?

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131288)

https://github.com/superolmo/BigFiles

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131293)

actually what does it mean to review millions of rows? you're not actually lookin g at them all, right? break the file up and open one of the smaller files, or write code that loads 100 rows into memory and only loads the next 200 if you hit pgdown or something

or just load the data into a database and then query that

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48132848)

There's probably some kinda way to do this in Ultraedit but I don't know how to do computer.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131440)

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131484)

I'm gonna save your email addy so you can edit if you like, but from the ideas I've received here I've sent a request to this dude I've used before on Fiverr to see if he can do this.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131829)

This is the biggest hurdle we face with judges. I hand them a copy of the SCOTUS case with the relevant passage highlighted, and they're like, "Are you sure this is still good law??"

(A "volume discount" is legal so long as it is available to all competitors, and practically usable to them -- e.g., you can't have a tier with 50% lower pricing for 1M+ units)

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131657)

areda is one of the only textbooks i retained from ls

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131667)

In reality it never does, b/c the largest increment of shipment is the "truckload," so the cost savings for consumer goods actually plateaus pretty quickly.

But: The RPA anticipated exactly this concern with the "cost justification" defense -- if the supplier can show that its lower price to a given customer was in fact justified by its lower costs in supplying that customer, the discriminatory price is legal. In reality though, in every case we've had, the defendant's own data has shown that it's MORE costly to supply Walmart and Costco than to supply their independent competitors. The reason is that those guys have all sorts of packaging and specific delivery requirements, whereas for the indies the supplier just drops off a pallet at their loading dock at its convenience.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48134822)

1. sed Command

sed 's/|/,/g' input.txt > output.csv

2. awk Command

awk -F'|' -v OFS=',' '{ $1=$1; print }' input.txt > output.csv

3. tr Command

tr '|' ',' < input.txt > output.csv

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131349)

If I upload a 6GB txt file, with |-delimited fields, can you convert it for me into a CSV file?

ChatGPT said:

ChatGPT

Yes, I can help convert your 6GB text file with |-delimited fields into a CSV file. Please go ahead and upload the file, and I'll process it for you.

You said:

Even if it has 3,000,000 rows?

ChatGPT said:

ChatGPT

Yes, I can handle large files with millions of rows, including those with 3,000,000 rows. The process may take some time depending on the exact file structure, but I'll be able to convert it for you. Feel free to upload the file, and I'll start working on the conversion to CSV.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131362)

If it came to it, they'd say to the bald defensemos: "You're obviously able to export sales data, as shown by you having exported select data of Epah's clients when you filed that stupid motion to compel arbitration. So just export the parts he's asking for."

But as someone above said, easier just to work my way through this than spend 45 days to get to that ^^ result.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48132451)

nocode shit still has maybe another year or two before it's usable for your purposes (ie someone starting from 0 trying to do anything other than make a webapp)

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131656)

ITT has been EXTREMELY useful for figuring out how to do this, confirming that I really like it here.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131719)

I'm assuming this is some headerless CSV file? Your code would be as simple as something like

import pandas as pd

data = pd.read_csv('faggotdiscovery.txt', sep=",", header=None)

data.columns = ["Order Number", "Date", "Customer Name", "etc."]

filtered_df = df[df["Customer Name"].str.contains("JOHN SMITH")]

filtered_df.to_excel("JOHN SMITH.xlsx")

If you have a lot of names you could feed them to the script in a loop by reading out of excel or whatever, but that's more fancy than you need to get if we're only doing a a few people.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131753)

o WALMART WAREHOUSE

o COSTCO

o TWM

o VONS MARKET

o RITE AID

o CVS

o RALPHS

o SMART & FINAL

o ALBERTSONS

Plus our five guys.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131797)

but can't you just chuck the thing in relativity or whatever lawyers use these days?

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48131819)

Amazon Athena is an interactive query service that makes it easy to analyze data directly from Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to set up or manage and you can start analyzing your data immediately. You don’t even need to load your data into Athena, or have complex ETL processes. Athena works directly with data stored in S3.

https://aws.amazon.com/athena/

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48132557)

and then import the txt file as a dataset

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48132725)

OTOH if I had to match each pixel in each matrice to some value in a relational database, no software I know of could do it out of the box, and you'd probably want to do it on the cloud or a $20k homebrew server.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48135243)

> if i have a CSV file with 3 million rows, give me a python script to lazily read the file, only displaying the next line when I press a key

To achieve this in Python, you can utilize the csv module and input function for user input. Here's a script that will lazily read a CSV file, displaying the next line when you press a key:

python

import csv

def lazy_read_csv(filename):

with open(filename, 'r') as file:

csv_reader = csv.reader(file)

next(csv_reader) # Skip header if present

for row in csv_reader:

yield row

input("Press Enter to display the next line...")

# Replace 'your_file.csv' with the path to your CSV file

csv_file = 'your_file.csv'

for row in lazy_read_csv(csv_file):

print(row)

the whitespace is all fucked up thanks xo, but the original source looks correct to me; i only asked AI because i couldn't remember python standard library modules since i don't write in python often

this will display one line at a time, displaying the next only when you hit enter (i'd prompted any key, but it gave me enter; close enough)

you could change this to a pg-down like feature by having it read 20 lines at a time or something

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48135057)

“Okay sir

Let me see the link

Sorry for the late reply sir”

I could get used to this.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48132963)

"I will take some time to see the files and create the python script so please give me some time"

Maybe I should save him some time like, "my internet friends proposed the following script"

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48134838)

"Okay great sir, One more thing sir, I am also a web application developer and also wordpress developer if you need any help for building business web application or wordpress website I am happy to help you with that with minimum cost."

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48135011)

I can't imagine any xo poster being as helpful as this kindly gentleman.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48135304)

And now that I can see what the content looks like, the next task is to extract the sales to our clients and to the favored chains. With that, we can compare the pricing, and show that the defensemo was charging illegally high prices to our clients compared to what it charged to the chains for the same item at the same time.

(http://www.autoadmit.com/thread.php?thread_id=5601362&forum_id=2...id#48135120)